Online Tutorials & Training Materials | STechies.com
Register Login
Add Institute / Course


Gyansetu Training Centre, Gurgaon

2nd floor, HUDA MAIN MARKET, Sector 31 Gurgaon
Haryana India(IN)122003

122003
: +91 9999 201 478 ,96500 12935
: Institute

Write a Review Claim Your Ownership

INFO

iClass Gyansetu Gurgaon is a Redhat Certified Company founded in 2009 by IIT, NIT, BITS alums with a vision to impart quality education.
We have delivered 32500+ training to our students, 250+ Corporate Training & 100+ Real Time Projects in our world's class infrastructure based in Sector 31 Gurgaon.

We provide training on following Technologies-

  • Big Data Hadoop
  • Data Analytics
  • Cloud Computing
  • Amazon Web Services
  • Salesforce Cloud
  • Software testing
  • Database Management
  • Networking
  • Web Development - Java, Php, .Net, Python
  • Advanced Excel VBA
  • SAS, R Programming
  • SQL, Informatica & Oracle
  • Android Development
  • Selenium Testing
  • Redhat Linux
  • Our Presence is in Pune, Nagpur, Gurgaon, Jaipur, Kota, Ahmedabad

    Our trainers are working in top MNCs having 10+ years.

    Why to join Gyansetu?

  • Real Time Projects
  • 24x7 lifetime assistance till you get job.
  • 100% Placement
  • Website: www.gyansetu.in

    Head Office Address: 2nd Floor, Main Market, Sector 31 Gurgaon
    Call: 9999201478/ 8130799520

    COURSES

    Course Details

    Course

    Big Data Hadoop training will make you expert in HDFS, Yarn, MapReduce, Pig, Hive, HBase, Oozie, Flume and Sqoop using real-time use cases on Retail, Social Media, Aviation, Tourism, Finance domain. You will get Gyansetu Hadoop certification at the end of the course.

    1. Understanding Big Data and Hadoop

    Learning Objectives – In this module, you will understand Big Data, the limitations of the existing solutions for Big Data problem, how Hadoop solves the Big Data problem, the common Hadoop ecosystem components, Hadoop Architecture, HDFS, Anatomy of File Write and Read, how MapReduce Framework works.

    Topics – Big Data, Limitations and Solutions of existing Data Analytics Architecture, Hadoop, Hadoop Features, Hadoop Ecosystem, Hadoop 2.x core components, Hadoop Storage: HDFS, Hadoop Processing: MapReduce Framework, Hadoop Different Distributions.

    2. Hadoop Architecture and HDFS

    Learning Objectives – In this module, you will learn the Hadoop Cluster Architecture, Important Configuration files in a Hadoop Cluster, Data Loading Techniques, how to setup single node and multi node hadoop cluster.

    Topics – Hadoop 2.x Cluster Architecture – Federation and High Availability, A Typical Production Hadoop Cluster, Hadoop Cluster Modes, Common Hadoop Shell Commands, Hadoop 2.x Configuration Files, Single node cluster and Multi-node cluster set up Hadoop Administration.

    3. Hadoop MapReduce Framework

    Learning Objectives – In this module, you will understand Hadoop MapReduce framework and the working of MapReduce on data stored in HDFS. You will understand concepts like Input Splits in MapReduce, Combiner & Partitioner and Demos on MapReduce using different data sets.

    Topics – MapReduce Use Cases, Traditional way Vs MapReduce way, Why MapReduce, Hadoop 2.x MapReduce Architecture, Hadoop 2.x MapReduce Components, YARN MR Application Execution Flow, YARN Workflow, Anatomy of MapReduce Program, Demo on MapReduce. Input Splits, Relation between Input Splits and HDFS Blocks, MapReduce: Combiner & Partitioner, Demo on de-identifying Health Care Data set, Demo on Weather Data set.

    4. Advanced MapReduce

    Learning Objectives – In this module, you will learn Advanced MapReduce concepts such as Counters, Distributed Cache, MRunit, Reduce Join, Custom Input Format, Sequence Input Format and XML parsing.

    Topics – Counters, Distributed Cache, MRunit, Reduce Join, Custom Input Format, Sequence Input Format, Xml file Parsing using MapReduce.

    5. PIG

    Learning Objectives – In this module, you will learn Pig, types of use case we can use Pig, tight coupling between Pig and MapReduce, and Pig Latin scripting, PIG running modes, PIG UDF, Pig Streaming, Testing PIG Scripts. Demo on healthcare dataset.

    Topics – About Pig, MapReduce Vs Pig, Pig Use Cases, Programming Structure in Pig, Pig Running Modes, Pig components, Pig Execution, Pig Latin Program, Data Models in Pig, Pig Data Types, Shell and Utility Commands, Pig Latin : Relational Operators, File Loaders, Group Operator, COGROUP

    Operator, Joins and COGROUP, Union, Diagnostic Operators, Specialized joins in Pig, Built In Functions ( Eval Function, Load and Store Functions, Math function, String

    Function, Date Function, Pig UDF, Piggybank, Parameter Substitution ( PIG macros and Pig Parameter substitution ), Pig Streaming, Testing Pig scripts with Punit,

    Aviation use case in PIG, Pig Demo on Healthcare Dataset.

    6. Hive

    Learning Objectives – This module will help you in understanding Hive concepts, Hive Data types, Loading and Querying Data in Hive, running hive scripts and Hive UDF.

    Topics – Hive Background, Hive Use Case, About Hive, Hive Vs Pig, Hive Architecture and Components, Metastore in Hive, Limitations of Hive, Comparison with Traditional Database, Hive Data Types and Data Models, Partitions and Buckets, Hive Tables(Managed Tables and External Tables), Importing Data, Querying Data, Managing Outputs, Hive Script, Hive UDF, Retail use case in Hive, Hive Demo on Healthcare Data set.

    7. Advanced Hive and HBase

    Learning Objectives – In this module, you will understand Advanced Hive concepts such as UDF, Dynamic Partitioning, Hive indexes and views, optimizations in hive. You will also acquire in-depth knowledge of HBase, HBase Architecture, running modes and its components.

    Topics – Hive QL: Joining Tables, Dynamic Partitioning, Custom Map/Reduce Scripts, Hive Indexes and views
    Hive query optimizers, Hive : Thrift Server, User Defined Functions, HBase: Introduction to NoSQL Databases and HBase, HBase v/s RDBMS, HBase Components, HBaseArchitecture, Run Modes & Configuration, HBase Cluster Deployment.

    8. Advanced HBase

    Learning Objectives – This module will cover Advanced HBase concepts. We will see demos on Bulk Loading , Filters. You will also learn what Zookeeper is all about, how it helps in monitoring a cluster, why HBase uses Zookeeper.

    Topics – HBase Data Model, HBase Shell, HBase Client API, Data Loading Techniques, ZooKeeper Data Model, Zookeeper Service, Zookeeper, Demos on Bulk Loading, Getting and Inserting Data, Filters in HBase.

    9. Processing Distributed Data with Apache Spark

    Learning Objectives – In this module you will learn Spark ecosystem and its components, how scala is used in Spark,

    SparkContext. You will learn how to work in RDD in Spark. Demo will be there on running application on Spark Cluster, Comparing performance of MapReduce and Spark.

    Topics – What is Apache Spark, Spark Ecosystem, Spark Components, History of Spark and Spark Versions/Releases, Spark a Polyglot, What is Scala?, Why Scala?, SparkContext, RDD.

    10. Oozie and Hadoop Project

    Learning Objectives – In this module, you will understand working of multiple Hadoop ecosystem components together in a Hadoop implementation to solve Big Data problems. We will discuss multiple data sets and specifications of the project. This module will also cover Flume & Sqoop demo, Apache Oozie Workflow Scheduler for Hadoop Jobs, and Hadoop Talend integration.

    Topics – Flume and Sqoop Demo, Oozie, Oozie Components, Oozie Workflow, Scheduling with Oozie, Demo on Oozie Workflow, Oozie Co-ordinator, Oozie Commands, Oozie Web Console, Oozie for MapReduce, PIG, Hive, and Sqoop, Combine flow of MR, PIG, Hive in Oozie, Hadoop Project Demo, Hadoop Integration with Talend.

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    1. Introduction and Accessing data

    Learning Objectives – This module will introduce you to SAS as a language. It will talk about the minimum set of rules SAS works with, about how to access data in SAS, and more.

    Topics – Introduction: History, SAS Windows and it’s contents, SAS Studio on SAS University edition, The SAS language, SAS data sets  Parts of a SAS program, Modes for submitting a SAS program, How SAS language works, DATA-STEP’s built-in loop, Program data vector (PDV), Getting your data into SAS, Temporary vs. permanent SAS data sets, Working with data, Creating and redefining variables.

    2. Working with Data

    Learning Objectives – Once we have created or accessed data in SAS, learn how to then how to work on/with it are the learnings  In this module, we will understand  SAS functions (there are more than 400 available, so we will focus on a selected few), and some specialized SAS options.

    Topics – Creating and redefining variables revisited, SAS functions: NUMERIC, CHARACTER, Working with SAS dates, DATES, SAS formats, SAS informats, PUT & INPUT, Conditional variable creation.

    3. Working with Data: Loops and Advanced topics

    Learning Objectives – This module has vast literature. This module will talk about how to work on iterative steps/processes with the help of Loops. It will then talk about some advanced topics on working with data.

    Topics – Working with data: LOOPS, DO statement (Loop), DO-UNTIL statement, DO-WHILE statement, Working with data: Advanced topics, Retain & Sum statements, Uni-dimensional ARRAYS, PROC SORT – an introduction, SAS Automatic variables

    4. Combining Datasets

    Learning Objectives – Real-life work scenarios will require an analyst to work with multiple data sets, requiring integration, vertically or horizontally.This module will help you understand how to combine 2 or more SAS datasets.

    Topics – Appending datasets, Using SAS dataset option IN, Appending datasets using IN, Merging datasets, Merging scenarios through Venn diagram, Merging codes for 4 scenarios.

    5. SAS Procedures

    Learning Objectives – SAS houses in-built procedures or SAS programs helping the user  save time in writing customized codes for frequently used programs. This module will formally introduce and familiarize the user through some of the most frequently used PROCs in the industry.

    Topics – Using SAS PROCEDURES, PROC IMPORT, PROC DATASETS, PROC CONTENTS, PROC PRINT, PROC FREQ, PROC SORT, PROC FORMAT, PROC SURVEYSELECT, PROC TRANSPOSE, PROC MEANS, PROC SUMMARY, PROC RANK, PROC OPTIONS, PROC EXPORT.

    6. Basic stats using SAS

    Learning Objectives – SAS is a data management as well as an advanced statistical tool. This module familiarizes learners with elementary statistical procedures around SAS.

    Topics – Introductory Statistical PROCs, PROC CORR, PROC UNIVARIATE, PROC FREQ, Summarizing data using PROC MEANS, Merging summary statistics to Parent data.

    7. Debugging and Introduction to Advanced SAS

    Learning Objectives – If you cannot debug a code then you do not really know coding. So, this module will focus on some of the common mistakes made by SAS programmers. The module also provides guidelines and best practices for avoiding bugs, or even debugging them.

    Topics – Debugging, Writing programs that work, Fixing programs that do not work, Introduction to Advanced SAS – Structured Query Language, Macros.

    8. Recap and Case study

    Learning Objectives – Learning a programming language without its extensive usage will not be effective. Hence, this module will recap the concepts learnt till module 6, and then cover the case study using toy-datasets mimicking the real-life industry challenges in details.

    Topics – Concepts quickly revisited, Accessing data, Working with data, Variable creation, Dataset options, Sorting & Combining data, 3 Best practices when approaching a new dataset, Case study on BFSI data:, Problem statement: Building Customer Analytics Record

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    Course Fee: Not Mentioned
    Course Duration: 3 Months
    Placement Provided: Yes

    This is a self-paced Classroom course designed to develop your Data Analytics- Advance Excel & VBA development skills and practically implement your learning on MS Excel to make you an MS Excel Expert.

    1. Excel Abilities and its Functions

    Learning Objectives  – In this module, you will learn what are the new features added in Excel 2010. How to customize quick access toolbar and ribbon. Differences between relative and mixed cell references, to perform complex calculations.

    Topics – Overview of Microsoft Excel 2010, Improved ribbon, Microsoft Office Backstage view, Excel Mobile 2010 for Windows 7 Phone, Sparklines – An Introduction, Slicers – An Introduction, Customize the Quick Access Toolbar, Customizing common options in Excel Setting, Absolute, Relative and Mixed Cell References, Work with Comments, Using Hyperlinks, Introduction to Excel Functions, Adding a Function to a Formula, Writing conditional expressions (using IF), Building an AutoSum Formula, Adding a Range Name to a Formula.

    2. Data Security, Formatting and Analyzing

    Learning Objectives – In this module, you will learn to protect and  unprotected  workbook, Inserting the existing file and new file as an object, share a workbook with others and filtering a table. 

    Topics – Protecting and un-protecting worksheets and cells, Hiding Formulas, Track Workbook Changes, Share a workbook with other users, Inserting, Formatting and Deleting Object, Changing the font and font size, Applying effects to fonts, Changing font color, Working with text within a cell, Wrapping text within a cell, Applying auto format to a range, Applying a number format, Applying a style to a range, Sorting a Table, Filtering a Table, Filtering a Range, Filtering data for selected view (AutoFilter), Using advanced filter options, Sort by colorSorting in a Pivot Table, Filtering in a Pivot Table, Filtering Using the Report Filter Area.

    3. Data Reports

    Learning Objectives  – In this module, you will learn aggregate functions, reference functions and specialized functions. This module also deals with Pivot Tables and Pivot Charts.

    Topics – Using aggregate Functions like Dsum, Dcount, Dmax, Sumif, Countif, Averageif, Sumifs, Countifs, Averageifs, ISERROR, ISBLANK, Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX), Summarizing Data with subtotals, Pivot Tables, Using advanced options of Pivot tables, Types of Pivot Report, Consolidating data from multiple sheets and files using Pivot tables, Import and export data in Excel.

    4. Graphical Representations of Data

    Learning Objectives – In this module, you will learn Data Visualizing and Automating Excel.

    Topics – Examining Chart Elements, Understanding Chart Types, Create a Chart, Format Charts, Create a Chart Template – Combination chart, Summarizing Data by Using Sparklines, Creating Dynamic Charts by Using Pivot Charts, Changing the Chart Layout and Style, Introduction to Macros, Recording and Playing a Macro, Editing Using VBA, Mapping a Simple Document.

    5. Specialized Functions

    Learning Objectives – In this module, you will learn scenario based analysis of data with ‘what if’ analysis & specialized functions.

    Topics – Date and time functions, Time Function, Text functions, Proper Function, Concatenate Financial Functions Pmt, Fv, Named Ranges, Creating a Data Table, Introduction to Scenarios, Managing Scenarios, Using Goal Seek, Solver, Saving Solver Models, Configuring Solver.

    6. Working with Other Microsoft Office Programs

    Learning Objectives – In this module, you will learn restrictions in Worksheet, manipulating External Data, and working with other Microsoft Office Programs. 

    Topics – Specifying a valid range of values for a cell, Input Message, Custom Error Alert, Specifying custom validations based on formula, Getting External Data in Excel, Refreshing data, Add own error messages, Object Linking and Embedding, Insert Drawing Object, Data Forms, Drop Down List, Including Office Documents in Workbooks, Pasting Charts into Other Documents, Preparing Worksheets for Printing, New Methods For Headers And Footers In 2010, Insert Specific Elements In A Header Or Footer, Add A Predefined Header Or Footer, Custom Header Or Footer For A Chart.

    EXCEL VBA

    LESSON 1: INTRODUCING VBA
     What Is VBA?
     A Brief History of VBA
     Automating a Recurring Task
     Automating a Repetitive Task
     Liabilities of VBA

    LESSON 2: GETTING STARTED WITH MACROS
     Composing Your First Macro
     Accessing the VBA Environment
     Using the Macro Recorder
     Running a Macro
     The Macro Dialog Box
     Shortcut Key

    LESSON 3: OBJECT-ORIENTED PROGRAMMING: AN OVERVIEW
     What “Object-Oriented Programming” Means
     The Object Model
     Properties

    LESSON 4: VARIABLES, DATA TYPES AND CONSTANTS
     What Is a Variable?
     Assigning Values to Variables
     Why You Need Variables
     Data Types
     Understanding the Different Data Types
     Declaring a Variable for Dates and Times
     Declaring a Variable with the Proper Data Type

    LESSON 5: UNDERSTANDING OBJECTS AND COLLECTIONS
     Workbooks
     Cells and Ranges
     SpecialCells

    LESSON 6: WORKING WITH RANGES
     Working with Contiguously Populated Ranges
     Using the Cells Property
     Using CurrentRegion
     Working with Noncontiguously Populated Ranges
     Using Range with Several Cells
     Using OFFSET
     Using RESIZE
     Identifying a Data Range
     Identifying the UsedRange
     Finding the Dynamic Last Rows and Columns
     Identifying Where the Range Starts and Ends When
     No Start or End Point Is Known

    LESSON 7: MAKING DECISIONS WITH VBA
     Understanding Logical Operators
     AND
     OR
     NOT
     Choosing Between This or That
     If…Then
     If…Then…Else
     If…Then…ElseIf
     IIF
     Select Case
     Getting Users to Make Decisions
     Message Boxes
     Input BoxesLESSON 8: REPEATING ACTIONS WITH LOOPS
     What Is a Loop?
     Types of Loops
     Do…While
     Do…Until
     Do…Loop While
     Do…Loop Until
     While…Wend
     Nesting Loops

    LESSON 9: PROGRAMMING FORMULAS
     Understanding A1 and R1C1 References
     Getting Started with a Few One-Liners
     Comparing the Interface of A1 and R1C1 Styles
     Toggling between A1 and R1C1 Style Views

    LESSON 10: WORKING WITH ARRAYS
     What Is an Array?
     What Arrays Can Do for You
     Declaring Arrays
     The Option Base Statement
     Boundaries in Arrays
     Declaring Arrays with Fixed Elements
     Declaring Dynamic Arrays with ReDim and Preserve

    LESSON 11: AUTOMATING PROCEDURES WITH WORKSHEET EVENTS
     What Is an Event?
     Worksheet Events: An Overview
     Where Does the Worksheet Event Code Go?
     Enabling and Disabling Events
     Examples of Common Worksheet Events
     Worksheet_Change Event
     Worksheet_SelectionChange Event
     Worksheet_BeforeDoubleClick Event
     Worksheet_Before RightClick Event
     Worksheet_FollowHyperlink Event
     Worksheet_Activate Event
     Worksheet_Deactivate Event
     Worksheet_Calculate Event
     Worksheet_PivotTableUpdate Event

    LESSON 12: AUTOMATING PROCEDURES WITH WORKBOOK EVENTS
     Entering Workbook Event Code
     Examples of Common Workbook Events
     Workbook_Open Event
     Workbook_BeforeClose Event
     Workbook_Activate Event
     Workbook_Deactivate Event
     Workbook_SheetChange Event
     Workbook_SheetSelectionChange Event
     Workbook_SheetBeforeDoubleClick Event
     Workbook_SheetBeforeRightClick Event
     Workbook_SheetPivotTableUpdate Event
     Workbook_NewSheet Event
     Workbook_BeforePrint Event
     Workbook_SheetActivate Event
     Workbook_SheetDeactivate Event
     Workbook_BeforeSave Event

    LESSON 13: HANDLING DUPLICATE ITEMS AND RECORDS
     Deleting Rows Containing Duplicate Entries
     Deleting Rows with Duplicates in a Single Column
     Deleting Rows with Duplicates in More Than One Column
     Deleting Some Duplicates and Keeping Others
     Working with Duplicate Data

    LESSON 14: USING EMBEDDED CONTROLS
     Working with Form Controls and
     ActiveX Controls
     The Forms Toolbar
     ButtonsLESSON 15: PROGRAMMING CHARTS
     Adding a Chart to a Chart Sheet
     Adding an Embedded Chart to a Worksheet
     Moving a Chart
     Looping Through All Embedded Charts
     Deleting Charts
     Renaming a Chart

    LESSON 16: PROGRAMMING PIVOTTABLES AND PIVOTCHARTS
     Creating a PivotTable Report
     Hiding the PivotTable Field List
     Formatting Numbers in the Values Area
     Pivoting Your Data
     Creating a PivotChart
     Understanding PivotCaches
     Manipulating PivotFields in VBA
     Manipulating PivotItems with VBA
     Creating a PivotTables Collection

    LESSON 17: USER-DEFINED FUNCTIONS
     What Is a User-Defined Function?
     Characteristics of User-Defined Functions
     Anatomy of a UDF
     UDF Examples That Solve Common Tasks
     Summing Numbers in Colored Cells
     Extracting Numbers or Letters from an Alphanumeric String
     Extracting the Address from a Hyperlink

    LESSON 18: DEBUGGING YOUR CODE
     What Is Debugging? What Causes Errors?
     Error Handler

    LESSON 19: CREATING USERFORMS
    LESSON 20: DATA ACCESS WITH ACTIVEX DATA OBJECTS (SQL Database)
    LESSON 21: INTEGRATING WITH OTHER MS OFFICE APPLICATIONS

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    Advanced Java course is designed to give you a stepping stone to work on advanced and latest technologies like Hadoop and its ecosystem, other enterprises or mobile applications. For every topic the concepts are explained with a mix of theory and production quality code.

    1. Java Basics

    Learning Objectives – In this module you will learn about Variables, Operators, Java Wrapper Classes over Primitive Types, Expressions, Statements, Blocks and Control Flow Statements.

    Topics – Variables: Primitive Data Types and Arrays, Operators: Arithmetic, Unary, Relational, Conditional, Bitwise and Bit Shift, Java Wrapper Classes over Primitive Types (String, Integer, Float, etc.), Expressions, Statements and Blocks, Control Flow Statements: if, if-else, switch statements, while loops, do-while loops, for loops (including for each loop introduced in JDK 1.5), branching statements.

    2. Anatomy of a Class & Interface, Annotations

    Learning Objectives – In this module you will learn about Data Hiding, Abstraction,  Inheritance and Encapsulation, Constructors, Class Methods and Access Specifiers, Life Cycle of an Object, Types of Classes, Types of Methods, Interfaces and When to Use Them, Enum Types, Packages, Java Annotation.

    Topics – Data Hiding, Abstraction,  Inheritance and Encapsulation, Constructors, Class Methods and Access Specifiers, Life Cycle of an Object, Types of Classes: Abstract, Final, Types of Nested & General Classes, Types of Methods: Abstract, Final, Static, Instance Method, Interfaces and When to Use Them, Enum Types, Packages, Java Annotations.

    3. Polymorphism, Event Handling, Internationalization

    Learning Objectives – In this module you will learn about Polymorphism in Java, User Defined Event Handling, Handling Internationalization.

    Topics – Polymorphism in Java, Designing call-back methods for event handling, Handling Internationalization, Handling Internationalization with Resource Bundles.

    4. Exceptions, Apache Log4j, Regular Expressions

    Learning Objectives – In this module you will learn about Exception Handling, Logging in Java, Regular Expressions.

    Topics – Exception handling with try-catch-finally constructs, Implementation of custom Exception class, Using Apache Log4j for logging services, Regular expressions using javax.util.regex.

    5. Collections & Generics

    Learning Objectives – In this module you will learn about Classic Data Structures, Sequential Collections, Associative Collections, Sort & Search Algorithms, Generics.

    Topics – Classic Data Structures, Sequential Collections, Associative Collections, Sort & Search Algorithms, Generic Classes, Generic Methods, Bounded Type Method Parameters, Wildcards, How generics behave?

    6. Working with Files

    Learning Objectives – In this module you will learn about File Handling in Java (Text, Binary & XML files), Serialization.

    Topics – The structure of the I/O Package, Handling text files, Handling binary files, Object persistence with serialization, Introduction to XML, DOM and SAX models: When to use what, Parsing XML with DOM & SAX.

    7. Concurrency

    Learning Objectives – In this module you will learn about Concurrency and the constructs of concurrent programmes, Implementing a Multithreaded Java program, Synchronizing threads, Critical Section and its protection with locks.

    Topics – Introduction to Concurrency and the constructs of concurrent programs, Implementing a Multithreaded Java program, Synchronizing threads, Critical Section and its protection with locks.

    8. Working with Databases

    Learning Objectives – In this module you will learn how to use JDBC for DDL, DML and TCL and write your own stored procedures.

    Topics – How to connect to databases from Java code? CRUD operations, How to run parameterized stored procedures?, Transaction Management, Batch Processing.

    9. Network Programming

    Learning Objectives – In this module you will learn basics of networking, Writing own TCP/IP server and client, Writing own UDP server and client, URL handling (Download example).

    Topics – How It All Started – BSD Sockets, Networking Basics, Understanding java.net, Network Interfaces, Reliable Communication through TCP Sockets, Unicast through Datagram Sockets, Multicast through Multicast Sockets, URL Processing.

    10. Making Code Robust

    Learning Objectives – In this module you will learn how to handle memory leak, through Design Pattern we teach loose coupling and high cohesion in designing.

    Topics – Managing Java Programme Memory, Unit Testing with JUNIT4, Basic “Gang of Four” Design Patterns – Abstract Factory, Factory Method, Observer, Strategy, Singleton, Adapter & State, Project Discussion.

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    Course Details: Selenium Automation testing

     

    Software Testing market is expected to sky rise at 11 percent of CAGR in next 3 years. Average salary of Selenium Automation Engineer is $94k (Indeed.com Salary Data)

    1. Introduction to Selenium & its Components

    Goal : In this Module, get introduced to the types of applications, the types of testing, and the purpose of automation testing. You will also gain insight into the evolution of Selenium, get an overview of Selenium 3.0 and its components, and compare 2 different automation tools. Finally, set up your environment so that you can start working with Selenium.

    Objectives : Upon completing this Module, you should be able to: List the different types of Applications, list the different types of Testing, define selenium, discuss the Evolution of Selenium from Selenium 1 to Selenium 2 and then to Selenium 3, state the current version of Selenium, discuss the different components of Selenium Suite, describe Selenium IDE, describe Selenium WebDriver, describe Selenium Grid, discuss Regression Testing, discuss Functional Testing, compare Selenium and QTP, list the software required for Selenium, set up:- Java, Eclipse, Selenium IDE, Selenium WebDriver.

    Topics : Define testing, understand web-application and desktop application, know the different types of testing, describe manual testing, describe automation testing, evolution of Selenium, components of Selenium Suite (Selenium IDE, Selenium WebDriver, Selenium GRID), regression testing, functional testing, QTP and Selenium, list the software required for Selenium, set up – Java, Eclipse, Selenium IDE, Selenium WebDriver

    Practicals to be covered : Installing Java, configuring Eclipse for Selenium

    2. Selenium IDE

    Goal : The Selenium-IDE (Integrated Development Environment) is the tool you use to develop your Selenium test cases. It’s an easy-to-use Firefox plug-in and is generally the most efficient way to develop test cases. In this Module, you will learn about Selenium-IDE and how to create and execute a Test case.

    Objectives : At the end of this Module, you should be able to: Discuss the basics of Selenium IDE, list the different Controls of Selenium IDE, describe the Record and Playback feature, create a new Test Case, execute a Test Case, explain ‘Command’, ‘Target’, and ‘Value’, explain the different Selenese Commands, tell the difference between Assert and Verify Commands

    Topics : Selenium-IDE Features, different Controls of Selenium IDE, creating a Test Case, recording a Test Case, executing a Test Case, Command, Target and Value, Selenese Commands, Assert and Verify Command.

    Practicals to be covered :Recording a Test Case, Executing a Test Case.

    3. Selenium Webdriver

    Goal : WebDriver is designed to provide a simpler, more concise programming interface in addition to addressing some limitations in the Selenium-RC API. Selenium-WebDriver was developed to better support dynamic web pages where elements of a page may change without the page itself being reloaded. In this Module, you will explore the features and use of Selenium-WebDriver.

    Objectives : At the end of this Module, you should be able to: Discuss the basics of Selenium WebDriver, open the browser (Chrome), navigate to the web-application, list the Web-Elements, describe the Chrome Developer Tools, discuss various Locators.

    Topics : Selenium-WebDriver, opening Chrome Browser, navigating to Web Applications, introduction to Web Elements, Chrome Developer Tool, Locators -: Locators-ID, Locators-Name, Locators-Class, Locators-Tag Name, Locators-Link Text, Locators-Partial Link Text, Locators-CssSelector, Locators-Xpath.

    Practicals to be covered : Opening a Browser (Chrome), Navigating Web Applications, Handling different Locators

    4. Creating Test Cases in Selenium Webdriver

    Goal : In this Module, you are presented with validation, and the need for maven. You will write test cases to verify title, and verify login credentials in Facebook. Learn how to handle keyboard events and dynamic web, and how to switch from simple Java project to maven project.

    Objectives : At the end of this Module, you should be able to: Explain Validation, write a Test Case that verifies the title of the web page, verify the Error Message on Entering a wrong username and password on Facebook.com, Handle Keyboard Events, Handle Dynamic Web-elements , describe the need for Maven, switch from Simple Java Project to Maven Project.

    Topics : Validation – Validation-Page Title, Facebook Code, Handle Keyboard Events, Handle Dynamic Web-elements, Need for Maven, Switch from Simple Java Project to Maven Project.

    Practicals to be covered : Validate Title of a Web Page, Validate the Login Credentials using Facebook.

    5. Introduction to waits in Selenium

    Goal :Wait is used to hold the web application for a few seconds/minutes/hours. When web applications navigate from Page A to Page B then Selenium should wait till browser loads the Page B completely otherwise you will not be able to find out the web elements in the page which results in an exception. It also provides a feature of synchronization. In this Module, you will learn about waits.

    Objectives : Upon completing this Module, you should be able to: Describe waits, Discuss the various types of waits.

    Topics : Types of waits – Explicit Wait, Fluent wait, Implicit Wait, PageLoadTimeout, setScriptTimeout.

    Practicals to be covered : Explicit wait, Implicit wait, Fluent wait.

    6. Handling different Controls on a Webpage

    Goal : A web page that is embedded in another web page, or an HTML document embedded inside another HTML document is known as a “frame”. The “Iframe” is used to insert content from another source, such as an advertisement, into a Web page. In this Module, you will learn about frames and other controls on a web page.

    Objectives : At the end of this Module, you should be able to: Learn about Frames and Inline Frames, Discuss Alert boxes , Discuss Modal Dialog boxes, Discuss dropdown boxes, Illustrate Mouse Hovering, Drag and Drop, Switch between windows, Explain how to test whether all links are working on the webpage or not.

    Topics : IFrames using Web Driver commands (By Index, By Name or ID, By Web Element), Alerts in WebDriver (Simple Alert, Confirmation Alert, Prompt Alert), Testing Dropdown (SelectByVisibleText, SelectByIndex, SelectByValue), Methods in Window handling (GetWindowHandleCommand, GetWindowHandlesCommand, SwitchToWindowCommand)

    Practicals to be covered : IFrames, Alerts, Dropdown, Window handling.

    7. Introduction to TestNG

    Goal : TestNG is an open source testing framework that provides more flexible and powerful tests with the help of Annotations, Grouping, Sequencing and Parametering. In TestNG HTML reports can be produced, Parallel testing can be performed, Test cases can be prioritized and data Parametrization is possible. Cross Browser Testing enables our application to work with different browsers. Learn all about TestNG in this Module.

    Objectives : At the end of this Module, you should be able to: Describe the purpose of TestNG, Explain Reports, ReportNG and TestNG XSIT Report, Discuss Annotations, Execute Scripts using TestNG, Prioritize Test Cases, Discuss Cross Browser Testing, Define Browser Profiling, Illustrate the need of taking screenshots in case of test failure, Illustrate how to enable/disable a particular Test, Explain the need of executing a test multiple times.

    Topics : ReportNG, HTML Report, Console Report, XML Report.

    Practicals to be covered : HTML Report, Console Report, TestNG XML, Executing scripts using a Test Case, Taking screen shots in case of a Test failure, Executing a test case multiple times.

    8. Page Object Modelling

    Goal : Page Object Model is a design pattern to create Object Repository for web UI Elements. Page Object model includes Page classes which finds the WebElements of that Web Page and also contains Page Methods that perform operations on those WebElements. Page Factory is an optimized way to create an Object Repository. Learn all about Page Object Modelling in this Module.

    Objectives: At the end of this lesson, you should be able to: Identify the need for Page Object Modelling, Discuss Page Classes, Express the concept of Page Factory.

    Practicals to be covered : Implementation of POM, Page Factory.

    9. Frameworks

    Goal: Framework is a basic structure of any environment whether testing or designing. Selenium offers flexibility to create a Testing Framework that can be reused. This Module enables you to learn about Testing framework, Apache POI that is an open source library to read and write excel files, and Parametrization, which is also called Data Driven Testing.

    Objectives: At the end of this Module, you should be able to: Define Parametrization, Discuss how to read data from Excel sheet, Describe different types of frameworks.

    Topics: Parameterization, Read data from Excel sheet, Types of Frameworks – Data Driven Framework, Keyword Driven Framework, Hybrid Framework.

    Practicals to be covered : Reading an Excel File, Keyword driven framework, Data driven framework, Hybrid framework.

    10. Third Party Tools

    Goal: Learn about the third-party tools in this Module such as Jenkins, AutoIT, and Sikuli. Jenkins is the leading open-source continuous integration tool. It is cross-platform and can be used on Windows, Linux etc. It supports software changes, multiple VMs, Plugins and has easy installation. AutoIt is a freeware scripting language and it is used to automate windows GUI. Files can be downloaded and uploaded easily using this tool. Sikuli can automate everything you see on screen. It comes into play when there is no easy access to a GUIs internal or source code. It can automate both web and desktop applications.

    Objectives: At the end of this Module, you should be able to: Discuss Jenkins for continuous Integrating, Analyze AutoIt for downloading and Uploading a file, Discuss Sikuli for working with Flash Applications.

    Topics: Jenkins, Selenium Integration with Jenkins, AutoIT and its features, AutoIt provides support for – Keystrokes, Mouse Movement, Window Control, Sikuli and its features, How Sikuli works, Interaction with Selenium, Interaction with Flash applications.

    Practicals to be covered: Jenkins, Sikuli with flash applications, AutoIT.

    11. Appium

    Goal: Get introduced to the purpose of Appium and UIautomatorviewer in this Module.

    Objectives : At the end of this Module, you should be able to: Describe the purpose of APPIUM, Discuss APPIUM Design Concepts, Explain APPIUM Inspector, Discuss the first APPIUM Test Case for Android App, List the limitations using APPIUM, Discuss what is UIautomatorviewer and it’s Use, Get started with UIautomatorviewer, Discuss how to find objects in application, Identify the elements, Discuss Desired Capability.

    Topics: Appium (Design Concepts, Prerequisites, Inspector, Installation, Limitations), First Appium Test Case, Limitations of Appium, What is UIautomatorviewer?, Objects in application, Desired Capability.

    Practicals to be covered: Inspecting the elements using UIautomatorviewer.

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    Microsoft Excel Training is most widely used for data analytics and management tool. Advance Excel Training Gurgaon, Delhi is specially designed for you to become an expert. Call Now:+91 9999201478.

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    The Android Development course is primarily designed for programmers who want to learn how to create mobile applications on the Android platform. As a part of this course, you will create widgets, Customize List view, Grid view, Spinners etc, create applications using audio, video and sqlite database and finally publish it on Google Play. This course will help you learn mobile app development from scratch and unlock new job opportunities for you in start-ups as well as large organizations. Master Android app development, learn how to set up Android Studio, understand Android architecture in detail, learn about integrating your mobile apps with Facebook, Twitter and other social media, Google Drive, Google Maps, SQLite and learn how to create and optimize app user experience

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    AWS Solution Architect – Associate Certification Training from Gyansetu is designed to provide in depth knowledge about AWS architectural principles and its services. The sessions will be conducted by Industry practitioners who will train you to leverage AWS services to make the AWS infrastructure scalable, reliable, and highly available. Amazon Web Service training is completely aligned to AWS Certified Solutions Architect Exam.

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    Gyansetu’s Salesforce Admin Certification program will help you to learn the concepts related to Salesforce Administration and prepare for the ADM 201 Certification.

    Now Learn Salesforce Admin Certification Training Gurgaon, Delhi with GyanSetu. We have happier customers than any other IT training institute.

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    Big Data Hadoop Training Gurgaon, Delhi will make you expert in HDFS, Yarn, MapReduce, Pig, Hive, HBase, Oozie, Flume and Sqoop using real-time use cases on Retail, Social Media, Aviation, Tourism, Finance domain. You will get Gyansetu Hadoop certification at the end of the course.Enroll Now for GyanSetu’s Best Big Data Hadoop Training in Gurgaon, Delhi which is designed to understand fundamental of Big Data Course to get your Dream Job.

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    GyanSetu’s  Java/J2EE training will help you to understand the Java technology basis that will be helpful in areas like website development, mobile development as well as Desktop based application development for finance, E-Commerce & other domains in IT industry.

    This course will cover Advance Frameworks like Springs & Hibernate Training and also helps you to understand MVC Architecture of a Web Application using these frameworks.

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    Gyansetu’s Data Analytics with R training course is specially designed to provide the requisite knowledge and skills to become a successful analytics professional. It covers concepts of Data Manipulation, Exploratory Data Analysis, etc before moving over to advanced topics like the Ensemble of Decision trees, Collaborative filtering, etc.

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    Oracle is a well-known company which has developed multiple tools like Power Center, IDQ, MDM etc. PowerCenter is amongst one of the ETL tools which is used to implement a data warehouse and data integration projects. In this module, you will learn about PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager windows like ORACLE DBA TRAINING & CERTIFICATION

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    Learn Digital Marketing Training and get hands-on 100% Practical Training with live website and learn all the way to drive traffic on your website using SEO, SEM, Social Media courses.

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    SQL is a structured query langage used for storing, manipualting and retrieving data from databases. Gyansetu’s SQL/PLSQL training will help you strengthen your query writing skills using MS SQL Server 2008 relational database.

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    This Apache Spark Certification Training will enable learners to understand how Spark executes in-memory data processing and runs much faster than Hadoop MapReduce. Learners will master Scala programming and will get trained on different APIs which Spark offers such as Spark Streaming, Spark SQL, Spark RDD, Spark MLlib and Spark GraphX. This Gyansetu course is an integral part of Big Data developer’s learning path.

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    This course starts from the very basics of computers and covers various aspects of C programming. It also provides an in-depth understanding of advanced topics in C such as pointers, stacks, linked lists and File I/O. Each unit has a programming assignment and a quiz to re-enforce your understanding of the topic. By the end of this course you will be able to write many real life applications such as “Your Own Movie Ticket Application” and a “Maze game”.

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    GyanSetu offering an opportunity to work on Live Projects with Java Training in Gurgaon, Delhi. Learn From core to advance level of java. 100% Placement.

    Get 100% Job placement after GyanSetu’s  Java, J2ee, SOA Training course combines world-class training helps you to become an expert.

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    Join Gyan Setu because it is Best Testing Training Institutes in Gurgaon, Delhi to Get Manual Testing Classes with 100% Placement Assistance.  

    Manual Testing Training in Gurgaon, Delhi provided by GyanSetu is best covering all your courses to build your testing skills with Guaranteed Placement.  

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    Python language Training Course  in Gurgaon will cover both basic and advanced concepts of Python like writing python scripts. You can Learn Python Course online from best training institute.

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    Course Details

    Course

    Test Automation is growing rapidly in IT Industry & the need of development experience and tool's knowledge is enormous to stay in testing profession. This course brings the essence of Automation basics to advanced level to benefit the IT Professionals as well as Job seekers. In this module, you will learn Core Java, Selenium WebDriver, POM Concept, TestNG Framework, Maven, Selenium Grid, Automation framework. 

    Other Information

    Course Fee: Not Mentioned

    Course Duration: Not Mentioned

    Placement Provided: No

    COMMENTS

      No Comments Posted