Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info
  • DataCamp = free and paid online courses

  • Skill tracks listed below contain individual courses.

  • The same course may appear in several tracks.

  • Most relevant to custom report building = *


SQL Fundamentals

  • Introduction to SQL Server (4 hours)

  • Joining Data in SQL (5 hours)

  • Intermediate SQL (4 hours)

  • PostgreSQL Summary States and Window Functions (4 hours)

  • Functions for Manipulating Data in SQL Server (4 hours)


SQL Server Fundamentals*

  • Introduction to SQL Server (4 hours)

  • Joining Data in SQL (5 hours)

  • Intermediate SQL Server (4 hours)

  • Time Series Analysis in SQL Server (5 hours)

  • Functions for Manipulating Data in SQL Server (4 hours)


SQL Server Toolbox

  • Functions for Manipulating Data in SQL Server (4 hours)

  • Time Series Analysis in SQL Server (5 hours)

  • Writing Functions and Stored Procedures in SQL Server (4 hours)

  • Improving Query Performance in SQL Server (4 hours)


SQL for Business Analysts*

  • Exploratory Data Analysis in SQL (4 hours)

  • Data-driven Decision Making in SQL (4 hours)

  • Applying SQL to Real-World Problems (4 hours)

  • Analyzing Business Data in SQL (4 hours)

  • Reporting in SQL (4 hours)


SQL Server for Database Administrators*

  • Introduction to Relational Databases in SQL (4 hours)

  • Database Design (4 hours)

  • Hierarchical and Recursive Queries in SQL Server (4 hours)

  • Transactions and Error Handling in SQL Server (4 hours)

  • Writing Functions and Stored Procedures in SQL Server (4 hours)

  • Building and Optimizing Triggers in SQL Server (4 hours)

  • Improving Query Performance in SQL Server (4 hours)


SQL for Database Administrators

  • Introduction to Relational Databases in SQL (4 hours)

  • Database Design (4 hours)

  • Creating PostgreSQL Databases (4 hours)

  • Improving Query Performance in SQL Server (4 hours)


Table of Contents