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

SQL tutorial 34: How to copy /Insert data into a table from another table using INSERT INTO SELECT

Manish Sharma · beginner hands-on

→ Copy data between tables→ Use INSERT INTO SELECT statement

PL/SQL tutorial 67: PL/SQL Ref Cursors In Oracle Database by Manish Sharma

Manish Sharma · beginner hands-on

→ Use PL/SQL Ref Cursors in Oracle Database→ Manage databases with 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

Read (10 articles)