Career Coach
Additional Resources
Career Tips
LinkedIn
YouTube
FAQs
Select Page
Cart
Contact us
Login
Full Join Workaround
Full Join Workaround
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
> 6: Join & Union
