Advanced SQL for Finance Register or log in to view this course. Modules 1: Basic Queries Lessons Intro to SQL MySQL Setup – Loading Tables Select Select Star Select Distinct Select Where Select Like Where In Dates Between Multiple Filters Multiple Filters Or Order By Limit 2: Intermediate SQL Syntax Lessons Case When Aliases Is Null Coalesce Sum Average Decimal Precision 3: Tables 101 Lessons Intro to Tables Map Dimension Fact Database Schema Primary Key Foreign Key Primary Key – Foreign Key Relationship Table Index Column Constraints 4: Tables Syntax Lessons Create Table Add Column Update Column Rename Column Row Oriented vs Column Oriented Views Create View 5: Modifying Data Lessons Delete Orphaned Records Updating Data Updating From an External Table Adding New Data Adding From an External Table 6: Join & Union Lessons Intro to Joins Join Types Inner Join Left and Right Joins Full Outer Join Self Join Union Full Join Workaround 7: Advanced Topics in SQL Lessons Subqueries Common Table Expressions Deterministic Functions Temporary Tables Order of Execution Stored Procedures
1: Basic Queries Lessons Intro to SQL MySQL Setup – Loading Tables Select Select Star Select Distinct Select Where Select Like Where In Dates Between Multiple Filters Multiple Filters Or Order By Limit
3: Tables 101 Lessons Intro to Tables Map Dimension Fact Database Schema Primary Key Foreign Key Primary Key – Foreign Key Relationship Table Index Column Constraints
4: Tables Syntax Lessons Create Table Add Column Update Column Rename Column Row Oriented vs Column Oriented Views Create View
5: Modifying Data Lessons Delete Orphaned Records Updating Data Updating From an External Table Adding New Data Adding From an External Table
6: Join & Union Lessons Intro to Joins Join Types Inner Join Left and Right Joins Full Outer Join Self Join Union Full Join Workaround
7: Advanced Topics in SQL Lessons Subqueries Common Table Expressions Deterministic Functions Temporary Tables Order of Execution Stored Procedures