Learn SQL

What Is SQL? Why Learn SQL? What Can You Do With SQL? Relational Databases: Tables, Rows, and Keys Setting Up: Your First Database Our Sample Database Your First Query: SELECT Choosing Columns, Aliases, and Calculations DISTINCT: Unique Values Filtering Rows with WHERE Combining Conditions: AND, OR, NOT IN, BETWEEN, and LIKE NULL: Missing Values Sorting with ORDER BY Limiting Results and Pagination Data Types Text Functions Numbers and Arithmetic Dates and Times Aggregate Functions Grouping with GROUP BY Filtering Groups with HAVING Creating Tables Inserting Data Updating and Deleting Data How a Query Is Processed Comments and SQL Style

Joining Tables: INNER JOIN Table Aliases and Multi-Table Joins LEFT JOIN: Keeping Unmatched Rows RIGHT JOIN, FULL OUTER JOIN, and CROSS JOIN Self-Joins Subqueries Correlated Subqueries and EXISTS Common Table Expressions (WITH) CASE Expressions Set Operations: UNION, INTERSECT, EXCEPT Constraints and Foreign Keys Designing Tables and Relationships Normalization Views Upserts: Insert or Update Using SQL from Application Code Importing and Exporting Data SQL Dialects: PostgreSQL, MySQL, SQL Server, SQLite

Window Functions: Ranking Window Functions: Running Totals and Moving Averages Window Functions: LAG, LEAD, and NTILE Recursive Queries Indexes Reading Query Plans with EXPLAIN Query Optimization Techniques Transactions Isolation Levels and Concurrency JSON in SQL Full-Text Search Triggers, Stored Procedures, and Functions Database Security Schema Migrations Analytical SQL Patterns Databases in Production