The Complete SQL Bootcamp : From Beginner to Advanced

Design a company database by modeling entities such as employees, departments, and projects, establishing one-to-many and many-to-many relationships, and applying primary and foreign keys through normalization.

Install mysql server on macos or windows for practicing sql, install mysql workbench, start the server, log in as root with a simple password, and verify the installation.

Install PostgreSQL with the official installer on macOS, Windows, or Linux, set a memorable password, and accept the default port, then connect via pgadmin4 and create your company db.

Create the company database in MySQL Workbench, then run a full SQL script to build departments, employees, and projects tables and seed data, preparing your environment for SQL practice.

Explore creating database structures with data definition language by defining tables such as department, employees, and projects, including primary keys, foreign keys, a composite key, and many-to-many relations via employee_projects.

Learn how to insert data with SQL DML, using insert into syntax, column order, and values for departments and employees, including multiple rows and null handling. Then explore select queries.

Explore core SQL clauses—select, from, where, group by, having, order by, limit, offset, and join—and learn to build simple queries with filters and aggregations.

Understand the order of execution for SQL clauses: from, where, group by, having, select, and order by, with select and from being mandatory.

Learn to write basic sql select queries to retrieve all columns from a single table, with examples from employees and projects.

Learn to filter columns in SQL by selecting specific fields such as first name, last name, job title, salaries, and project names from tables, with flexible column order.

Learn how to alias columns in SQL to rename results, using select with as alias, such as first name as f name, annual salary, and full name with concat_ws.

Master the distinct keyword in SQL queries to return unique department IDs and salaries, using practical examples from employees and department tables in MySQL workbench.

Learn to use the order by clause as the final clause, choosing ascending or descending order, and sorting single or multiple columns, such as salary and hire date.

Learn to use limit and offset to cap and skip rows in SQL queries. Order by salary or hire date and apply offset and limit to fetch specific ranges.

Design an ecommerce database by identifying entities (customers, products, categories, orders, payments, reviews, order items), mapping one-to-many and many-to-many relationships, and implementing a seven-table schema for SQL practice.

Install and set up the e-commerce db in MySQL Workbench by creating a schema, importing the e-commerce .sql file, and populating core tables for hands-on sql with company db.

Explore normalization as a database design technique, moving from er diagrams to decomposition, addressing redundancy and partial and transitive dependencies, and applying 1nf, 2nf, 3nf/bcnf.

Explore natural join to retrieve data from multiple tables by joining on common columns like department_id, with aliasing and examples using employees, departments, and projects.

Learn how to filter records with the where clause in SQL queries, using conditions on department, hire date, and salary, and explore comparison, logical, membership, like, and between operators.

Master using comparison operators in the where clause to filter records in SQL. Practice queries like filtering accountants, ordering hires since 2020, and listing customer emails not from Delhi.

Learn how to write compound conditional statements in SQL where clauses using and, or, not, with truth tables and practical examples.

Learn how to use the membership operator in the where clause to filter records with in and not in, with examples for department IDs and project IDs.

Master pattern matching in sql by filtering records with the where clause and pattern matching operators. Use percentile and underscore wildcards to build queries for names, emails, and domains.

Master range queries with the between operator in the where clause to filter salaries 60,000–90,000, project ids 202–208, and payments 50,000–100,000 in the e-commerce payment table, sorted by project name.

Design the webflix database using an er diagram, identifying entities and their relationships, including many-to-many bridgings, such as users, content, genres, plans, subscriptions, payments, invoices, seasons, episodes, and profiles.

Create the Weflex database from the WeflexDB.sql file in MySQL Workbench, drop existing, create, and use it, build tables like users, profiles, movies, series, seasons, and episodes for SQL practice.