Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Info
DataCamp = free and paid online courses ($300 per year) Skill tracks below contain individual free 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