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

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

VBA Live 10/18
CareerJump
© 2020 ScriptUni

CONTACT US TODAY TO START PLANNING AHEAD!