📄️ Introduction
Database – Introduction (Automation Tester Perspective)
📄️ Database vs DBMS
Understanding the difference between Database and DBMS is essential before learning SQL.
📄️ Tables Rows Columns
Tables, Rows, and Columns
📄️ Primary and Foreign Key
Keys define how data is uniquely identified and related inside a database.
📄️ Types of Databases
Types of Databases (RDBMS vs NoSQL) – Automation Tester Awareness
📄️ SQL Introduction
What is SQL? (Automation Tester Perspective)
📄️ SQL Command Types
SQL Command Types – DDL, DML, DCL, TCL (Automation Tester Guide)
📄️ SELECT Basics
SQL SELECT Queries – Basics (Automation Tester Guide)
📄️ NULL Handling
SQL NULL Handling (IS NULL / IS NOT NULL) – Automation Tester Guide
📄️ Joins
SQL Joins – INNER JOIN & LEFT JOIN (Automation Tester Guide)
📄️ Aggregations
SQL Aggregations (COUNT, SUM, GROUP BY) – Automation Tester Guide
📄️ Date and Timestamp
Date & Timestamp Handling in SQL (Automation Tester Guide)
📄️ SQL Subqueries
SQL Subqueries (IN, EXISTS) – Automation Tester Awareness
📄️ SQL DML
DML – INSERT / UPDATE / DELETE (Automation Tester Awareness & Safety)
📄️ SQL Transactions
Transactions (COMMIT / ROLLBACK) – Automation Tester Perspective
📄️ SQL Indexes and Performance
Indexes & Query Performance (Automation Tester Perspective)
📄️ Locks and Concurrency
Locks & Concurrency (Parallel Test Impact – Automation Tester Guide)
📄️ Db Common Errors and Debugging
Common Database Errors & Automation Debugging Patterns
📄️ Database Normalization
Database Normalization (1NF, 2NF, 3NF) – Automation Tester Perspective
📄️ Database Views
Database Views (Awareness for Automation Testers)
📄️ Database Stored Procedures
Stored Procedures & Functions (Awareness for Automation Testers)
📄️ Database Constraints
Database Constraints (UNIQUE, NOT NULL, CHECK) – Automation Tester Awareness
📄️ Database Schemas
Database Schemas – Automation Tester Awareness
📄️ Interview Readiness
Database Interview‑Ready Explanations (Automation Tester Focus)