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

Explore the basic components of SQL queries, including comments, clauses, keywords, functions, identifiers, operators, and static values, and see how select, from, and where shape data retrieval.

Learn how SQL executes simple queries using select and from to retrieve all columns from tables like customers and orders, and refine results with specific columns and the where clause.

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.

Compare the coding and execution order of a SQL query, starting with select, then distinct and top, with from, where, groupby, having, and order by in execution.

Master running multiple queries in one window with semicolon separators and viewing separate result grids, including mixing static values with table data. Also learn to run only highlighted query parts.

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.

Insert data into tables using insert into with optional column lists and values, including multiple rows and nulls, and understand not null constraints when inserting.

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.

Use the between operator to check if a value lies within an inclusive range. Learn how to use lower and upper boundaries and alternative >= and <= approach in SQL.

Understand how the in operator checks if a value belongs to a list and how not in reverses it, with examples selecting customers from Germany or USA.

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.

Master the left anti-join by joining left and filtering where the right key is null to fetch left-side rows with no matches, illustrated with customers who haven't ordered.

Understand full anti join by using a full join and null checks to show unmatching data, including customers without orders and orders without customers.

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.

Master a multi-table join by starting from the main table and left joining customers, products, and employees in the sales db; use where and aliases to refine results.

Explore how to combine rows from two tables using set operators, including union, union all, except, and intersects, with a deep dive into these row-based operations.

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.

Use set operators to combine similar tables into one source table for data analysis or engineering, using union to avoid duplicates and listing explicit columns with a source column.

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.

Learn how to use upper and lower in SQL to transform text to uppercase or lowercase, with first name examples. Then explore the trim function.

Master the trim function to remove leading, trailing, and multiple spaces, cleanse data, and detect hidden white spaces using where clauses and length comparisons.

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.

Master how to use SQL substring to extract a middle portion by starting position and length, with dynamic length using the total characters after trimming whitespace.

Learn how date, time, and timestamp in SQL Server represent year-month-day, hours:minutes:seconds, and their combination as date time; see order date, ship date, and creation time.

Learn to manipulate date and time in SQL by extracting year, month, and day; changing formats; performing date add and date diff calculations; and validating dates with key functions.

Explore how the end of month function returns the last day of a date, with examples like August 2025, February 2025; learn to cast to date for clean reporting.

Learn how SQL handles date formats and format specifiers, including year-month-day order and case sensitivity, then format dates with format or convert and cast data types.

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 the nullif function compares two values and returns null if equal, otherwise the first value, with examples using columns or static values. Use it to avoid divide-by-zero errors.

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.

Clarify the differences between null, empty string, and blank spaces in SQL; show how length reveals empty vs space strings and discuss data quality, storage, and search implications.

Learn to handle nulls, empty strings, and blanks by defining data policies, cleaning data with trim, and using nullif and coalesce to prepare reliable data for analysis and reporting.

Understand how null values affect SQL queries and performance. Use coalesce, isnull, and nullif to replace or manage nulls before aggregations, joins, and sorting, then apply case statements for transformations.