Get Expertise in Database Testing(SQL) + Linux for Testers

Course Curriculum

Chapter 1: Course introduction & Setup Instructions

Lecture 1: Course Architecture : Must for Everyone | What we will learn in this course

Lecture 2: Database Setup Introduction

Lecture 3: Approach-1: Mysql Server Installation on Windows Machine (Database Server Setup)

Lecture 4: MySQL Client Installation : Workbench on Windows Machine (Database Client Setup)

Lecture 5: Setup Sample Tables and Test Data for practice

Lecture 6: Sample Database, Tables with Data

Lecture 7: Approach-2: Execute SQL query online (Incase you do not have Installed DB)

Lecture 8: What is Database Testing ? What all testing activities we will do on Database

Chapter 2: Fetch Data from Table using Basic Select Queries – With Data Filtration

Lecture 1: Select Query Basics : Fetch Data from Table- Select all data or Few columns

Lecture 2: Reference Document : Last Session Queries

Lecture 3: Select data from table : Data filtration using WHERE Clause

Lecture 4: Select Query : Data Filtration : Where Clause with Logical AND and OR

Lecture 5: Select Query : Data Filtration using List and Range (IN and BETWEEN)

Lecture 6: Fetch unique data from column and Table structure

Lecture 7: Display data with Column Alias

Lecture 8: Reference Document : Last Session Queries

Lecture 9: Display data in Sorting order (Ascending & Descending )

Lecture 10: Reference Document : Last Session Queries

Lecture 11: Test your learning by solving these Practice Questions

Chapter 3: Advance Select Queries : Pattern Matching(Like with Characters) and Sub Queries

Lecture 1: Select data with Pattern Matching(Like with Wild Card Character) – Part 1

Lecture 2: Document : Select data with Pattern Matching – Part 1

Lecture 3: Select data with Pattern Matching(Like with Wild Card Character) – Part 2

Lecture 4: Document : Select data with Pattern Matching – Part 2

Lecture 5: SQL – SubQuery : Write Query inside a Query

Lecture 6: Reference Document : SQL – SubQuery

Lecture 7: Test your learning by solving these Practice Questions

Chapter 4: Other Common Select Query Operations

Lecture 1: Select Query : Fetch Null data

Lecture 2: Arithmetic operations on Column data

Lecture 3: Queries of this complete section

Chapter 5: Delete Table Structure & Table Data (Delete, Drop, Truncate)

Lecture 1: SQL – Delete data from tables( Delete | Drop | Truncate)

Lecture 2: Document : Delete data from tables( Delete | Drop | Truncate)

Chapter 6: Data Fetch and Display after Grouping (Group By and Having)

Lecture 1: Group Functions – Mix, Max, Avg, Count, Sum

Lecture 2: Display data with Grouping – Use Group by Clause

Lecture 3: Filter data before and after Grouping – Where and Having in a Single Query

Lecture 4: Queries of this complete section

Lecture 5: Test your learning by solving these Practice Questions

Chapter 7: Joins : Fetch Data from multiple Tables (Inner, Outer , Simple & Cross Join)

Lecture 1: What is Join | Why and How we write join in SQL queries

Lecture 2: Cross or Cartesian Join : Fetch data by Complete merging of 2 or more tables)

Lecture 3: Inner Join | Equi Join | Simple Join : Fetch data by merging 2 tables(condition)

Lecture 4: Queries to run before next video

Lecture 5: Left Join | Left Outer Join :Fetch data by merging 2 tables(condition)+Left data

Lecture 6: Right Join | Right Outer Join: Fetch data by merging 2 table(condition)+Right

Lecture 7: Full Join | Full Outer Join

Lecture 8: Self Join : Join table by Itself

Lecture 9: Test your learning by solving these Practice Questions

Lecture 10: Queries of this complete section

Chapter 8: Working with Tables : Create table, Insert, Update and Delete data from table

Lecture 1: Create Tables by Coping content from another Table

Lecture 2: Create Table with Structure

Lecture 3: Insert data into table : One row at a time

Lecture 4: Update data of a table : By giving some conditions

Lecture 5: Update Table Structure (Conditionally update data)

Lecture 6: All Queries of this section

Chapter 9: Advance SQL Queries : Views, Index and Union

Lecture 1: SQL – Views : Create dummy table structure to allow limited access on data

Lecture 2: SQL – Indexes : Increase Search statement performance

Lecture 3: SQL- Union & Union All : Simply adding data of 2 or more tables

Lecture 4: Queries of this complete section

Chapter 10: Data Constraint : Apply rules to columns for Data insertion and update

Lecture 1: SQL – Not Null constraint (Not allow to insert Null data into column)

Lecture 2: Check Constraint : Apply condition for data to insert of update

Lecture 3: Default Constraint : Apply default value to column in case not value given

Lecture 4: SQL – Unique Key constraint : Apply rule to insert only unique data

Chapter 11: Advance Constraints : Must for Realtime DB Testing and Interviews

Lecture 1: Primary Key : Set one or more columns as Primary key(Unique + Not Null)

Lecture 2: Foreign Key : Create Reference of Primary Key

Lecture 3: Difference between Primary Key and Unique Key

Chapter 12: ——-QUIZ for SQL Queries ——- 25 Questions in 25 mins

Chapter 13: SQL Interview Questions : Must for all Interview Aspirants

Lecture 1: Copy a Table without Structure

Lecture 2: Find 2nd(Any number) Highest | Lowest Salary of Employee

Lecture 3: Find Duplicate Records

Chapter 14: Introduction to Unix (Linux)| Why as Tester we should Learn ? :Environment Setup

Lecture 1: Documentation

Lecture 2: Why as Tester/QA to learn Unix/Linux Commands ? Practical areas to use it as QA

Lecture 3: Use online environment for practice(In case you don't have practice environment)

Lecture 4: Setup Environment

Lecture 5: Setup Practice Environment on Windows Machine (Suggestive for better practicing)

Chapter 15: Let's Start Practical Session with very basic Unix /Linux Commands

Lecture 1: Start working with Basic Commands : Current Directory, Clear Terminal & Help

Lecture 2: Working with Directories – Create Directory, Move in & Move out to Directories

Lecture 3: Working with Directories – Create Multiple Directories, Delete Directory

Lecture 4: Different option to create files : Blank File, File with Content, Insert Data

Lecture 5: Listing files and Folders : Hidden Files, List Format and Sorted Order

Lecture 6: All uses of CAT command : Must for Practical Implementation & Interviews

Chapter 16: Check content of File(Log Files) : Must Learning Concepts/practical for Tester

Lecture 1: Documentation : Sample Data to be used for Practicing with me

Lecture 2: Setup Sample Data to be used for Practicing with me

Lecture 3: Check complete file content : CAT Command

Lecture 4: Check file content : Top few lines – Head Command