The Complete SQL Bootcamp: Go from Zero to Hero

Tackle progressively challenging postgres tasks through a dvd rental store scenario, with simple repeat-and-verify exercises evolving into solutions and walkthroughs on the example database.

Master the select statement to retrieve data from a table in PostgreSQL, choosing specific columns or all columns with an asterisk, and learning when to use semicolons for readability.

Translate a business need into a select query to fetch customers' first names, last names, and emails from the customer table in Postgres for promotional emails.

Master the count function to return the number of rows in a query, using a column or an asterisk, and combine it with distinct to count unique values.

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.

Combine the select clause with the where statement to specify conditions using logical and comparison operators. Translate real-world business questions into SQL queries, like locating a customer’s email by name.

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.

Explore the between operator to filter data within a range, including endpoints, and its not between negation. Learn date and timestamp usage with ISO 8601 formats and practical pgAdmin examples.

Explore how the in operator checks multiple values with a single condition, replacing many or statements and not in examples, using color, amount, and names from sample queries.

Master pattern matching in SQL with LIKE and ILIKE using percent and underscore wildcards. Use examples like emails ending with @gmail.com or names starting with A, noting case sensitivity.

Master group by and aggregate functions in SQL to analyze data by category, apply having filters, and practice with PG admin and PG SQL challenges.

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 join types in PostgreSQL, starting with the as clause for aliases, then inner, left, right outer joins, full outer joins, unions, and more, with practical tasks.

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 sql mathematical operators and functions in postgres, using pgAdmin examples to perform arithmetic, rounding, and percentage calculations on film data, with practical aliases and deposits.

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.

Explore subqueries and the exists function to build complex queries, using inner selects, in operators, and practical pgAdmin examples to filter and join data.

Learn to perform a self-join by joining the same table to itself using aliases, enabling pairings such as employees and their reports or films sharing the same length.

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 how to alter table structures with the alter table command, including adding, dropping, and renaming columns, changing data types, defaults, and constraints.

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.