softsmithinfotech.com Softsmith Infotech Pvt Ltd Bangalore : Basic SQL,Selenium Training

Name Of the Institute : Softsmith Infotech Pvt Ltd (softsmithinfotech.com)
Location Of The Training Institute : Bangalore
Training Offered : Basic SQL,Selenium Training

Website : http://www.softsmithacademy.com/

SQL SERVER OVERVIEW :
** Understanding Client Server Architecture
** Introducing the Tools
** Selecting an Edition
** Creating Sample Databases
WORKING WITH SINGLE TABLE QUERIES :
** Understanding Query Flow
** Filtering Data with the Where Clause
** Columns, Expressions & Scalar Functions
** Using Case Expressions
** Working with Nulls & Coalesce
** Selecting Environment Functions
** Working with Dates & Times
** Parsing Strings
** Converting Data
** Sorting Data
** Topping Off the Query with Predicates
MERGING DATA WITH JOINS & UNIONS :
** Working with Inner Joins
** Using Left Outer Joins
** Multiplying Data with Cross Joins
** Referencing Self-Joins
** Working with Complex Joins
** Finding the Set Difference
** Stacking Data with Unions
WORKING WITH SUBQUERIES :
** Using Subqueries as Expressions
** Including Subqueries as Lists
** Adding Subqueries as Derived Tables
** Working with Correlated Subqueries
AGGREGATING DATA :
** Using Aggregate Functions
** Grouping a Data Set
** Nesting Aggregations
** Filtering Groups & Adding Grand Totals
** Calculating Cumulative Sums
USING FULL-TEXT SEARCH :
** Creating a Full-Text Index
** Searching for Words
SELECTING DATA THROUGH VIEWS :
** Creating Views
** Preventing Disappearing Rows
** Protecting from Schema Changes
** Nesting Views
MODIFYING DATA :
** Inserting Data
** Updating Data
** Deleting Data
** Using the Output Clause
** Final Comments & Credits
Course Fee : Only Course $ 110 (Online Payment)
Duration : 18 Hrs (Theory)
Course Type :
** Online Training
** Class Room Batches
** On Demand Training

Selenium IDE :
** Installing Selenium IDE.
** Recoding Using Selenium IDE.
** Replaying the Selenium test script.
** Selenium IDE features and options.
** Adding Assertions.
** Converting the IDE scripts into Java Code.
Java Programming Basics :
** Why Java for Selenium
** First Eclipse Project
** First Java Program
** Concept of class file
** Conditional Statements
** Looping Statements
** String manipulation Methods
** User Defined Methods
** Inheritance
Selenium Remote Control :
** Components of selenium RC.
** Setting up the selenium RC.
** Configuring the Eclipse for testng.
** Enhancing using Selenium APIs.
** Data driven test.
** Database validations.
WebDriver :
** Why WebDriver?
** Selenium RC and Webdriver
** WebDriver Interface API
** Close and Quit methods in Webdriver
** HTML language tags
** Handling Links with WebDriver
** Object Locator strategies with WebDriver
** Extracting Xpaths and relevence of Xpaths
** Identifying WebElements using id, name
** Identifying WebElements xpath, tagname
** Handling Different WebElements
** Extracting links and other webelements
** Pop up handling in Selenium
** Handling JavaScript alert messages
** Various drivers like IE, Firefox and chrome
** Running RC scripts using WebDriver.
Selenium Framework using ANT :
** Installing and configuring ANT.
** Selenium ANT framework Structure.
** Creating build.xml file
** Building Framework
** Running the test suite using a batch file
** Viewing the Results.
Course Fee :
Only Course : $ 140 (Online Payment)
Only Live Project : $ 140(Online Payment)
Course + Live Project : $ 260 (Online Payment)
Duration : 20 Hrs (Theory)
Course Type :
** Online Training
** Class Room Batches
** On Demand Training
** Live Project

Contact Us :
Softsmith Infotech Pvt Ltd
#153, 8th Main Road
3rd Block (Jakkasandra Block)
Koramangala,
Bangalore 560 034