Unit 1: RDBMS Fundamentals
Unit 2: SQL Basics
Unit 3: Data Definition Language (DDL)
Unit 4: Data Manipulation Language (DML)
SQL for Software Engineers
A comprehensive course designed to equip software engineers with the essential SQL skills for efficient data management and application development.
Unit 1: Introduction to SELECT Statements
Unit 2: Filtering Data with WHERE Clause
Unit 3: Sorting and Logical Operators
Unit 1: Introduction to Aggregate Functions
Unit 2: Grouping Data with GROUP BY
Unit 3: Filtering Grouped Data with HAVING
Unit 1: Understanding Relational Data and Joins
Unit 2: Inner Joins
Unit 3: Outer Joins
Unit 4: Advanced Join Techniques
Unit 1: Introduction to Subqueries
Unit 2: Subqueries in the WHERE Clause
Unit 3: Subqueries in SELECT and FROM Clauses
Unit 4: Correlated Subqueries
Unit 5: Advanced Subquery Techniques
Unit 1: Introduction to Window Functions
Unit 2: Ranking Functions
Unit 3: Aggregate Window Functions
Unit 1: Introduction to Transactions and ACID Properties
Unit 2: Controlling Transactions: COMMIT and ROLLBACK
Unit 3: Managing Concurrency and Isolation Levels
Unit 4: Handling Transaction Failures
Unit 1: Database Security Fundamentals
Unit 2: User Privileges and Access Control
Unit 3: SQL Injection and Prevention