CertifiedSQL: From Basics to Advanced Techniques
🔹 Basic SQL Concepts
✅ Introduction to SQL & Relational Databases
- What is SQL and why it matters?
- Types of Databases: Relational vs. Non-Relational
- Setting up the SQL Environment (MySQL, PostgreSQL, SQLite)
✅ Writing Basic Queries
- Using SELECT to retrieve data
- Filtering with WHERE, LIKE, IN, BETWEEN
- Sorting results using ORDER BY
- Removing duplicates with DISTINCT
✅ Aggregation & Grouping
- Aggregate Functions: COUNT, SUM, AVG, MIN, MAX
- GROUP BY and HAVING Clauses
✅ Multi-Table Operations
- Understanding Primary & Foreign Keys
- JOINs: INNER, LEFT, RIGHT, FULL
- Combining Results: UNION vs. UNION ALL
🔹 Intermediate SQL Concepts
✅ Data Modification & Transactions
- INSERT, UPDATE, and DELETE Statements
- ACID Properties and Transaction Control
- COMMIT and ROLLBACK in Practice
✅ Advanced Filtering & Subqueries
- Conditional Logic with CASE
- Handling NULLs using COALESCE
- Subqueries and Nested SELECTs
- Using EXISTS and NOT EXISTS
✅ Indexing & Performance Tuning
- Creating and Using Indexes
- Query Analysis using EXPLAIN
- Normalization vs. Denormalization
🔹 Advanced SQL Concepts
✅ Complex Joins & Set Operations
- Self JOIN and CROSS JOIN
- INTERSECT and EXCEPT Operators
✅ Procedures, Triggers & Automation
- Defining and Using Stored Procedures
- Creating Triggers to Automate Events
✅ Views & CTEs
- Creating and Querying Views
- Recursive and Non-Recursive CTEs
✅ Window Functions & Analytical Queries
- RANK(), DENSE_RANK(), ROW_NUMBER()
- LEAD() and LAG() for Trend Analysis
- Advanced Aggregations using PARTITION BY
✅ Working with JSON & NoSQL
- Querying and Manipulating JSON Data in SQL
- Integrating Relational SQL with NoSQL Systems
View this Course
Certified
You have 
