Career Coach
Additional Resources
Career Tips
LinkedIn
YouTube
FAQs
Select Page
Cart
Contact us
Login
Temporary Tables
Temporary Tables
Please sign up for the
course
before starting the lesson.
1: Basic Queries
Intro to SQL
Select
Select Star
Select Distinct
Select Where
Select Like
Where In
Dates
Between
Multiple Filters
Order By
Limit
Multiple Filters Or
MySQL Setup – Loading Tables
3: Tables 101
Intro to Tables
Map
Dimension
Fact
Database Schema
Primary Key
Foreign Key
Primary Key – Foreign Key Relationship
Table Index
Column Constraints
2: Intermediate SQL Syntax
Case When
Aliases
Is Null
Coalesce
Sum
Average
Decimal Precision
4: Tables Syntax
Create Table
Add Column
Update Column
Rename Column
Row Oriented vs Column Oriented
Views
Create View
5: Modifying Data
Delete
Orphaned Records
Updating Data
Updating From an External Table
Adding From an External Table
Adding New Data
6: Join & Union
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
Subqueries
Common Table Expressions
Deterministic Functions
Temporary Tables
Order of Execution
Stored Procedures
Back to:
Advanced SQL for Finance
> 7: Advanced Topics in SQL
