2025 Complete SQL Bootcamp from Zero to Hero in SQL

Create SQL tables by defining a table name and multiple columns with their data types using the create table syntax, illustrated by a persons table example.

Practice creating sql tables by solving tasks: build a payment table with loan number, payment number, date, amount, and a salesperson table with first name, last name, city, and sales.

Learn how to use the SQL update statement to modify table data by setting a column to a new value, and update multiple columns with a conditional where clause.

Understand primary key constraints in SQL, enforcing unique and not null values, with single or composite keys, plus create, alter, and drop operations and the primary vs unique key distinction.

Use auto increment to generate a unique id for each table record, starting from a value (like 1 or 50 via alter table) not null, and incrementing automatically on inserts.

Explore the foreign key concept by linking an employee table to a department table through department id, showing how a primary key becomes a foreign key in another table.

Learn to use the order by clause to sort records by one or more columns in ascending or descending order, with examples on salary and property data.

Apply the intersect operator to two select statements to return common rows, such as cities found in both customers and suppliers, ordered by city name.

Drop an unnecessary view using the drop view syntax, specifying the view name to remove the entire view; for example, dropping the customers view from the customers table.

Learn the case expression in SQL to evaluate multiple conditions, returning the first true result and an else fallback. The example shows extracting city or country with null handling.

Explore subqueries in SQL, including a subquery that finds the minimum age in the customers table and returns full records for age 22, and compare with a join on orders.

Understand inner join operations between two tables and learn how only matching records are returned using a common join key, with an example query combining table a and table b.

Learn how the right outer join returns all records from table B and the matching records from table A, with nulls when there is no match.

Learn how a full outer join returns all records from both tables, including non-matching rows, with nulls where data is missing, using the on condition and a where clause.

Select sailor names from the sailor's table where rating is greater than eight. The query returns three sailors whose rating exceeds eight.

Identify the sids of sailors who reserved a red boat by joining the boats and reservations tables on bid and filtering for color red.

Learn to find sailors who reserved at least one boat by joining the sailors and resource tables on a common key and selecting their names.

This lesson uses employee and customer tables, linked by a foreign key from sales representative id to employee id, to return employees whose customers all have a good rating.

Join the students and performance tables on the student number, group by student name, and sum marks to produce Raj 310 and Rohit 140.