SQL Masterclass

"Introduction Course Overview! Installation And Getting Started The Final Milestone! Installing and setting up PostgreSQL Case Study : Demo Case Study Part 1 Case Study Part 2 Fundamental SQL statements CREATE Exercise 1: Create DB and Table INSERT Import data from File Exercise 2: Inserting and Importing SELECT statement SELECT DISTINCT WHERE Logical Operators Exercise 3: SELECT & WHERE UPDATE DELETE ALTER Exercise 4: Updating Table Restore And Back-Up Restore and Back-up Exercise 5: Restore and Back-up Selection Commands: Filtering IN BETWEEN LIKE Exercise 6: In, Like & Between Selection Commands: Ordering Side Lecture: Commenting in SQL ORDER BY LIMIT Exercise 7: Sorting Alias AS Aggregate Commands COUNT SUM AVERAGE MIN & MAX Exercise 8: Aggregate functions Group By Commands GROUP BY HAVING Exercise 9: Group By Conditional Statement CASE WHEN Joins Introduction to Joins Inner Join Left Join Right Join Full Outer Join Cross Join Except Union Exercise 10: Joins Subqueries Exercise 11: Subqueries Views And Indexes VIEWS INDEX Exercise 12: Views String Functions LENGTH Upper Lower REPLACE TRIM, LTRIM, RTRIM CONCATENATION SUBSTRING LIST AGGREGATION Exercise 13: String Functions Mathematical Functions CEIL & FLOOR RANDOM SETSEED ROUND POWER Exercise 14: Mathematical Functions Date-Time Functions CURRENT DATE & TIME AGE EXTRACT Exercise 15: Date-time functions Pattern (String) Matching PATTERN MATCHING BASICS ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) Exercise 16: Pattern Matching Data Type Conversion Functions Converting Numbers/ Date to String Converting String to Numbers/ Date User Access Control Functions User Access Control Bonus Section: Nail That Interview! Tablespace PRIMARY KEY & FOREIGN KEY ACID compliance Truncate Performance Tuning Tips TIP 1 (EXPLAIN) TIP 2 TIP 3 TIP 4 (VACCUM) TIP 5 TIP 6 (STRING FUNCTIONS) TIP 7 (JOINS) TIP 8 (SCHEMAS) Bonus Section : Database Basics What is SQL Tables and DBMS Types of SQL commands PostgreSQL The Final Milestone!"