Database Testing and SQL for Testers (top SQL interview Qs)

Course Curriculum

Chapter 1: Understanding Databases, DBMS & their differences

Lecture 1: Why DataBase Testing

Lecture 2: Application of Software Testing Techniques in DB Testing

Lecture 3: Blackbox Testing

Lecture 4: WhiteBox Testing

Lecture 5: Typical Test scenarios in DB Testing

Chapter 2: Making the ground ready – Installation of SQL Server

Lecture 1: Installing SQL Server express

Chapter 3: Importance of DB Testing and effective Database Test scenarios

Lecture 1: Understanding Databases, DBMS and their differences, CREATE DB and CREATE TABLE

Chapter 4: CREATE DATABASE AND CREATE TABLE

Lecture 1: CREATE DATABASE

Lecture 2: CREATE TABLE

Chapter 5: Querying and manipulating Data in Databases

Lecture 1: Introduction to SQL and SELECT statement

Lecture 2: SELECT DISTINCT statement

Lecture 3: ORDER BY CLAUSE

Lecture 4: BETWEEN operator

Lecture 5: LIKE operator

Lecture 6: TOP operator

Lecture 7: INSERT statement

Lecture 8: UPDATE statement

Lecture 9: DELETE statement

Chapter 6: SQL String Functions

Lecture 1: String Functions

Chapter 7: Aggregate Functions

Lecture 1: Common Aggregate Functions

Lecture 2: Group By with Aggregate Functions

Lecture 3: Group By with Having clause

Lecture 4: Aliasing with Aggregating functions

Chapter 8: Retrieving Data from multiple tables – Joins and UNION operations

Lecture 1: What are joins and importance of joins

Lecture 2: Inner Joins

Lecture 3: Left Outer Joins

Lecture 4: Right Outer Joins

Lecture 5: Full Outer Joins

Lecture 6: UNION and UNION ALL

Chapter 9: Database testing using SQL

Lecture 1: Web application with contact page

Lecture 2: Database Testing: Test Data Duplication using SQL queries

Lecture 3: Database Testing: Test User input in Database Tables

Lecture 4: Database Testing: Test Multiple User input in DB Tables

Chapter 10: Common SQL questions in Software Testing interviews

Lecture 1: Q1. Write a SQL statement to count the total number of rows of a table

Lecture 2: Q2. Write a SQL statement to count number of rows matching a condition

Lecture 3: Q3. Write a sql statement to display the second highest salary from a table

Lecture 4: Q4. Write a SQL query to return a substring from a string

Lecture 5: Q5. Write a SQL query to return the no of characters of a given string

Lecture 6: Q6. Write a SQL statement to display distinct salaries from a table

Lecture 7: Q7. Write a sql query to return the numeric position of a character in a string

Lecture 8: Q8. How to get nth highest salary when there are duplicates

Lecture 9: Q9. What is the difference between a Primary Key and Unique Key?

Lecture 10: Q10. What are aggregate functions?

Lecture 11: Q11. What is the difference between an outer join and inner join?

Lecture 12: Q12. What is the difference between DELETE and TRUNCATE statements?

Lecture 13: Q13. What is the difference between Delete and Drop?

Lecture 14: Q14. How do you specify a condition with a GROUP BY clause?