SQL DC Career & Skill Tracks

SKILL TRACKS

SQL Fundamentals – Skill Track

  1. Introduction to SQL
  2. Joining Data in SQL
  3. Intermediate SQL
  4. PostgreSQL Summary Stats and Window Functions
  5. Functions for Manipulating Data in PostgreSQL

SQL for Business Analysts – Skill Track

  1. Exploratory Data Analysis in SQL
  2. Data-Driven Decision Making in SQL
  3. Applying SQL to Real-World Problems
  4. Analyzing Business Data in SQL
  5. Reporting in SQL

SQL for Database Administrators Skill Track

  1. Introduction to Relational Databases in SQL
  2. Database Design
  3. Creating PostgreSQL Databases
  4. Improving Query Performance in PostgreSQL

SQL Server Fundamentals

  1. Introduction to SQL Server
  2. Joining Data in SQL
  3. Intermediate SQL Server
  4. Time Series Analysis in SQL Server
  5. Functions for Manipulating Data in SQL Server

SQL Server Toolbox

  1. Improving Query Performance in SQL Server
  2. Functions for Manipulating Data in SQL Server
  3. Time Series Analysis in SQL Server
  4. Writing Functions and Stored Procedures in SQL Server

SQL Server for Database Administrators

  1. Introduction to Relational Databases in SQL
  2. Database Design
  3. Hierarchical and Recursive Queries in SQL Server
  4. Transactions and Error Handling in SQL Server
  5. Writing Functions and Stored Procedures in SQL Server
  6. Building and Optimizing Triggers in SQL Server
  7. Improving Query Performance in SQL Server

 

CAREER TRACKS

Data Analyst with SQL Server – Career Track

  1. Introduction to SQL Server
  2. Introduction to Relational Databases in SQL
  3. Intermediate SQL Server
  4. Time Series Analysis in SQL Server
  5. Functions for Manipulating Data in SQL Server
  6. Database Design
  7. Hierarchical and Recursive Queries in SQL Server
  8. Transactions and Error Handling in SQL Server
  9. Writing Functions and Stored Procedures in SQL Server
  10. Building and Optimizing Triggers in SQL Server
  11. Improving Query Performance in SQL Server