Learn SQL in an hour

Explore the basics and advanced concepts of SQL, including data types, variables, joins, CRUD operations, functions, dynamic temporary tables and variables, and stored procedures and triggers.

Learn that sql, the structured query language, is used to query, insert, and delete data in relational databases of tables with rows and columns, and to analyze data with functions.

Explore sql data types by defining a column for every field when creating a table, with examples from a sales table using integer, string, decimal, and date types.

Create and relate two SQL tables, customers and sales, using a primary key and a foreign key on customer_id, then define columns and constraints.

Learn to perform create, read, update, and delete operations on SQL tables by adding a new email column, updating specific records, inserting new rows, and deleting rows.

Explore the four SQL joins—inner, left, right, and full outer—showing how each join combines two tables on a condition and handles matching or nonmatching rows.

Learn how to apply inner, left, right, and outer joins in SQL by joining sales and customer tables on customer_id, and see how matches affect results.

Learn SQL operators, including arithmetic, comparison, and logical operators, and use like, between, and where clauses to filter and query data.

Learn to apply sql operators: equals, in, like, greater than, not equal to, and between, to filter a real estate analytics table by city, square footage, and zip codes.

Explore built-in and user-defined SQL functions to perform string, numeric, and date operations, including lower/upper, trim, substring, length, absolute value, date arithmetic, casting, and if function.

Apply SQL functions such as lower, length, and date extraction; sort, top n rows, group by city, and compute max, average, and is null checks to analyze a retail database.

Explore essential SQL statements and keywords, including case for multiple conditions, subqueries, unions, and distinct. Learn cloning with into and operations like truncate, drop, and if exists.

Declare dynamic sql and temporary variables to fetch data from sales and customer databases, then union results from corresponding tables to display combined data.

Create temporary tables and common expressions to perform on-the-fly calculations inside stored procedures, merge multiple columns into a single address field, and query or delete the results.

Learn how to create and execute a stored procedure with an address parameter, build a temporary table, perform calculations, and retrieve sales price by address.

Explore triggers in sql, including dma and ddl triggers, and learn to create after triggers that alert admins on inserts.