Datacamp

SQL Tracks

You can keep tracking yoru progress here.

Data Analyst with SQL Server

• Introduction to SQL Server

• Introduction to Relational Databases in SQL

• Intermediate SQL Server

• Time Series Analysis in SQL Server

• Functions for Manipulating Data in SQL Server

• Database Design

• Transactions and Error Handling in SQL Server

• Writing Functions and Stored Procedures in SQL Server

• Building and Optimizing Triggers in SQL Server

• Improving Query Performance in SQL Server

Finished Projects

• Analyze International Debt Statistics

• When Was the Golden Age of Video Games?

• Analyzing NYC Public School Test Result Scores

• Analyzing American Baby Name Trends

• Optimizing Online Sports Retail Revenue

• What and Where are the World's Oldest Businesses

Other Courses

• Introduction to SQL

SQL Server

Course	Chapter	H	Videos	Exercises
Introduction to SQL Server	SELECTion Box	4	13	46
Groups, strings, and counting things
Joining tables
You've got the power
Intermediate SQL Server	Summarizing Data	4	14	47
Math Functions
Processing Data in SQL Server
Window Functions
Functions for Manipulating Data in SQL Server	Choosing the appropriate data type	4	14	54
Manipulating time
Working With Strings
Recognizing Numeric Data Properties
Cleaning Data in SQL Server Databases	Starting with Cleaning Data	4	13	48
Dealing with missing data, duplicate data, and different date formats
Dealing with out of range values, different data types, and pattern matching
Combining, splitting, and transforming data
Hierarchical and Recursive Queries in SQL Server	Recursion and Common Table Expression (CTE)	4	13	47
Hierarchical and Recursive Queries
Creating Data Models on Your Own
Hierarchical Queries of Real-World Examples
Time Series Analysis in SQL Server	Working with Dates and Times	5	16	60
Converting to Dates and Times
Aggregating Time Series Data
Answering Time Series Questions with Window Functions
Improving Query Performance in SQL Server	Introduction, Review and The Order of Things	4	16	58
Filtering and Data Interrogation
Sub-queries and presence or absence
Query performance tuning
Writing Functions and Stored Procedures in SQL Server	Temporal EDA, Variables & Date Manipulation	4	16	57
User Defined Functions
Stored Procedures
NYC Taxi Ride Case Study
Transactions and Error Handling in SQL Server	Starting with error handling	4	14	52
Raising, throwing and customizing your errors
Transactions in SQL Server
Controlling the concurrency: Transaction isolation levels
Building and Optimizing Triggers in SQL Server	Introduction to Triggers	4	15	49
Classification of Triggers
Trigger Limitations and Use Cases
Trigger Optimization and Management

General DB Knowledge

SQL

Course	Chapter	H	Videos	Exercises
Analyzing Business Data in SQL	Revenue, cost, and profit	4	15	46
User-centric KPIs
ARPU, histograms, and percentiles
Generating an executive report
Introduction to SQL	Selecting columns	4	1	41
Filtering rows
Aggregate Functions
Sorting and grouping
Intermediate SQL	We'll take the CASE	4	15	55
Short and Simple Subqueries
Correlated Queries, Nested Queries, and Common Table Expressions
Window Functions
Exploratory Data Analysis in SQL	What's in the database?	4	16	58
Summarizing and aggregating numeric data
Exploring categorical data and unstructured text
Working with dates and timestamps
Introduction to Relational Databases in SQL	Your first database	4	13	45
Enforce data consistency with attribute constraints
Uniquely identify records with key constraints
Glue together tables with foreign keys
Joining Data in SQL	Introduction to joins	5	13	53
Outer joins and cross joins
Set theory clauses
Subqueries
Reporting in SQL	Exploring the Olympics Dataset	4	15	54
Creating Reports
Cleaning & Validation
Complex Calculations
Applying SQL to Real-World Problems	Use Real-World SQL	4	13	47
Find Your Data
Manage Your Data
Best Practices for Writing SQL
Database Design	Processing, Storing, and Organizing Data	4	13	52
Database Schemas and Normalization
Database Views
Database Management
Data-Driven Decision Making in SQL	Introduction to business intelligence for a online movie rental database	4	15	54
Decision Making with simple SQL queries
Data Driven Decision Making with advanced SQL queries
Data Driven Decision Making with OLAP SQL queries

PostgreSQL

Course	Chapter	H	Videos	Exercises
Creating PostgreSQL Databases	Structure of PostgreSQL Databases	4	16	51
PostgreSQL Data Types
Database Normalization
Access Control in PostgreSQL
Functions for Manipulating Data in PostgreSQL	Overview of Common Data Types	4	13	50
Working with DATE/TIME Functions and Operators
Parsing and Manipulating Text
Full-text Search and PostgresSQL Extensions
PostgreSQL Summary Stats and Window Functions	Introduction to window functions	4	12	44
Fetching, ranking, and paging
Aggregate window functions and frames
Beyond window functions
Cleaning Data in PostgreSQL Databases	Data Cleaning Basics	4	15	49
Missing, Duplicate, and Invalid Data
Converting Data
Transforming Data
Improving Query Performance in PostgreSQL	Bringing Together the Data	4	15	53
Minimizing Results and Decreasing the Load
Using Database Designed Properties
Assessing Query Performance
Transactions and Error Handling in PostgreSQL	Getting to know transactions	4	15	49
Rolling back and Savepoints
Handling exceptions
Stacked Diagnostics