SDET
Who this course is for?
• This package is designed for any undergraduates or job seekers and laterals to enhance their technical knowledge with BE/ BTech, B.Sc, BCA, MCA, M.Tech/ ME, M.Sc and other technical graduations.
• Manual testers, Non-programming aware testers interested in learning Automation
• Any Software engineer who are interested in Mobile Technologies
• Freshers/Graduates/ Software Testers
Why take this course?
• This course is blended with IT industry experience where even a fresher can start working on project in IT industry easily.
• This package gives desired knowledge on testing which is the entry level criteria for any interview.
• This package gives confidence to a fresher to start working on a testing project from the day of joining.
What you will learn?
• In this Course you will understand software testing from basics to advance level.
• You will understand on how to test any application from the scratch.
• You will also understand how agile works.
• Software testing course is also designed for automating any web application or project from scratch with in-depth knowledge in Java & Selenium tool.
• You will understand the complete life cycle of software testing with 2 projects on manual, Database and automation.
• Your performance will increase by activities like presentations, Assignments, Mock Interviews & mock tests which will run regularly.
• ****** You need NOT have java coding experience to start this course. Even non Programming candidates can follow this course comfortably
• All Installation setup including Java knowledge is taken care as part of course
• 100% JOB ASSISTANCE after completion of course to make your Profile reach to Hundreds of Recruiters in our network. ******
Database
1 – Introduction
• What Is Database?
• What is Database Management System (DBMS)?
• What is Relational Model ?
• Introduction to RDBMS .
• Brief on E.F CODD .
2 – Datatypes and Constraints
• What are Datatypes ?
• Types and Examples .
• How to use .
• What are Constraints?
• Types and Examples.
• How to use.
3 – Statements in SQL
• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Transaction Control Language (TCL)
• Data Control Language (DCL)
• Data Query Language (DQL)
4- Software installation
• Installing and set up of software
• Working on Oracle 10g.
5- Data Query Language (DQL)
• Select
• From
• Where
• Group By
• Having
• Order By
6 –Operators
• Types and Examples
7- Functions in SQL
• Single Row Functions
• Multi Row Functions
Max ()
Min ()
Sum ()
Avg ()
Count ()
8-Sub Query
• Introduction to Sub Query
• Working of Sub Query
• Query Writing and Execution
• Types of Sub Query
1. Single Row Sub Query
2. Multi Row Sub Query
• Nested Sub Query.
10- Pseudo Columns
• Introduction on Pseudo Columns
• ROWID
• ROWNUM
• Working and Usage.
11- JOINS
• What Is Join?
• Types of Joins.
• Cartesian Join
• Inner Join
• Outer Join
• Self-Join
• Queries and Examples.
12- Co- Related Sub Query
• Working and Examples
13- Data Definition Language (DDL)
• Create
• Rename
• Alter
• Truncate
• Drop
14- Data Manipulation Language (DML)
• Insert
• Update
• Delete
15- Transaction Control Language (TCL)
• Commit
• Save point
• Rollback
16- Data Control Language (DCL)
• Grant
• Revoke
17 – Normalization
• Introduction to Normalization
• Types of Normal Forms
• Examples.
18- E R Diagrams
• Introduction to ERD
• Examples.