The Complete SQL Bootcamp: Go from Zero to Hero

Learn the basic syntax of select and where to filter rows with column conditions. Explore comparison and logical operators in PostgreSQL, including equals, not equals, and, or, and not.

Master using select, where, count, and logical operators in pgAdmin to filter the customer and film tables by rental_rate, replacement_cost, and rating.

Master the order by clause to sort query results by one or more columns in ascending or descending order, including multi-column sorting and handling duplicates after select and where.

Complete three-question assessment in article format, using provided answers to check work, learn that multiple approaches may solve each question, and follow with structured query language solutions in subsequent lectures.

Explore the AS clause to alias columns and functions for clearer output. Learn aliases appear only in the select output and can’t be used in where or having.

Master the left outer join by selecting all from the left table, joining on a key, and using where the right table is null to show left-only rows.

Explore advanced sql topics by mastering timestamps and the extract function, math and string functions, and learning sub-queries and self-joins.

Learn to extract sub components from timestamps using extract, calculate age with age, and format timestamps with to_char. Explore practical examples and date formatting patterns for clear, customizable date outputs.

Explore PostgreSQL string functions and operators to edit, concatenate, and format text data, using length, upper and lower, and examples like constructing emails from first letters.

Learn how to restore a two-schema PostgreSQL database (public and cd), then query cd.bookings and cd.facilities to explore bookings, facilities, and member data used for assessment exercises.

Learn how to use the INSERT command to add rows with values or from another table, while enforcing not null constraints, serial primary keys, and foreign keys in pgAdmin.

Explore conditional expressions and operators in SQL, using CASE, COALESCE, NULLIF, and CAST to add logic to commands and workflows; learn to create views and use pgAdmin import/export features.

Learn how to use the case statement in SQL to conditionally return values with when-then-else, using both general case and case expression forms to categorize data and compute counts.

Learn how the nullif function returns null when two inputs match and the first input otherwise, demonstrated with a department ratio calculation that avoids division by zero.