The Ultimate SQL Bootcamp : Go From Zero to Hero

Create a database and switch to it, then define an employees table with employee_id as the primary key, plus first_name, last_name, and birth_date using SQL create statements.

Learn to create tables in SQL, define columns and data types, set a primary key, apply not null and check constraints, and build a sample employee table.

Explore SQL data types, including numeric, character, and time types. Learn how integers, decimals, floats, text, and date and time values define database columns.

Explore how SQL constraints enforce data integrity in relational databases by applying not null, unique, and check constraints to table columns, including price greater than zero and non-negative stock.

Explore common table expressions to create a temporary result set and simplify complex SQL queries using the with syntax, inner joins, and aggregates like average amount and count.

Learn how to use the case statement in SQL to implement conditional logic, create computed columns, and categorize data—such as salary and stock status—based on specific conditions.

Learn how to use the alter table statement to modify a table’s structure by adding a salary decimal column to a data table created with employee_id, employee_name, and hire date.

Explore SQL aggregate functions to perform calculations on a set of values, including count, sum, and average, and learn how to use group by to analyze data by department.

Import an Excel CSV file into a SQL database using SQL Server Management Studio, mapping columns and validating data with the import wizard.

Master sql date and time handling by learning data types, formatting, and operations, then create and query an events table with date and time fields and range filters.

Master sql group by and having clauses to group data by department and job title, apply aggregate functions like average salary and employee count, and filter results with having.

Explore SQL time stamps and date time data types, create tables with event date time and order date and time, and insert timestamp values using current time stamps.

Master sql date and time handling by exploring data types, formatting, and common operations, including creating event tables, inserting date and time values, and querying by date and time ranges.

Master the extract function in sql to pull year, month, day, hour, minute, and day of week from date time values, with examples on the employees and events tables.

Explore SQL joins and syntax to combine data from multiple tables, covering inner, left, right, and full joins with a customer and payment example.

Explore self join, unions, and union all to manipulate data by joining a table to itself and combining results from multiple queries.

Explore subqueries in SQL by using nested inner queries to compare a customer's payment amount against the average amount paid by all customers, with practical syntax and examples.

Explore window functions in SQL, using over partition by and order by to perform aggregate, ranking, and analytic calculations with sum, average, count, minimum, and maximum.

Master the case statement in SQL to add conditional logic in queries, categorize salaries into low, medium, and high, and label stock status such as out of stock.

Explore the power of common table expressions (CTEs) to create temporary result sets within queries, using with syntax to simplify complex logic and enable readable, modular SQL.

Master SQL aliases to rename columns like item and cost, use or omit as, and concatenate data to display product details from a sample product table.

Learn how to use the between operator in SQL Server to filter employees by age, salary, and joining date within defined ranges, including boundary values and not between.