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)

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

The WHERE Statement in SQL : Data Science Code

ritvikmath · intermediate hands-on

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

1 SQL Server Secrets You Won't Learn in School

Manish Sharma · beginner hands-on

→ Add an IDENTITY COLUMN in SQL Server→ Auto-generate IDs in SQL databases

SQL Tutorial: Creating PostgreSQL Databases

DataCamp · beginner hands-on

→ Create PostgreSQL databases→ Write SQL queries

Complete Learning | Smartly Designed | Personalized Feedback | Become a Data Analyst

The iScale · beginner hands-on

→ Write SQL queries for data analysis→ Analyze data using SQL

SQL Tutorial | Learn How to Insert Data into Tables

365 Data Science · beginner hands-on

→ Insert data into SQL tables→ Manage database scripts

SQL tutorials 17: SQL Primary Key constraint, Drop primary Key

Manish Sharma · beginner hands-on

→ Create a SQL table with primary key→ Drop a primary key constraint

What If You Knew This ONE SQL Secret

Manish Sharma · beginner hands-on

→ Clean data using SQL→ Fix inconsistent values with REPLACE

Read (10 articles)