The Complete SQL Bootcamp (30 Hours): Go from Zero to Hero

Learn to use order by to sort SQL data, choosing ascending or descending, and apply nested sorting with multiple columns such as country and score.

Explore how the SQL top clause limits results by row count after select. Combine top with order by to fetch the highest or lowest scores and the most recent orders.

Learn how to alter an existing table to add a new column and drop a column, including defining a varchar(50) not null email and removing the phone column.

Use the update command to modify existing rows by setting new values and applying a where clause. Update single or multiple rows, handle null values, and verify with select.

Master the and operator by combining multiple where conditions, requiring both predicates to be true, as demonstrated with USA and score above 500 in the customers data.

Harness the not operator as a reverse, single-condition tool that excludes matching values and flips true to false. Learn its use with score not less than 500 and between operator.

Explore the SQL like operator to pattern search text with % and _, including starts with, ends with, and contains. See examples filtering customers by first name.

Learn how to join two tables with sql joins, using left and right tables, apply set operators for stacked rows, data enrichment with master and lookup tables, and existence checks.

Learn how a full join returns all rows from both tables, including unmatched rows with nulls, and that the order of tables doesn't matter, unlike inner, left, or right joins.

Use the cross join to generate every possible combination of two tables, creating a Cartesian join result, suitable for test data or simulations, such as customers with orders.

Compare inner, left, full joins and left anti-join to handle matching, all, or unmatching data, and discover why left join is the favored choice.

Explore the syntax of set operators in SQL, combining two selects with union and others. Remember end order by placement and ensure matching column counts and data types.

Learn how the union operator combines two queries into one results set, removing duplicates and mapping fields like first name and last name from customers and employees.

Learn how the SQL except operator returns distinct rows from the first query that are not found in the second, with the order of queries shaping the result.

Learn how the SQL intersect operator returns only the rows common to two queries, eliminating duplicates, with practical examples showing common employees and customers.

Learn to manipulate strings by grouping functions, then use concat to combine first name and country into one name country column with a space; explore upper, lower, replace, and substring.

Master the SQL replace function to swap old values for new ones, remove characters by replacing with nothing, and apply changes to dashes and file extensions.

Master the sql len function to count characters in strings, numbers, and dates, returning a numeric length for any value, and learn how left and right extract parts of string.

Explore SQL string manipulation with left (lift) and right functions to extract characters from the start or end of values, using trim and substring techniques.

Learn to format dates and numbers in sql using the format function. Build custom date formats, culture-aware styles, and practical examples for reporting and aggregations.

Learn to use the SQL convert function to cast data types and format values with style options, with examples like string to integer and date time to date.

Learn how the cast function converts values between data types using the as syntax, with examples from string to integer and string to date, and compare with convert and format.

Discover how the isdate function validates values as dates, returning 1 for valid dates and 0 for invalid ones, and how to use it for data cleaning and safe casting.

Explore is null and coalesce in SQL, replacing nulls with a default or another column, understand first non-null value, compare two-value isnull with multi-value coalesce, and note cross-database behavior.

Learn to handle nulls before math operations using coalesce or Isnull, build safe full names by concatenating first and last names, and apply a ten-point score bonus.

Learn to handle nulls in join keys with coalesce or Isnull to avoid missing records when joining tables; replace nulls with a default value to ensure accurate results.

Learn how to use is null and is not null to test for missing values, and apply isnull with joins to find missing data such as scores or orders.