SQL Analytics

After this skill you can…

• Write window functions (ROW_NUMBER, LAG, LEAD)
• Build reusable CTEs
• Explain query plans and add indexes

Prerequisites

Watch (10 videos)

Loading Data into Google Cloud SQL

Coursera · beginner hands-on

→ Import data into Cloud SQL→ Perform basic data analysis with SQL

Analyzing Billing Data with BigQuery

Coursera · intermediate hands-on

→ Apply SQL concepts to data analysis→ Use BigQuery for data analysis and visualization

Relational Database Design – Full Course

freeCodeCamp.org · beginner hands-on

→ Write SQL queries→ Optimize database performance

The ORDER BY Statement in SQL : Data Science Code

ritvikmath · intermediate hands-on

→ Sort data using ORDER BY statement→ Analyze data with SQL

MASTER SQL Basics in 1 Video! (From Zero to Pro - Full Course: Syntax, Databases, Real Examples)

Analytics Vidhya · beginner hands-on

→ Write SQL queries→ Manage databases→ Analyze data with SQL

Analyzing Big Data with SQL

Coursera · beginner hands-on

→ Write SQL queries for big data→ Optimize SQL queries for performance

SQL for Software Developers

Coursera · advanced hands-on

→ Optimize database performance→ Write complex SQL queries

Data Manipulation and Transactions in SQL Server

Coursera · intermediate hands-on

→ Modify database contents using SQL statements→ Implement transaction control mechanisms

The WHERE Statement in SQL : Data Science Code

ritvikmath · intermediate hands-on

→ Use the WHERE statement to subset data→ Apply SQL for data analysis

Intermediate PostgreSQL

Coursera · beginner hands-on

→ Perform advanced SQL queries in PostgreSQL→ Optimize database performance with indexing→ Manage database transactions

Read (10 articles)