Progress The Complete SQL Bootcamp Complete & Continue Next Lesson Learn More Introduction to SQL 7 Lessons The Complete SQL Bootcamp What is SQL used for? What opportunities open up if I learn SQL? Database Installation Datasets used in this course Database Overview Getting to know our first schema Module 1 - Fundamental SQL Syntax 16 Lessons Single / Multi-line comments SELECT / FROM Statements Select Unique Values (DISTINCT) Single Quotes, Double Quotes, Back-ticks ALIAS Tables & Columns Filtering Rows of Data (WHERE) Multiple Conditions (AND) Multiple Conditions (OR) Using both AND & OR in a single query Filter by multiple values at once (IN) Filtering Data BETWEEN two values NULL data (IS NULL / IS NOT NULL) Wildcard Matches (LIKE / % / _ / REGEXP) NOT Keyword Sorting Data (ORDER BY / ASC / DESC) Limit your query results Module 2 - Data Aggregations 8 Lessons What are data aggregations? The GROUP BY Keyword Counting Records (COUNT) Summation (SUM) Finding the Minimum & Maximum value (MIN / MAX) Calculating Averages (AVG) Filtering aggregated data (HAVING) Totals & Subtotals on Aggregated data (WITH ROLLUP) Module 3 - Generating Your Own Columns of Data 6 Lessons Generating new columns in the result set Arithmetic Operators Aggregating New Columns Conditional Statements Part 1 Conditional Statements Part 2 Multi-conditional statements Module 4 - SQL Functions & Operators 5 Lessons Comparison Operators String Functions Numeric Functions Comparison Functions Window Functions Module 5 - Working with Dates 6 Lessons Extracting Date Information Current Date & Time functions Extracting Time Information Performing Calculations on Dates & Times Formatting Dates (DATE_FORMAT) Filtering by dates Module 6 - Joining Data 7 Lessons Join Types Primary & Foreign Keys Inner Joins (INNER JOIN) Left Joins (LEFT JOIN) Right Joins (RIGHT JOIN) Joining multiple tables with filters and aggregations Appending tables together (UNION / UNION ALL) Module 7 - MySQL Join Emulation 3 Lessons Full Outer Join Emulation Intersect Emulation Minus Emulation Module 8 - Creating a Database 13 Lessons Datatypes Overview - Numeric Datatypes Datatypes - Boolean, String & Dates Creating a schema / database Creating a database table (CREATE TABLE) Inserting data into a table (INSERT / INTO) Updating data in a table (UPDATE / SET) Deleting data from a table (DELETE) Deleting data from a table (TRUNCATE) Altering table structures (ALTER) Deleting tables from a database (DROP) Transactions (COMMIT / ROLLBACK) Delete from multiple tables using JOINS Load data from a csv file (LOAD DATA) Module 9 - Temporary Tables, CTE's & Subqueries 4 Lessons Introduction to Temporary Tables Creating a temporary table Common Table Expressions (CTE) Derived Tables / Subqueries Module 10 - Database Views 5 Lessons Introduction to Views Creating a View Renaming & Dropping Views Create updatable views Understanding how views are processed Module 11 - Stored Procedures 10 Lessons What is a stored procedure? Understanding the DELIMITER How to create a new stored procedure Deleting stored procedures Introducing variables Introducing parameters and arguments How to change a stored procedure IF - ELSEIF - ELSE Conditional Statements CASE WHEN Conditional Statements Part 1 CASE WHEN Conditional Statements Part 2 Module 12 - Loops 5 Lessons Understanding Loops with FizzBuzz! Loops Loops - ITERATE keyword WHILE Loop REPEAT Loop Module 13 - Functions 4 Lessons What is a function? How to create a stored function Using functions in stored procedures Deleting and altering stored functions Module 14 - Introduction to Cursors 1 Lesson Cursors Module 15 - Introduction to Triggers 6 Lessons What is a trigger Our first trigger (BEFORE UPDATE) Trigger Use Case 2 Trigger Use Case 3 Multiple triggers on same table Deleting Triggers Module 16 - Using SQL in other Software / Languages 4 Lessons SQL in Tableau SQL in Alteryx SQL in Python Exporting data in a variety of file formats Module 17 - Final Remarks 1 Lesson Congratulations The Complete SQL Bootcamp Complete & Continue Next Lesson Learn More Introduction to SQL Database Installation
