Course introduction & Setup Instructions
  • Course Architecture : Must for Everyone | What we will learn in this course
  • Database Setup Introduction
  • Approach-1: Mysql Server Installation on Windows Machine (Database Server Setup)
  • MySQL Client Installation : Workbench on Windows Machine (Database Client Setup)
  • Setup Sample Tables and Test Data for practice
  • Sample Database, Tables with Data
  • Approach-2: Execute SQL query online (Incase you do not have Installed DB)
  • What is Database Testing ? What all testing activities we will do on Database
Fetch Data from Table using Basic Select Queries - With Data Filtration
  • Select Query Basics : Fetch Data from Table- Select all data or Few columns
  • Reference Document : Last Session Queries
  • Select data from table : Data filtration using WHERE Clause
  • Select Query : Data Filtration : Where Clause with Logical AND and OR
  • Select Query : Data Filtration using List and Range (IN and BETWEEN)
  • Fetch unique data from column and Table structure
  • Display data with Column Alias
  • Reference Document : Last Session Queries
  • Display data in Sorting order (Ascending & Descending )
  • Reference Document : Last Session Queries
  • Test your learning by solving these Practice Questions
  • Its Time for QUIZ : Check Your Knowledge
Advance Select Queries : Pattern Matching(Like with Characters) and Sub Queries
  • Select data with Pattern Matching(Like with Wild Card Character) - Part 1
  • Document : Select data with Pattern Matching - Part 1
  • Select data with Pattern Matching(Like with Wild Card Character) - Part 2
  • Document : Select data with Pattern Matching - Part 2
  • SQL - SubQuery : Write Query inside a Query
  • Reference Document : SQL - SubQuery
  • Test your learning by solving these Practice Questions
Other Common Select Query Operations
  • Select Query : Fetch Null data
  • Arithmetic operations on Column data
  • Queries of this complete section
  • Its Time for QUIZ : Check Your Knowledge
Delete Table Structure & Table Data (Delete, Drop, Truncate)
  • SQL - Delete data from tables( Delete | Drop | Truncate)
  • Document : Delete data from tables( Delete | Drop | Truncate)
Data Fetch and Display after Grouping (Group By and Having)
  • Group Functions - Mix, Max, Avg, Count, Sum
  • Display data with Grouping - Use Group by Clause
  • Filter data before and after Grouping - Where and Having in a Single Query
  • Queries of this complete section
  • Test your learning by solving these Practice Questions
Joins : Fetch Data from multiple Tables (Inner, Outer , Simple & Cross Join)
  • What is Join | Why and How we write join in SQL queries
  • Cross or Cartesian Join : Fetch data by Complete merging of 2 or more tables)
  • Inner Join | Equi Join | Simple Join : Fetch data by merging 2 tables(condition)
  • Queries to run before next video
  • Left Join | Left Outer Join :Fetch data by merging 2 tables(condition)+Left data
  • Right Join | Right Outer Join: Fetch data by merging 2 table(condition)+Right
  • Full Join | Full Outer Join
  • Self Join : Join table by Itself
  • Test your learning by solving these Practice Questions
  • Queries of this complete section
Working with Tables : Create table, Insert, Update and Delete data from table
  • Create Tables by Coping content from another Table
  • Create Table with Structure
  • Insert data into table : One row at a time
  • Update data of a table : By giving some conditions
  • Update Table Structure (Conditionally update data)
  • All Queries of this section
Advance SQL Queries : Views, Index and Union
  • SQL - Views : Create dummy table structure to allow limited access on data
  • SQL - Indexes : Increase Search statement performance
  • SQL- Union & Union All : Simply adding data of 2 or more tables
  • Queries of this complete section
Data Constraint : Apply rules to columns for Data insertion and update
  • SQL - Not Null constraint (Not allow to insert Null data into column)
  • Check Constraint : Apply condition for data to insert of update
  • Default Constraint : Apply default value to column in case not value given
  • SQL - Unique Key constraint : Apply rule to insert only unique data
Advance Constraints : Must for Realtime DB Testing and Interviews
  • Primary Key : Set one or more columns as Primary key(Unique + Not Null)
  • Foreign Key : Create Reference of Primary Key
  • Difference between Primary Key and Unique Key
-------QUIZ for SQL Queries ------- 25 Questions in 25 mins
  • Test your SQL skills
SQL Interview Questions : Must for all Interview Aspirants
  • Copy a Table without Structure
  • Find 2nd(Any number) Highest | Lowest Salary of Employee
  • Find Duplicate Records
Introduction to Unix (Linux)| Why as Tester we should Learn ? :Environment Setup
  • Documentation
  • Why as Tester/QA to learn Unix/Linux Commands ? Practical areas to use it as QA
  • Use online environment for practice(In case you don't have practice environment)
  • Setup Environment
  • Setup Practice Environment on Windows Machine (Suggestive for better practicing)
Let's Start Practical Session with very basic Unix /Linux Commands
  • Start working with Basic Commands : Current Directory, Clear Terminal & Help
  • Working with Directories - Create Directory, Move in & Move out to Directories
  • Working with Directories - Create Multiple Directories, Delete Directory
  • Different option to create files : Blank File, File with Content, Insert Data
  • Listing files and Folders : Hidden Files, List Format and Sorted Order
  • All uses of CAT command : Must for Practical Implementation & Interviews
Check content of File(Log Files) : Must Learning Concepts/practical for Tester
  • Documentation : Sample Data to be used for Practicing with me
  • Setup Sample Data to be used for Practicing with me
  • Check complete file content : CAT Command
  • Check file content : Top few lines - Head Command