Master_Class_1 SQL query Master Class_1 Output: - employee_table dept_locations_table dependent_table project_table works_on_table Master_Class_2 : Statements, Tables & DDL Commands SQL query Master Class_2 Output: - Master_Class_3 : DML and DDL Commands SQL query Master Class_3 Output: - SELECT command Filter selected columns from a table Filter all columns from a table Conditional select - WHERE Multiple conditions with AND keyword Multiple conditions with OR keyword Operators (>, >=, <, <=, etc.) A Operators (>, >=, <, <=, etc.) B Use of WILDCARDS and LIKE operators ('_') -> One character only Use of WILDCARDS and LIKE operators ('%') -> Any number of characters Using IN Using NOT IN Using BETWEEN Using ORDER BY (A) Using ORDER BY (B) Using NULL Using NOT NULL INSERT command Using INSERT command UPDATE command Using UPDATE command DELETE command Master_Class_4 : Joins SQL query Master Class_4 Output: - ALIAS ALIAS (A) ALIAS (B) JOINS INNER JOIN INNER JOIN LEFT JOIN LEFT JOIN (A) LEFT JOIN (B) RIGHT JOIN RIGHT JOIN (A RIGHT JOIN (B) CROSS JOIN CROSS JOIN JOINS AND FILTERING JOINS AND FILTERING (A) JOINS AND FILTERING (B) Master_Class_5 : NULLS and Aggregations SQL query Master Class_5 Output: - COUNT COUNT (A) COUNT (B) COUNT (C) DISTINCT DISTINCT (A) DISTINCT (B) DISTINCT (C) AVERAGE / MEAN AVERAGE (A) AVERAGE (B) SUM SUM (A) SUM (B) MIN MAX MIN MAX GROUP BY Clause GROUP BY (A) GROUP BY (B) GROUP BY (C) GROUP BY (D) GROUP BY (E) HAVING Clause HAVING DATE Function DATE (A) DATE (B) DATE (C) CASE Statement CASE Master_Class_6 : MySQL Subqueries SQL Query Master Class_6 OUTPUT: - PLACEMENT Query Types: - [A] NESTED Placement Query A-1 A-2 [B] INLINE Placement Query B-1 [C] SCALAR Placement Query C-1 [D] WITH Placement Query D-1 Common Table Expression (CTE) using WITH Placement Query D-2 D-3 Master_Class_7 : Subqueries Formatting SQL Query Master Class_7 OUTPUT: - CORELATED SUBQUERY Example 1 Example 2 VIEWS Example 1 Example 2 Example 3 Example 4 Example 5 Optimized Subquery Example 1 Master_Class_8 : Core Window Functions SQL Query Master Class_8 OUTPUT: - Window Function Example 1 Example 2 Example 3 Core Window Function Example 1 Example 2 Example 3 Types of Window Functions: - [A] RANK() Window Function Example 1 Example 2 [B] DENSE_RANK() Window Function Example 1 Example 2 [C] ROW_NUMBER() Window Function Example 1 Example 2 Master_Class_9 : Aliases for Multiple Window Functions SQL Query Master Class_9 OUTPUT: - COLUMN ALIASES EXAMPLE 1 EXAMPLE 2 TABLE ALIASES EXAMPLE 1 LAG() Window Function EXAMPLE 1 EXAMPLE 2 EXAMPLE 3 EXAMPLE 4 LEAD() Window Function EXAMPLE 1 RANK_PERCENT() Window Function / Percentiles EXAMPLE 1 EXAMPLE 2 EXAMPLE 3 Master_Class_10 : Data Cleaning Strategy SQL Query Master Class_10 OUTPUT: - LEFT() Function EXAMPLE 1 EXAMPLE 2 EXAMPLE 3 RIGHT() Function EXAMPLE 1 EXAMPLE 2 EXAMPLE 3 SUBSTRING() Function EXAMPLE 1 EXAMPLE 2 CONCAT() Function EXAMPLE 1 CAST() Function EXAMPLE 1 POSITION() Function EXAMPLE 1 EXAMPLE 2 COALESCE() Function EXAMPLE 1 EXAMPLE 2 EXAMPLE 3 Master_Class_11 : Advanced SQL and Performance Tuning SQL Query Master Class_11 OUTPUT: - NON EQUI JOINS EXAMPLE 1 EXAMPLE 2 SELF JOINS EXAMPLE 1 UNION() Operator EXAMPLE 1 FULL OUTER JOIN EXAMPLE 1 EXPLAIN() Utility in MySQL EXAMPLE 1
