4 Topics Available
SQL Fundamentals
Master SQL Fundamentals from core theoretical foundations to practical industry applications.
1Module 1: Relational Query Execution
Core modules and technical concepts for SQL Fundamentals.
Topic 1.1: Data Querying and Manipulation
Foundational and applied principles of Data Querying and Manipulation.
SELECT, FROM, WHERE, and Conditional Filtering
Comprehensive technical guide and practical walkthrough of SELECT, FROM, WHERE, and Conditional Filtering.
Data Modification: INSERT, UPDATE, and DELETE
Comprehensive technical guide and practical walkthrough of Data Modification: INSERT, UPDATE, and DELETE.
Topic 1.2: Aggregation and Joining
Foundational and applied principles of Aggregation and Joining.
INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Comprehensive technical guide and practical walkthrough of INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
GROUP BY, Aggregate Functions (COUNT, SUM, AVG), and HAVING
Comprehensive technical guide and practical walkthrough of GROUP BY, Aggregate Functions (COUNT, SUM, AVG), and HAVING.