SQL Server/ MySQL/ Postgres

Module 1: Introduction to Databases & SQL

✅ What is a Database?
✅ Types of Databases (Relational vs. NoSQL)
✅ Understanding Database Management Systems (DBMS)
✅ Introduction to SQL & Its Importance in Testing
✅ Overview of Popular RDBMS (MySQL, PostgreSQL, Oracle, SQL Server)
✅ Database Testing vs. UI Testing

Module 2: Understanding SQL Queries

✅ DML (Data Manipulation Language): SELECT, INSERT, UPDATE, DELETE
✅ DDL (Data Definition Language): CREATE, ALTER, DROP, TRUNCATE
✅ DQL (Data Query Language): SELECT
✅ DCL (Data Control Language): GRANT, REVOKE
✅ TCL (Transaction Control Language): COMMIT, ROLLBACK, SAVEPOINT

Module 3: SQL Basics for Testers

✅ Filters: WHERE, AND,OR,IN,NOT IN,BETWEEN,LIKE,IS NULL,IS NOT NULL,EXISTS,ALL,ANY

✅ Operators: Comparison, Logical, Arithmetic, Set Operators

✅ Aggregate Functions: Count(),Sum(),Avg(),Min(),Max(),Group By, Having

✅ Joins: Inner Join, Left Join, Right Join, Full Join, Self Join, Cartesians Join

✅ Other Keywords: Distinct, Alias, Top, Like

✅ String Functions: Substring()/ substr(), INSTR(), CHARINDEX(), Concat(), Length(), Replace(),

ROUND(), CEIL(), FLOOR()

✅ CTE Function

✅ CASE WHEN

✅ Date Functions

✅ Ranking Functions: Row_Number(), Rank(), Dense_Rank()

Duration: 1 Months (Weekly 2 sessions)

Days: Saturday - Sunday

TRAINING BENEFITS

🎥 Access to Recorded Videos
📖 Frequently Asked Questions (FAQs)
📝 Thoughtful Assignments
📚 Comprehensive Study Materials
📄 Resume Preparation Assistance

🚀 Career Guidance