Empowering learners with industry-ready skills through interactive teaching and hands-on guidance.


ExcelR Edtech Pvt. Ltd.

Learners will gain hands-on expertise in software testing, agile methodology, automation frameworks (Selenium, TestNG, Cucumber), and API testing. They will build strong foundations in Java, SQL, and Python for automation, covering OOPs, collections, exception handling, and database management. By the end, learners will be capable of designing and executing end-to-end testing frameworks, API validations, and automation solutions for real-world applications.

Selenium Testing  Long Term Internship

Demo

What is Testing? What Is Software, Types of Software Application (Desktop, Web & Mobile), smoke and sanity testing , Differences

Agile Model, Scrum Framework, Roles, Ceremonies & Artifacts, Sprint, Scrum.

STLC - Practical's on Excel , JIRA (defect raising)

Java downloading, Eclipse installation, Basic Java, First java program, Variable Declaration, Java Operators, Java Data Types.

Operators (Arithmetic ,Assignment, Comparison, Logical, Conditionals

Conditionals: If condition, if-else condition, if-else-if ladder, switch case statements, Loops introduction

while loop, do-while-loop, disadvantages of variables, Introduction to Arrays.

1 dimensional arrays , 2 dimensional arrays

Jagged arrays examples, Introduction to objects and class

Strings, ways of declaring ,string methods strings, Strings at memory level explanation,

String methods: length() ,toLowerCase(), concat, charAt(), contains(), replace()

String methods: replace() , trim()

Method overloading and examples, Polymorphism, Constructors

Static keyword, this keyword, Inheritance-single level

Multilevel inheritance

Hierarchy , Method overriding, Abstract class

Interface concept , Exception handling introduction

Exceptions handling , Multiple exceptions handling

Collections framework

Arraylist , hashmap, set interface

Access Specifiers in Java

Java installation , eclipse downloading

Technical Presentation-1

Locators in Selenium (ID, Name, Class Name)

CSS selectors (id , classname , classname attributes, tagname

X-path , Xpath with starts with method, with contains method, with contains method using text() function

Xpath with AND, Xpath with OR, Handling dropdown,WebDriver commands- Browser commands, Get commands

Conditional commands, Actions class- sliders, Drag and Drop , Right click, double click

Keyboard actions , Alert handling, Web table handling- introduction

JavaScriptexecutor- scroll up and down , web table handling , Handling frames

Maven project creation, Page object model(POM)

Apache POI , Reading data from excel using Apache poi

Keyword driven framework,TestNG installation, TestNG Basics

Create TestNG.XML File / Test Suite/ Generating reports /Annotations-BeforeMethod, AfterMethod,BeforeClass,AfterClass

TestNG data provider , groups , Cucumber installation- Creation of feature file, step defination,Test runner

Cucumber Framework Creation ,Executing Automation Scripts Using BDD Framework

API Testing (Manual Postman) Why API Types of API (Rest & SoapUI) API Collection Basic of API Testing (Get, Post, Put and Delete)

Technical Presentation

Day 1 Introductions of SQL and Installation. Created DATABASE

Day 2 Created Database and Tables, Insert values in Tables, Data type(Numeric, String/text)

Day 3 Data Types(ENUM, Floating, Date), SQL Constraints(Domain(Unique, Not Null, Default, Check), Key(Primary + Auto_Increment)

Day 4 Referential Integrity(Foreign Key)), DDL commands(Create, Alter(Add, Drop, Modify, Change column), Rename, Truncate and Drop Table)

Day 5 Operators with Where Clause, DML(Insert, Update, Delete), IS keyword, On delete Cascade and On Update Cascade

Day 6 TCL(Rollback, Savepoint, Commit), DCL(Grant , Revoke), Order BY, Alias, Distinct keyword, Limit, Like keyword

Day 7 Group By with having clause Examples and Joins(Inner Join, Left Join, Right Join, Left Join), Imported table from CSV file in SQL, ACID Properties

Day 8 Joins(Inner, Right, Left, Full Outer Join, Self Join, Cross Join)

Day 9 View With Joins, Index Types(BTREE, HASH ), Explain BTREE with Examples, Unique Index , CASE WHEN. EEE diagram

Day 10 Subquery, Subquery(Multirow subquery, Correlated Subquery) , Window Functions Over clause with (Partioned By) and (Order By)

Day 11 Window Functions(Value window functions(Lag,Lead)), Ranking window functions (rank() , row_number(), dense_rank())

Day 12 IFNULL(), Coalesce(), Temporary Table. Union & Union All, Stored Procedure(Variable, IN Parameters)

Day 13 Stored Procedure(IN, OUT parameter, IF-Else, Loop, Error Handling with Continue and Exit Handler, Out Parameter, Cursor)

Day 14 User Defined Functions, String, Number and Date functions , Types of Trigger(Before(Insert)

INTRODUCTION TO PYTHON | SOFTWARE INSTALLATION | VARIABLE | DATATYPE'S

Operator -Arthmatic ,Comparison , Assignment ,Logical , Bitwise opeartor conditional Statemet

Decision making If, While loop, for loop and nested loop

Mathametical functions , Random function , Trigonometric function Number type conversion - int(), long(). Float ()"

"Strings- Escape char, String special Operator , String formatting Operator Build in string methods - center(), count()decode(), encode()"

Python List and Tuple- Accessing values, Delete elements,updating , Indexing slicing & Matrices Built in Function - cmp(), len(), min(), max()

SET creation,adding and deleting elements,frozenset,Dictionary-Accessing values from dictionary, Deleting and updating elements in Dict.Properties of Dist.,Built in Dist functions & Methods.

Function - Define function , Calling function pass by refernece as value , Function arguments , Anonymous functions , return statements

Import statemnts , Locating modules - current directory Dir() function , global and location functions and reload () functions .

Files in Python- Reading keyboard input ,closing files modes Files object attribute- open , close . Reading and writing files , file Position. Renaming and deleting files"

mkdir methid, chdir () method , getcwd method , rm dir Exception handling - List of exceptions - Try and exception Try- finally clause and user defined exceptions

OOPS concepts , class , objects , Inheritance Overriding methods like _init_, Overloading operators , Data hiding

match function , search function , matching vs searching Regular exp modifiers and patterns

Selenium Testing Long Term Internship

What you'll get out of this course

Course content

Selenium Testing - Videos

Mysql - Videos

Core Python - Videos

API Testing - Videos

Your Instructor

ExcelR Edtech Pvt. Ltd.