Manual Testing Course Plan

DAY 1

• Introduction to Software Testing
• Software Development Life Cycle (SDLC)
• SDLC Models

DAY 2

• Testing Types
• Characteristics of Black Box Test Types
• Characteristics of White Box Test Types
• Static Testing Technique
• Dynamic Testing Technique

DAY 3

• Dynamic Testing Technique (cont..)
• Boundary Value Analysis (BVA)
• Equivalence Class Partitioning (ECP)
• Error Guessing
• Decision Table
• Assignment on Test Techniques (BVA & ECP)

DAY 4

• Software Testing Life Cycle (STLC)
• Requirement Analysis
• Test Planning

DAY 5

• Software Testing Life Cycle (STLC) (cont…)
• Test Designing
• Traceability Matrix
• Test Execution
• Bug Logging

DAY 6

• Bug Life Cycle
• Bug Reporting
• Bug, Defect, Error, Mistake, Fault, & Failure

DAY 7

• Software Configuration Management (VSS, CVS)
• Q & A Session

DAY 8

• Test Management
• Project Work

DAY 9

• Bugzilla,Jira & Quality center tool overview

DAY 10

• Question & Answer Session with problem with Interview Questions

*Project work: On Live application students needs to complete the project for hands on exposure.

SQL Course Plan

DAY 1

• What is Database
• Database types
• What is SQL
• Why SQL
• SQL Data type

DAY 2

• Types of SQL commands
• DDL
• DML
• DCL
• TCL
• Types of Keys
• Difference between Primary Key, Unique Key & Foreign Key
• Relevance of all the key
• Practical on key

DAY 3

• Create Database
• Create Table
• Constraints
  • NOT NULL
  • UNIQUE
  • PRIMARY KEY
  • FOREIGN KEY
  • CHECK
  • DEFAULT
• Insert Data
• Update Table
  • Insert column
  • Update values
  • Alter table
  • Delete value
• Select
  • Distinct
  • Where
    • Using Operator
    • Combine Operators
  • Top
  • Like
  • In
• Order By
  • ORDER BY DESC
  • ORDER BY Several Columns
• Functions
  • Average ()
  • Count ()
  • First ()
  • Last ()
  • Min ()
  • Max ()
  • Sum ()
  • Group By ()
  • Having ()
  • UCase ()
  • LCase ()
  • MId ()
  • Length ()
  • Round ()
  • Now ()
  • Format ()

DAY 4

• SQL Joins
• Types of Join
  • Full Joins
  • Left Outer Join
  • Right Outer Join
  • Cross Join
• Difference between Joins
• Other SQL Commands
  • Delete
  • Drop
  • Truncate
• Auto Increment

DAY 5

• Question & Answer Session with problem with Interview Questions

 API Testing by Postman

DAY 1

• Introduction on API with Postman

DAY2

• Get,Post,Patch,Delete

DAY3

• Practice on Postman

Agile with Jira tool

Basic command of Unix