ScriptUni ScriptUni
  • Career Coach
  • Additional Resources
    • Career Tips
    • LinkedIn
    • YouTube
  • FAQs
Select Page
  • Cart
  • Contact us
  • Login

Add Column

Add Column

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 > 4: Tables Syntax
    © 2020 ScriptUni

    CONTACT US TODAY TO START PLANNING AHEAD!