Explore SQL with AlgoGalaxy's Creative Educational Resources.

AlgoGalaxy

University

CodeRush

Jobs

Tools

Insights

Explore

Personalize

PostgreSQL Joins MongoDB MySQL Stored Procedures T-SQL Views Indexing Locks Transactions ACID Database Design Normalization Node.js NestJS Spring Boot Express.js Hibernate GraphQL JPA

SQL | Fundamentals

SQL Fundamentals: Tables

SQL Fundamentals: INSERT

SQL Fundamentals: SELECT

SQL Fundamentals: Constraints

SQL Fundamentals

SQL | Filtering & Sorting

SQL Filtering and Sorting: WHERE

SQL Filtering and Sorting: ORDER BY

SQL Filtering and Sorting: NULL Handling

SQL Filtering and Sorting: Pagination

SQL Filtering and Sorting

SQL | Aggregation

SQL Aggregation: COUNT and SUM

SQL Aggregation: GROUP BY

SQL Aggregation: HAVING

SQL Aggregation: Aggregate Review

SQL Aggregation

SQL | Subqueries

SQL Subqueries: Scalar Subqueries

SQL Subqueries: EXISTS

SQL Subqueries: IN

SQL Subqueries: Correlated Queries

SQL | CTEs

SQL CTEs: Named CTEs

SQL CTEs: Multiple CTEs

SQL CTEs: Recursive CTEs

SQL CTEs: Readable Queries

SQL | Window Functions

SQL Window Functions: OVER

SQL Window Functions: PARTITION BY

SQL Window Functions: Ranking

SQL Window Functions: Running Totals

SQL Window Functions

SQL | Transactions

SQL Transactions

SQL Transactions: BEGIN and COMMIT

SQL Transactions: Rollback

SQL Transactions: Isolation

SQL Transactions: Write Boundaries

SQL | Indexes

SQL Indexes: Lookup Indexes

SQL Indexes: Composite Indexes

SQL Indexes: Plan Review

SQL Indexes: Index Hygiene

SQL | Joins

SQL Joins: INNER JOIN

SQL Joins: LEFT JOIN

SQL Joins: Join Conditions

SQL Joins: Join Review

SQL | Advanced SQL

Advanced SQL: Set Operations

Advanced SQL: MERGE and Upsert

Advanced SQL: Views

Advanced SQL: Production Queries

SQL

SQL (Structured Query Language) is the standard language for managing and manipulating relational databases.What you will be learning in this course??

Declarative

Specify what data you want, not how to get it.

Standardized

ANSI/ISO standard with vendor extensions.

CRUD Operations

Create, Read, Update, Delete records.

Data Definition

CREATE, ALTER, DROP for schema.

Query Optimization

Database engines optimize query execution.

Explore SQL with AlgoGalaxy's Creative Educational Resources.