ScriptUni ScriptUni
  • Career Advice
    • Hire a Coach
    • CareerJump (Free)
    • LinkedIn
    • YouTube
  • FAQs
Select Page
  • Cart
  • Contact us
  • Login

Intro to Tables

Intro to Tables

Please sign up for the course before starting the lesson.
  • Elan Goldberg Elan Goldberg says:
    12/20/2020 at 9:35 AM

    is assignment #2 uploaded?

    Log in to Reply

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

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

2: Intermediate SQL Syntax

  • Case When
  • Aliases
  • Is Null
  • Coalesce
  • Sum
  • Average
  • Decimal Precision
Back to: Advanced SQL for Finance > 3: Tables 101
© 2020 ScriptUni

CONTACT US TODAY TO START PLANNING AHEAD!