MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Test Architect Masters Program

Course Summary

Our Test Architect Masters Program lets you become Test Architect. You will work on real world projects in Hadoop testing, Selenium testing, Software/Manual testing, ETL testing, Linux and more. In this program you will cover 8 courses and 16 industry based projects

  • +

    Course Syllabus

    Selenium Course Content

    Getting started with Selenium
    Introduction to Selenium testing, understanding significance of automation testing, benefits of Selenium automation testing, comparison of Selenium and Quick Test Professional
    Selenium Features
    Understanding the Selenium Integrated Development Environment, the concept of Selenium Remote Control, working with Selenium Grid, Selenium Web Grid
    Deep Dive into Selenium IDE
    Detailed understanding of the Selenium IDE features, addition of script assertions, General Selenese commands, deploying the first Selenium Script and Options, IDE Test Suite, sample project IDE, recording Selenium test case, Selenium limitations.Hands-on Exercise – Record a test case, Execute First test case
    Selenium Web driver Automation
    The basic Architecture of Selenium Web Driver, download and installation, creating a Java function and executingHands-on Exercise – Install selenium web driver
    Fire Path Installation
    Deploying Web Drivers for scripting, getting the HTML source of Web Element, Table and Form Elements, Firebug extension and Fire Path installation.Hands-on Exercise – Set up a Grid
    Searching Elements
    Locator, Locator-ID, Deploying searching elements using the link text, name, using XPath, searching elements using CSS and Web Element PropertiesHands-on Exercise – Deploy searching elements using the link text, using name, using XPath, Search elements using CSS and Web Element Properties
    Advance User Interactions and Cross Browser Testing
    Working with Advanced User Interactions, understanding the various features like Drag and Drop, Double Click, Keys and Context, deploying Cross Browser Testing using Web Driver, Executing tests in Chrome and Firefox.Hands-on Exercise – Deploy and execute a test case for Chrome, Deploy and execute a test case for Firefox
    Introduction to TestNG Plugin
    Installation of TestNG Plugin in Eclipse, TestNG sample script, understanding Selenium test script writing, TestNG test suites creation, html and xml report generation using TestNGHands-on Exercise – Install TestNG plugin in Eclipse, Write a TestNG script and execute, Generate an html report, Generate an xml report
    TestNG Terminologies
    Annotations, Parameters, Groups- Include and Exclude, Test Result, Data ProvidersHands-on Exercise – Mark annotation Group test results
    TestNg Data Providers
    TestNg Data Providers, Screenshot on failed Test cases, Wait statements of Web Driver, Wait in Selenium, Explicit wait, Implicit wait, Fluent wait, PageLoad TimeoutHands-on Exercise – Capture screenshot on a failed test case Setup wait timeout to wait for page load before resuming test execution
    Maven Integration
    Introduction to Maven, Maven Usage, Configuring Maven with Eclipse, Taking automatic updates, running tests in Maven, Creating POM.xml file
    Maven Integration Tool
    Maven Integration Tool
    Web Driver Sample Programs
    Learn to work with text box, button, link, checkbox, drop down and radio button, Selecting and Displaying Values, Writing all values in Notepad/Excel/WordPad, Capturing screenshot (positive), On Load Alerts, Scroll down Page in JavaScript’s, HTML Unit driver, Managing Multiple Windows and AJAX Auto suggestions, Managing Web TablesHands-on Exercise – Use text box, button, checkbox, drop down, radio buttons, display views, Capture screenshot, Manage web tables
    JUNIT Operations and Test Framework
    Annotations in JUNIT, Methods in JUNIT, JUNIT Test Suites, ANT Build and JUNIT reporting, Test Framework, Data driven framework, Keyword driven framework, Hybrid framework, Execution of Test case from Test FrameworkHands-on Exercise – Load an excel file, Execute a test case using Data driven framework, Execute a test case using Keyword driven framework
    Object Repository
    Understanding of Object Repository, using OR in Scripts, learning sample scripts using object repository, Page Object Modeling, Page FactoryHands-on Exercise – Using OR in scripts, Implement POM
    Test Data Management
    Test Data ManagementHands-on Exercise – Load an excel file, Execute a test case using Data driven framework, Execute a test case using Keyword driven framework
    Selenium Grid Concept
    Selenium Grid Overview, Executing single script in different browsers and different scripts in different browsersHands-on Exercise – Set up a Grid
    Mobile App Testing using Appium
    UI Automator Framework in Appium, Locating elements in android app using UI Automator view, Automation testing for Android appsHands-on Exercise – Write a test case using UIAutomator for an Android app

    Big Data Hadoop Course Content

    Introduction to Big Data & Hadoop and its Ecosystem, Map Reduce and HDFS
    What is Big Data, Where does Hadoop fit in, Hadoop Distributed File System – Replications, Block Size, Secondary Namenode, High Availability, Understanding YARN – ResourceManager, NodeManager, Difference between 1.x and 2.x
    Hadoop Installation & setup

    Hadoop 2.x Cluster Architecture , Federation and High Availability, A Typical Production Cluster setup , Hadoop Cluster Modes, Common Hadoop Shell Commands, Hadoop 2.x Configuration Files, Cloudera Single node cluster

    Deep Dive in Mapreduce
    How Mapreduce Works, How Reducer works, How Driver works, Combiners, Partitioners, Input Formats, Output Formats, Shuffle and Sort, Mapside Joins, Reduce Side Joins, MRUnit, Distributed Cache
    Lab exercises:
    Working with HDFS, Writing WordCount Program, Writing custom partitioner, Mapreduce with Combiner , Map Side Join, Reduce Side Joins, Unit Testing Mapreduce, Running Mapreduce in LocalJobRunner Mode
    Graph Problem Solving
    What is Graph, Graph Representation, Breadth first Search Algorithm, Graph Representation of Map Reduce, How to do the Graph Algorithm, Example of Graph Map Reduce,
      Exercise 1: Exercise 2:Exercise 3:
    Detailed understanding of Pig

    A. Introduction to Pig

    Understanding Apache Pig, the features, various uses and learning to interact with Pig

    B. Deploying Pig for data analysis

    The syntax of Pig Latin, the various definitions, data sort and filter, data types, deploying Pig for ETL, data loading, schema viewing, field definitions, functions commonly used.

    C. Pig for complex data processing

    Various data types including nested and complex, processing data with Pig, grouped data iteration, practical exercise

    D. Performing multi-dataset operations

    Data set joining, data set splitting, various methods for data set combining, set operations, hands-on exercise

    E. Extending Pig

    Understanding user defined functions, performing data processing with other languages, imports and macros, using streaming and UDFs to extend Pig, practical exercises

    F. Pig Jobs

    Working with real data sets involving Walmart and Electronic Arts as case study
    Detailed understanding of Hive

    A. Hive Introduction

    Understanding Hive, traditional database comparison with Hive, Pig and Hive comparison, storing data in Hive and Hive schema, Hive interaction and various use cases of Hive

    B. Hive for relational data analysis

    Understanding HiveQL, basic syntax, the various tables and databases, data types, data set joining, various built-in functions, deploying Hive queries on scripts, shell and Hue.

    C. Data management with Hive

    The various databases, creation of databases, data formats in Hive, data modeling, Hive-managed Tables, self-managed Tables, data loading, changing databases and Tables, query simplification with Views, result storing of queries, data access control, managing data with Hive, Hive Metastore and Thrift server.

    D. Optimization of Hive

    Learning performance of query, data indexing, partitioning and bucketing

    E. Extending Hive

    Deploying user defined functions for extending Hive

    F. Hands on Exercises – working with large data sets and extensive querying

    Deploying Hive for huge volumes of data sets and large amounts of querying

    G. UDF, query optimization

    Working extensively with User Defined Queries, learning how to optimize queries, various methods to do performance tuning.


    A. Introduction to Impala

    What is Impala?, How Impala Differs from Hive and Pig, How Impala Differs from Relational Databases, Limitations and Future Directions, Using the Impala Shell

    B. Choosing the Best (Hive, Pig, Impala)

    C. Modeling and Managing Data with Impala and Hive

    Data Storage Overview, Creating Databases and Tables, Loading Data into Tables, HCatalog, Impala Metadata Caching

    D. Data Partitioning

    Partitioning Overview, Partitioning in Impala and Hive

    (AVRO) Data Formats

    Selecting a File Format, Tool Support for File Formats, Avro Schemas, Using Avro with Hive and Sqoop, Avro Schema Evolution, Compression

    Introduction to Hbase architecture

    What is Hbase, Where does it fits, What is NOSQL

    Apache Spark

    A. Why Spark? Working with Spark and Hadoop Distributed File System

    What is Spark, Comparison between Spark and Hadoop, Components of Spark

    B. Spark Components, Common Spark Algorithms-Iterative Algorithms, Graph Analysis, Machine Learning

    Apache Spark- Introduction, Consistency, Availability, Partition, Unified Stack Spark, Spark Components, Scalding example, mahout, storm, graph

    C. Running Spark on a Cluster, Writing Spark Applications using Python, Java, Scala

    Explain python example, Show installing a spark, Explain driver program, Explaining spark context with example, Define weakly typed variable, Combine scala and java seamlessly, Explain concurrency and distribution., Explain what is trait, Explain higher order function with example, Define OFI scheduler, Advantages of Spark, Example of Lamda using spark, Explain Mapreduce with example

    Hadoop Cluster Setup and Running Map Reduce Jobs

    Multi Node Cluster Setup using Amazon ec2 – Creating 4 node cluster setup, Running Map Reduce Jobs on Cluster

    Major Project – Putting it all together and Connecting Dots

    Putting it all together and Connecting Dots, Working with Large data sets, Steps involved in analyzing large data

    ETL Connectivity with Hadoop Ecosystem

    How ETL tools work in Big data Industry, Connecting to HDFS from ETL tool and moving data from Local system to HDFS, Moving Data from DBMS to HDFS, Working with Hive with ETL Tool, Creating Map Reduce job in ETL tool, End to End ETL PoC showing big data integration with ETL tool.

    Cluster Configuration

    Configuration overview and important configuration file, Configuration parameters and values, HDFS parameters MapReduce parameters, Hadoop environment setup, ‘Include’ and ‘Exclude’ configuration files, Lab: MapReduce Performance Tuning

    Administration and Maintenance

    Namenode/Datanode directory structures and files, File system image and Edit log, The Checkpoint Procedure, Namenode failure and recovery procedure, Safe Mode, Metadata and Data backup, Potential problems and solutions / what to look for, Adding and removing nodes, Lab: MapReduce File system Recovery

    Monitoring and Troubleshooting

    Best practices of monitoring a cluster, Using logs and stack traces for monitoring and troubleshooting, Using open-source tools to monitor the cluster

    Job Scheduler: Map reduce job submission flow

    How to schedule Jobs on the same cluster, FIFO Schedule, Fair Scheduler and its configuration

    Multi Node Cluster Setup and Running Map Reduce Jobs on Amazon Ec2

    Multi Node Cluster Setup using Amazon ec2 – Creating 4 node cluster setup, Running Map Reduce Jobs on Cluster


    ZOOKEEPER Introduction, ZOOKEEPER use cases, ZOOKEEPER Services, ZOOKEEPER data Model, Znodes and its types, Znodes operations, Znodes watches, Znodes reads and writes, Consistency Guarantees, Cluster management, Leader Election, Distributed Exclusive Lock, Important points

    Advance Oozie

    Why Oozie?, Installing Oozie, Running an example, Oozie- workflow engine, Example M/R action, Word count example, Workflow application, Workflow submission, Workflow state transitions, Oozie job processing, Oozie security, Why Oozie security?, Job submission, Multi tenancy and scalability, Time line of Oozie job, Coordinator, Bundle, Layers of abstraction, Architecture, Use Case 1: time triggers, Use Case 2: data and time triggers, Use Case 3: rolling window

    Advance Flume

    Overview of Apache Flume, Physically distributed Data sources, Changing structure of Data, Closer look, Anatomy of Flume, Core concepts, Event, Clients, Agents, Source, Channels, Sinks, Interceptors, Channel selector, Sink processor, Data ingest, Agent pipeline, Transactional data exchange, Routing and replicating, Why channels?, Use case- Log aggregation, Adding flume agent, Handling a server farm, Data volume per agent, Example describing a single node flume deployment

    Advance HUE

    HUE introduction, HUE ecosystem, What is HUE?, HUE real world view, Advantages of HUE, How to upload data in File Browser?, View the content, Integrating users, Integrating HDFS, Fundamentals of HUE FRONTEND

    Advance Impala

    IMPALA Overview: Goals, User view of Impala: Overview, User view of Impala: SQL, User view of Impala: Apache HBase, Impala architecture, Impala state store, Impala catalogue service, Query execution phases, Comparing Impala to Hive

    Hadoop Application Testing

    Why testing is important, Unit testing, Integration testing, Performance testing, Diagnostics, Nightly QA test, Benchmark and end to end tests, Functional testing, Release certification testing, Security testing, Scalability Testing, Commissioning and Decommissioning of Data Nodes Testing, Reliability testing, Release testing

    Roles and Responsibilities of Hadoop Testing Professional

    Understanding the Requirement, preparation of the Testing Estimation, Test Cases, Test Data, Test bed creation, Test Execution, Defect Reporting, Defect Retest, Daily Status report delivery, Test completion, ETL testing at every stage (HDFS, HIVE, HBASE) while loading the input (logs/files/records etc) using sqoop/flume which includes but not limited to data verification, Reconciliation, User Authorization and Authentication testing (Groups, Users, Privileges etc), Report defects to the development team or manager and driving them to closure, Consolidate all the defects and create defect reports, Validating new feature and issues in Core Hadoop.

    Framework called MR Unit for Testing of Map-Reduce Programs

    Report defects to the development team or manager and driving them to closure, Consolidate all the defects and create defect reports, Responsible for creating a testing Framework called MR Unit for testing of Map-Reduce programs.

    Unit Testing

    Automation testing using the OOZIE, Data validation using the query surge tool.

    Test Execution

    Test plan for HDFS upgrade, Test automation and result

    Test Plan Strategy and writing Test Cases for testing Hadoop Application

    How to test install and configure

    Job and Certification Support

    Cloudera Certification Tips and Guidance and Mock Interview Preparation, Practical Development Tips and Techniques

    SQL Course Content

    Introduction to SQL

    The various types of databases, introduction to Structured Query Language, distinction between client server and file server databases, understanding SQL Server Management Studio, SQL Table basics, data types and functions, Transaction-SQL, authentication for Windows, Data control language, Identification and Keywords in T-SQL, Drop Table.

    SQL operators

    Introduction to relational databases, basic concepts of relational tables, working with rows and columns, various operators used like logical and relational, domains, constraints, stored procedures, indexes, primary key and foreign key, understanding group functions, unique key.

    Working With SQL –Join,Tables,Variables

    Deep dive into SQL Tables, working with SQL functions, operators and queries, creation of tables, retrieving data from tables, combining rows from tables using Inner, Outer, Cross and Self joins, deploying Operators like Union, Intersect, Except, creation of Temporary Table, Set Operator rules, working with Table variables.

    Deep dive into SQL Functions

    Understanding what SQL functions do, aggregate functions, scalar functions, functions that work on different data sets like numbers, characters & strings, dates, learning Inline SQL functions, general functions and duplicate functions.


    Understanding of SQL Subqueries, rules of Subqueries, the statements and operators with which Subqueries can be used, modification of sub queries using set clause, understanding the different types of Subqueries – Where, Insert, Update, Select, Delete, etc., ways to create and view Subqueries.

    SQL Views,Functions,Stored Procedures

    Learning about SQL Views, ways of creating, using, altering, dropping, renaming and modifying Views, understanding Stored Procedures, key benefits of it, working with Stored Procedures, error handling, studying user-defined functions.

    Deep Dive into User-defined Functions

    Detailed study of user-defined functions, various types of UDFs like Scalar, Inline Table Value, multi-statement Table, what are Stored Procedures? when to deploy Stored Procedures? What is Rank Function? Triggers, when to execute Triggers?

    SQL Optimization& Performance

    Detailed understanding of SQL Server Management Studio, learning what is Pivot in Excel and SQL Server, XL path, differentiating between Char, Varchar and NVarchar, working with Indexes, creation of Index, advantages, records grouping, searching, sorting, modifying data, creation of clustered indexes, using index to cover queries, index guidelines and Common Table Expression.

    Oracle PL SQL Course Content

    Introduction to Oracle SQL
    What is RDBMS, Oracle versions, Architecture of Oracle Database Server, Installation of Oracle 12c

    Hands-on Exercise – Install Oracle 12c

    Using DDL Statements to Create and Manage Tables
    Categorize the main database objects, Review the table structure, List the data types that are available for columns, Create a simple table, Explain how constraints are created at the time of table creation, Describe how schema objects work

    Hands-on Exercise – Create a database table Person with two column (Name, Age) with constraint on age not greater than 100, Insert records using insert query

    Retrieving Data Using the SQL SELECT Statement

    List the capabilities of SQL SELECT statements, Execute a basic SELECT statement

    Hands-on Exercise – Use a basic select statement to retrieve all the records in the Person table

    Restricting and Sorting Data
    Limit the rows that are retrieved by a query, Sort the rows that are retrieved by a query, Ampersand substitution to restrict and sort output at runtime

    Hands-on Exercise – Write a select query to retrieve records where age is more than 60 yrs, Write a select query to sort the records by name, Write a select query to sort the records by age in descending order, Use ampersand substitution to restrict and sort output at runtime

    General functions
    The general functions in SQL, working with any data type and handling Null values, using COALESCE() and Null function, Constructing and executing SQL query that applies the NUL, NUL1, NUL2 and COALESCE()

    Hands-on Exercise – Use NULL function to deal with null values in data

    Using Single-Row Functions to Customize Output
    Describe various types of functions (character, number, date, string etc.) available in SQL

    Hands-on Exercise – Create a table with columns of type char, number and date, Use character, number, and date functions in SELECT statements

    Large Object Functions
    Large object functions – BFILENAME, EMPTY_BLOB, EMPTY_CLOB, Aggregate or Group functions – COUNT, COUNT(*),MIN,MAX,SUM,AVG,etc…,Group BY Clause, HAVING Clause

    Hands-on Exercise – Count records based on a condition, Use Count(*) to know the count of all records, Find Max, Min, Sum, Avg

    OLAP Functions
    The various OLAP functions, cube, model clause, roll up and grouping functions

    Hands-on Exercise – Working with OLAP commands – Cube, Roll Up, etc.

    Using Conversion Functions and Conditional Expressions
    Describe various types of conversion functions that are available in SQL, Conditional expressions in a SELECT statement

    Hands-on Exercise – Group data by using the GROUP BY clause, Include or exclude grouped rows by using the HAVING clause

    Displaying Data from Multiple Tables
    Joins, Inner Join, Outer Join, Left Join, Right Join, Equijoins and Non-equijoins

    Hands-on Exercise – Write SELECT statements to access data from more than one table using equijoins and non equijoins, Join a table to itself by using a self-join, View data that generally does not meet a join condition by using outer joins, Generate a Cartesian product of all rows from two or more tables

    Using Subqueries to Solve Queries
    Define subqueries, Describe the types of problems that the subqueries can solve, List the types of subqueries

    Hands-on Exercise – Write single-row and multiple-row subqueries

    Using the Set Operators
    Describe set operators, UNION [ALL], INTERSECT, MINUS Operators

    Hands-on Exercise – Use a set operator to combine multiple queries into a single query Control the order of rows returned

    Manipulating Data using SQL
    Describe data manipulation language (DML) statement, Insert, Update, Delete Statements, Control transactions

    Hands-on Exercise – Insert rows into a table, Update rows in a table, Delete rows from a table

    Database Transactions
    What is a database transaction, Properties of a transaction (Atomic, Consistent, Isolated, Durable – ACID), Avoiding error/fault in manipulating database records using transaction

    Hands-on Exercise – Begin a transaction, Execute queries to update or insert or delete records, If no error, commit the transaction Else roll back the transaction and end it

    Creating Other Schema Objects
    Views – simple and complex, Sequences, Index, Synonym

    Hands-on Exercise – Create simple and complex views, Retrieve data from views, Create, maintain, and use sequences, Create and maintain indexes, Create private and public synonyms

    Writing Cursor and Conditional Statement
    SQL Cursor, SQL Cursor Attributes., Controlling PL/SQL flow of executions, IF Statement, Simple IF Statement, IF-THAN-ELSE Statement Execution Flow, IF-THAN-ELSE Statement, IF-THAN-ELSIF Statement, Logic Tables, Boolean Conditions., Iterative controlling loop statement, Nested Loops and Labels.

    Hands-on Exercise – Use Boolean condition on a select query, Use logic table, Create nested loops and labels

    Introduction to Explicit Cursor
    Writing Explicit cursors, About cursors, Explicit cursor functions, Controlling explicit cursor, Opening the cursor, Fetching Data cursor, Cursor and records, Cursor for loop using sub queries

    Hands-on Exercise – Write an explicit cursor, Use cursor function, Fetch data cursor

    Advance concepts of explicit Cursor
    Advance Explicit cursor, Cursor with parameters, For update Clause, Where current of Clause, Cursor with sub queries

    Hands-on Exercise – Use cursor with subquery, Use Where Current clause to retrieve data

    Exception Handling
    Handling Exception, Handling Exception with PL/SQLPredefined Exceptions, User Defined Exceptions, Non-Predefined Error, Function for trapping Exception, Trapping user-defined Exception, Raise Application Error Procedure

    Hands-on Exercise – Use Predefined exception, Write user defined exception, Generate and handle exception, Use a function for trapping an exception

    Writing Subprogram, Procedure and passing parameters
    Overview of subprograms, PL/SQL Subprograms, What is Procedure, Syntax for creating Procedure, Creating Procedure with parameter, Example of Passing parameters, Referencing a public variable from a standalone procedure, Declaring Subprogram

    Hands-on Exercise – Create a parameterized procedure, Pass parameters in a procedure call, Access a public variable from a standalone procedure

    Creating PL/SQL Package
    PL/SQL records, Using Pl/SQL Table method and example, Creating PL/SQL Table, Packages – Objective, overview, component, developing, removing, advantages, Creating the package specification/example, Declaring Public construct, Public and private construct, Invoking package construct, Guide lines for deploying packages

    Hands-on Exercise – Create a package, Deploy the created package

    Advance Package Concepts and functions
    Overloading, Using forward declaration, One time only procedure, Package functions, User define package function, Persistent state of package function, Persistent state of package variable, Controlling the persistent state of package cursor, Purity end, Using supplied package, Using native dynamic SQL, Execution flow, Using DBMS-SQL package, Using DBMS-DDL package, Submitting jobs, Interacting with operating system links

    Hands-on Exercise – Use supplied package, Use native dynamic SQL, Use DBMS-SQL package, Use DBMS-DDL package, Submit a job

    Introduction and writing Triggers
    Triggers – Definition, objective and its event type, Application & database triggers, Business application scenarios for implementing triggers, Define DML triggers, Define Non – DML triggers, Triggers event type & body, Creating DML triggers using the create triggers statement, Define statement level triggers v/s low level triggers, Triggers firing sequence: single row manipulation, Creating a DML statement triggers, Using old and new qualifiers, Old and new qualifiers, Instead of triggers, Managing triggers using the alter & drop SQL statement, Testing triggers

    Hands-on Exercise – Create a DML statement trigger, Use old and new qualifiers, Manage a trigger using the alter & drop SQL statement, Test the created triggers

    Compound Triggers
    Viewing trigger information, Describe user triggers, What is a compound trigger and working with it, Compound trigger structure for tables, Timing-point sections of a table compound trigger, Compound trigger structure for views, Trigger restrictions on mutating tables, Compound trigger restrictions, Using a compound trigger to resolve the mutating table error, Creating triggers on system events, LOGON and LOGOFF triggers example, Call statements in triggers, Benefits of database-event triggers, System privileges required to manage triggers

    Hands-on Exercise – View a trigger’s information, Use a compound trigger structure for views, Use a compound trigger to resolve the mutating table error, Create triggers on system events, Use LOGON and LOGOFF triggers, Call statements in triggers

    Working with Dynamic SQL
    Dynamic SQL-objectives, Describe execution flow of SQL statements, Dynamic SQL with a DDL statement-example, Working with dynamic SQL, Native Dynamic SQL(NDS), Using the executive immediate statement-example, Using native dynamic SQL to compile PL/SQL code, Using DBMS-SQL with a DML statement, Using the DBMS-SQL package subprograms, Parameterized DML statement

    Hands-on Exercise – Use the executive immediate statement, Use native dynamic SQL to compile PL/SQL code, Create DBMS-SQL with a DML statement, Create a DBMS-SQL package subprograms

    Advance level- Scripting
    Managing Dependencies, Objectives, overview of schema object dependencies, Direct local dependencies, Querying direct object dependencies, Displaying direct and indirect dependencies, Fine-Grained dependency management, Changes to synonym dependencies, Maintaining valid PL/SQL program units and views, Object re-validation, Concepts of remote dependencies, Setting the remote dependencies mode parameter, Recompiling PL/SQL program unit, Packages and Dependencies, Successful and unsuccessful recompilation, Recompiling procedures

    Hands-on Exercise – Query direct object dependencies, Display direct and indirect dependencies, Set the remote dependencies mode parameter, Recompile PL/SQL program unit, Edit a procedure and recompile it

    Data Warehouse Course Content

    Introduction to Data Warehouse

    Introducing Data Warehouse and Business Intelligence, understanding difference between database and data warehouse, working with ETL tools, SQL parsing.

    Architecture of Data Warehouse

    Understanding the Data Warehousing Architecture, system used for Reporting and Business Intelligence, understanding OLAP vs. OLTP, introduction to Cubes.

    Data Modeling concepts

    The various stages from Conceptual Model, Logical Model to Physical Schema, Understanding the Cubes, benefits of Cube, working with OLAP multidimensional Cube, creating Report using a Cube.

    Data Normalization

    Understanding the process of Data Normalization, rules of normalization for first, second and third normal, BCNF, deploying Erwin for generating SQL scripts.

    Dimension & Fact Table

    The main components of Business Intelligence – Dimensions and Fact Tables, understanding the difference between Fact Tables & Dimensions, understanding Slowly Changing Dimensions in Data Warehousing.

    SQL parsing, Cubes & OLAP

    SQL parsing, compilation and optimization, understanding types and scope of cubes, Data Warehousing Vs. Cubes, limitations of Cubes and evolution of in-memory analytics.

    Erwin Design Layer Architecture

    Learning the Erwin model, understanding the Design Layer Architecture, data warehouse modeling, creating and designing user defined domains, managing naming and data type standards.

    Forward & Reverse Engineering

    Understanding of the forward and reverse engineering, comparison between the two.

    Software Testing Course Content

    Introduction to Software Testing

    Testing History, Testing description, Need for testing, Defect description, principles of Testing, Quality Assurance and control, Scope, Occurrence of Testing, Constraints of Testing, Software Tester Roles, SDLC Overview, Life Cycle models, STLC Overview, AGILE Testing

    Test Planning

    Test Strategy and Planning, Customizing Test Process, Budgeting Overview, Scheduling, Risk and configuration managementHands-on Exercise – Make planning to test a product and define test strategy for the same, Plan a dummy budget allocation

    Design of Testing

    Test Scenarios, cases and Data, Test Case and Scenario Difference, Test Case creation for application, Traceability Matrix and Sample descriptionHands-on Exercise – Create Test Cases for an application, Create Traceability Matrix, Perform sample testing

    Techniques of testing

    Dynamic Techniques:

    Black-box or Specification-based techniques, Boundary Value Analysis, Decision Table Testing, Equivalence Partitioning

    Experience-based techniques:

    Error Guessing, Exploratory Testing

    Static Techniques:

    Importance of STLC reviews, Review Activities, Roles and Responsibilities during ReviewHands-on Exercise – Do a Black-box or Specification-based testing, Perform Boundary Value Analysis, Test using Decision Table, Make a team of at least two people and do Review Activities of STLC

    Levels & Types of Testing

    Levels of Testing:

    Unit Testing, Integration Testing, System Testing, User Acceptance Testing

    Types of Testing:

    Regression Testing, Smoke Testing, Database Testing, Load Testing, Performance Testing, Compatibility Testing, Security Testing, Volume Testing, Stress Testing, Usability testing, Internationalization Testing, Localization TestingHands-on Exercise – Perform User Acceptance Testing based on requirements spec

    Executing test

    Overview on Build and Release, Release Notes, Pre QA Checklist, Entry and Exit criteria, Test Execution, Hands onHands-on Exercise – Write a typical Release Note, Make a QA Checklist

    Managing Defect

    Defect Prevention, Defect Discovery, Defect Life Cycle, Severity and Priority, Overview on RCA, Hands on Identify and log Defects, Bugzilla Tool – Hands onHands-on Exercise – Identify log Defects, Use Bugzilla Tool to log a defect and apply different stages of a bug (open, fixed, close etc)

    Team Collaboration & Reporting

    Test Status Reports, Test Closure Reports, Tester and Developer, Team Collaboration, Client Interaction, Onshore/Offshore Model, Mitigate current challengesHands-on Exercise – Write Test Status Report, Write a Test Closure Report

    Measurement & Metrics

    Overview on Metrics & Measurements, Test Metrics Benefits, Life Cycle of Metrics, Test Metrics typesHands-on Exercise – Write Test Metrics

    Testing Tools & FAQs

    Need for Automation, Overview of Different Automation Tools – QTP and Selenium, Quality Center Overview, FAQsHands-on Exercise – Use an Automation Tool (QTP or Selenium or Quality Center)

    ETL Testing Course Content

    ETL Testing Overview

    Introduction to ETL testing, life cycle of ETL Testing, database concepts, ETL in Business Intelligence, understanding the difference between OLTP and OLAP, data warehousing.Hands-on Exercise – Create OLTP and OLAP database

    Database Testing and Data Warehousing Testing

    Introduction to RDBMS, Relational database concepts, distinction between database and data warehousing testing, integrity constraints.Hands-on Exercise – how to test data warehousing testing, integrity constraints

    ETL Testing Scenarios

    The data warehouse workflow, ETL Testing scenarios, ETL Mapping, Data Warehouse Testing, Data Mismatch & Data Loss Testing.Hands-on Exercise – Create a data warehouse workflow, Create ETL Mapping

    Correctness, Completeness, Quality, Data Validation

    Introduction to various testing scenarios, structure validation, constraint validation, data correctness, completeness, quality, data validation, negative testing.Hands-on Exercise – Create tests as per testing scenarios, Validate structure of the software, Do constraint validation, Check data correctness and completeness, Validate data, Perform negative testing

    Data Checks with SQL

    Using SQL for checking data, understanding database structure, working with SQL ScriptsHands-on Exercise – Write SQL Scripts for checking data

    Reports & Cube testing

    Reports and Cube Testing, scope of Business Intelligence Testing.Hands-on Exercise – Identify ETL testing Scope-Generate Reports, Test Cubes

    Java Programming Course Content

    Core Java Concepts

    Introduction to Java Programming, Defining Java, Need for Java, Platform Independent in Java, Define JRE,JVM, JDK, Important Features and Evolution of Java

    Writing Java Programs using Java Principles

    Overview of Coding basics, Setting up the required environment, Knowing the available IDEs, Writing a Basic-level Java Program, Define Package, What are Java Comments?, Understanding the concept of Reserved Words, Introduction to Java Statements, What are Blocks in Java, Explain a Class, Different Methods

    Language Conceptuals
    Overview of the Language, Defining Identifiers, What are Constraints and Variables, What is an Encoding Set?, Concept of Separators, Define Primitives, How to make Primitive Conversions?, Various Operators in Java
    Operating with Java Statements
    Module Overview, Learn how to write If Statement, Understanding While Statement, Working with Do-while Statement, How to use For Statement?, Using Break Statement, What is Continue Statement, Working of Switch Statement
    Concept of Objects and Classes
    General Review of the Module, Defining Object and Classes in Java, What are Encapsulation, Static Members and Access Control?, Use and importance of ‘this’ Keyword, Deining Method Overloading with an example, ‘By Value’ vs. ‘By Reference’, Loading, Defining Initialization and Linking, How to Compare Objects in Java?, What is Garbage Collector?
    Introduction to Core Classes
    General Review, Concept of Object in Java, Define Core Class, What is System?, Explain String Classes, How do Arrays work?, Concept of Boxing & Unboxing, Use of ‘varargs’, ‘format’ and ‘printf’ Methods
    Inheritance in Java
    Introduction, Define Inheritance with an example, Accessibility concept, Method Overriding, Learning how to call a Superclass’ Constructor, What is Type Casting?, Familiarity with ’instanceof’ Keyword
    Exception Handling in Detail
    Getting started with exception Handling, Defining an Exception, How to use Constructs to deal with exceptions?, Classification of exceptions, Throw Exceptions, How to create an exception class?, stack Trace analysis
    Getting started with Interfaces and Abstract Classes
    General Review, Defining Interface, Use and Create and Interface, Concept of Extending interfaces, How to implement multiple interfaces?, What are abstract classes?, How to create and use abstract classes?, Comparison between interface and abstract classes, Concept of Nested Classes, What are Nested Classes?, Nested Classes Types, Working of an Inner Class, What is a Local Inner Class?, Anonymous Classes in java, What is a Static Nested Class
    Overview of Nested Classes
    What are Nested Classes?, Types of Nested Classes, What is an Inner Class?, Understanding local inner class, Anonymous Inner Class, Nested Class – Static
    Getting started with Java Threads
    What is a Thread?, How to create and start a Thread?, States of a Thread, Blocking the Execution of a Thread, Concept of Sleep Thread, Understanding the priorities in a thread, Synchronisation in Java Threads, Interaction between threads
    Overview of Java Collections
    Introduction to Collection Framework, Preeminent Interfaces, What are Comparable and Comparator?, Working with Lists, Working with Maps, Working with Sets, Working with Queues
    Understanding JDBC
    Define JDBC, Different types of Drivers, How to access the drivers?, What is Connection in Java?, What is a Statement?, Explaining CRUD Operations with examples, Prepared Statement and Callable Statement
    Java Generics
    Overview of important topics included, Important and Frequently-Used Features, Defining Generic List, What is Generic Map in Java?, Java Generic Classes & Methods, For Loop Generic, What is Generic Wild Card?
    Input/Output in Java
    Brief Introduction, Learning about Input and output streams in java, Concept of byte Oriented Streams, Defining Character Oriented Streams?, Explain Object Serialisation, Input and Output Based on Channel
    Getting started with Java Annotations
    Introduction and Definition of Annotations, How they are useful for Java programmers?, Placements in Annotations, What are Built-in Java Annotations, Defining Custom Annotations
    Reflection and its Usage
    Getting started, Define Java Reflection?, What is a Class Object?, Concept of Constructors, Using Fields, Applying Methods, Implementing Annotations in Your Java Program
    Selenium Projects
    Project 1 – JUnit Test CaseObjective– This is a hands-on project that includes working with the JUnit test case and deploying it for working on a specific site using a search engine. You will extensively compare the testing methods of TestNG and JUnit by working with both to understand the differences. This project includes integrating JUnit test case with the Apache Ant Tool which is an automation tool for building software. Work with Rational Quality Manager in JUnit, write Java codes for Selenium Web Driver testing application
    Project 2 :- Testing the website using Selenium WebdriverObjective – To test websites using Selenium webdriverRequirements:- Write Selenium scripts to:
    • Test the login screen with username and password
    • Test online widgets like date pickers, tabs, sliders
    • Test interactive actions like draggable, resizable, selectable etc
    • Test the filling up of registration form and submission
    • Test frames and windows
    • Test drop-down menus, alert boxes
    Prerequisites : Basic Java programming skillProblem Statement : Testing websites for various functionalities is a tedious task. Writing right test programs is the first step in that direction. How can we test our own programs using demo websites?
    Project 3 :- Record and play back tests in the actual environment using Selenium IDEObjective – Use Selenium IDE, which is implemented as a Firefox extension, to record and play back tests in the actual environmentRequirements : Write Selenium scripts to:
    • Record and playback an activity
    • Use Intelligent field selection feature to use IDs, names, or XPath
    • Use Autocomplete for common Selenium commands
    • Debug and set breakpoints in the code
    • Save tests as HTML file
    • Perform automatically assert the title of every page
    • Add new functionality to the API
    • Apply custom formats and export capabilities
    Project 4 :- Selenium Remote Control (RC) testing toolObjective – Write automated web application UI tests against any HTTP website using a JavaScript-enabled browser using Selenium Remote Control (RC) testing toolRequirements :
    • Use the RC server to automatically launch and kill browsers
    • Use client libraries for your favorite computer language
    • Write tests in your favourite programming language using Selenium Remote Control for testing complex AJAX-based web user interfaces under a Continuous Integration system
    Prerequisites : Any programming languageLab Environment :-
    • Selenium IDE
    • Chrome browser setup with Selenium driver
    • IE browser setup with Selenium driver
    • FireFox browser doesn’t need extra configuration
    What Hadoop Projects You will be working on?
    Project 1 – Working with MapReduce, Hive, Sqoop
    Topics : As part of this Big data Hadoop certification training, you will undergo the project which involves working on the various Hadoop components like MapReduce, Apache Hive and Apache Sqoop. Work with Sqoop to import data from relational database management system like MySQL data into HDFS. Deploy Hive for summarizing data, querying and analysis. Convert SQL queries using HiveQL for deploying MapReduce on the transferred data. You will gain considerable proficiency in Hive, and Sqoop after completion of this project.
    Project 2 – Work on MovieLens data for finding top records
    Data – MovieLens dataset
    Topics : In this project you will work exclusively on data collected through MovieLens available rating data sets. The project involves the following important components:
    • You will write a MapReduce program in order to find the top 10 movies by working in the data file
    • Learn to deploy Apache Pig create the top 10 movies list by loading the data
    • Work with Apache Hive and create the top 10 movies list by loading the
    Project 3 – Hadoop YARN Project – End to End PoC
    Topics : In this Big Data project you will work on a live Hadoop YARN project. YARN is part of the Hadoop 2.0 ecosystem that lets Hadoop to decouple from MapReduce and deploy more competitive processing and wider array of applications. You will work on the YARN central Resource Manager. The salient features of this project include:
    • Importing of Movie data
    • Appending the data
    • Using Sqoop commands to bring the data into HDFS
    • End to End flow of transaction data
    • Processing data using MapReduce program in terms of the movie data, etc.
    Project 4 – Partitioning Tables in Hive
    Topics : This project involves working with Hive table data partitioning. Ensuring the right partitioning helps to read the data, deploy it on the HDFS, and run the MapReduce jobs at a much faster rate. Hive lets you partition data in multiple ways like:
    • Manual Partitioning
    • Dynamic Partitioning
    • Bucketing
    This will give you hands-on experience in partitioning of Hive tables manually, deploying single SQL execution in dynamic partitioning, bucketing of data so as to break it into manageable chunks.
    Project 5 – Connecting Pentaho with Hadoop Ecosystem
    Topics : This project lets you connect Pentaho with the Hadoop ecosystem. Pentaho works well with HDFS, HBase, Oozie and Zookeeper. You will connect the Hadoop cluster with Pentaho data integration, analytics, Pentaho server and report designer. Some of the components of this project include the following:
    • Clear hands-on working knowledge of ETL and Business Intelligence
    • Configuring Pentaho to work with Hadoop Distribution
    • Loading, Transforming and Extracting data into Hadoop cluster
    Project 6 – Multi-node cluster setup
    Topics : This is a project that gives you opportunity to work on real world Hadoop multi-node cluster setup in a distributed environment. The major components of this project involve:
    • Running a Hadoop multi-node using a 4 node cluster on Amazon EC2
    • Deploying of MapReduce job on the Hadoop cluster
    You will get a complete demonstration of working with various Hadoop cluster master and slave nodes, installing Java as a prerequisite for running Hadoop, installation of Hadoop and mapping the nodes in the Hadoop cluster.
    • Hadoop Multi-Node Cluster Setup using Amazon ec2 – Creating 4 node cluster setup
    • Running Map Reduce Jobs on Cluster
    Project 7 – Hadoop Testing using MR
    Topics : In this project you will gain proficiency in Hadoop MapReduce code testing using MRUnit. You will learn about real world scenarios of deploying MRUnit, Mockito, and PowerMock. Some of the important aspects of this project include:
    • Writing JUnit tests using MRUnit for MapReduce applications
    • Doing mock static methods using PowerMock&Mockito
    • MapReduceDriver for testing the map and reduce pair
    After completion of this project you will be well-versed in test driven development and will be able to write light-weight test units that work specifically on the Hadoop architecture.
    Project 8 – Hadoop Weblog Analytics
    Data – Weblogs
    Topics : This project is involved with making sense of all the web log data in order to derive valuable insights from it. You will work with loading the server data onto a Hadoop cluster using various techniques. The various modules of this project include:
    • Aggregation of log data
    • Processing of the data and generating analytics
    The web log data can include various URLs visited, cookie data, user demographics, location, date and time of web service access, etc. In this project you will transport the data using Apache Flume or Kafka, workflow and data cleansing using MapReduce, Pig or Spark. The insight thus derived can be used for analyzing customer behavior and predict buying patterns.
    Project 9 – Hadoop Maintenance
    Topics : This project is involved with working on the Hadoop cluster for maintaining and managing it. You will work on a number of important tasks like
    • Administration of distributed file system
    • Checking the file system
    • Working with name node directory structure
    • Audit logging, data node block scanner, balancer
    • Learning about the properties of safe mode
    • Entering and exiting safe mode
    • HDFS federation and high availability
    • Failover, fencing, DISTCP, Hadoop file formats
    SQL Project

    Project – Writing complex Sub Queries

    Topics – This project will give you hands-on experience in working with SQL sub-queries and utilizing it in various scenarios. Some of the sub-queries that you will be working with and gain hands-on experience in are – IN or NOT IN, ANY or ALL, EXISTS or NOT EXISTS, and other major queries.

    Oracle PL SQL Project

    Project – DML

    Topics – In this project you will learn about the Data Manipulation Language (DML), understand all about the DML triggers which are a special type of stored procedures that are automatically executed when DML operation is performed. You will learn about the various DML operations like INSERT, UPDATE, or DELETE which when fired on a Table or View can activate a DML Trigger. This project involves working with database and application Triggers, deploying the Triggers for various business applications and testing of the DML Triggers.

    Data Warehouse Project

    Project 1– Logical & Physical Data Modeling Using ERWin

    Data – Invoice Management (Sales)

    Topics–This project is involved with creating logical and physical data model using the CA Erwin data modeler design layer architecture. You will learn about the techniques for turning a logical model into a physical design. With this project you will be well-versed in the process of reverse and forward engineering. You will understand both the top down and bottom up design methodology.

    Project 2– End-to-End implementation of Data Warehouse (Retail Store)

    Data –Sales

    Topics – In this project you will learn about the process of loading data into a data warehouse using the ETL tools. You will learn about the ways to create and deploy the data warehouse. Oracle provides support for multiple physical but only one logical model in the data warehouse. This project will provide you extensive experience in integrating, cleansing, customization and insertion of data in the data warehouse for a retail store.

    Software Testing Project

    Project – Sign Up Test Case

    Topics – This is project for testing of a typical signup case which is so typical of major websites like eCommerce, or even a B2B services website. You will deploy the tools needed in order to do the testing of this sign up page to detect the bugs or anomalies and check it rigorously for various test case scenarios and come up with a detailed result of the particular testing in this project.

    ETL Testing Project

    Project – Testing Cube

    Data – Sales

    This ETL testing project will provide you with hands-on experience in testing of a multidimensional cube of sales data that includes sales for five years for multiple products. Some of the steps you will be performing in the testing of the cube are validating the dimensions and connections, selecting and matching the data, verifying the dimension hierarchies, validating measures in associ

Course Fee:
USD 597

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url