SQL TRAINING WHEELS

Want to learn about databases and speak their language? Get a comprehensive command of SQL and Databases and build queries with confidence.

SQL_TrainingWheels_Emp.jpg

 
 

HOW WE WORK  

  • 6 Modules: 6 Weeks
    • Weekly Modules: 2 hour class + 1 hour online session
    • Comprehensive lecture followed by a hands-on workshop
    • Access to module material and exercises
    • Register per module or sign up for 6 weeks
    • 8 students maximum per class
       
  • Real Life Project
  • Use your database and SQL query writing skills to manage a data project of a NYC based business
  • Acquire hands-on experience in managing an SQL project
  • Pre-requisite: completion of Modules 1-6

WHAT YOU’LL LEARN

  • Module 1: What the Hell is SQL?
    • Writing Queries
    • Sorting Querty Results
       
  • Module 2: Chopping up Data
    • The WHERE Clause
    • Creating Calculated Columns
    • The CASE Statement
       
  • Module 3: Dating and Relationships
    • Joins in Queries
       
  • Module 4: Dysfunctional Families
    • Using Functions in Queries
    • Working with Text in Queries
       
  • Module 5: Group Therapy
    • Working with Dates in Queries
    • Aggregate Functions
    • Grouping Data
       
  • Module 6: Subway Station Subquery
    • Using Subqueries
    • Creating Correlated Subqueries
       
  • “NYC Real”: The Project