The Complete SQL Bootcamp : From Basics to Advanced

Learn sql server database architecture, from installation and ssms connection to data and log files. Master ddl, dml, dql, and dcl commands in t-sql, including transactions.

Explore sql server architecture and the five sql sublanguages, focusing on ddl and dml basics, practice insert update delete and select, and learn truncate and transaction controls.

Explore importing large CSV data into SQL Server using the Import Flat File wizard, then learn SQL data types—from int variants to VARCHAR and DATE—plus storage and truncation notes.

Explore how constraints shape SQL tables, including not null, unique, primary key, check, default, and foreign key, with practical examples on data types, nulls, and index.

Explore the SQL command structure from select to order by, including where, group by and having, with practical examples of filtering, distinct, and aggregation.

Master SQL operators and the difference between where and having to filter aggregated data, build queries with group by, and use in, between, and like effectively.

Master the SQL order of operation by tracing how from, where, group by, having, and select execute, including aggregation, aliasing, and top/limit examples using the Superstore data.

Master SQL case statements to build logic with when/then and end, create new computed columns, and apply case inside aggregates for profit, discounts, and region groupings.

Learn to pivot data with case statements, creating conditional region columns and totals, swap values like ship mode and class, and summarize category sales across regions.

Learn aggregate and string sql functions as sum, min, max, count, average, left, right, len, index, substring, trim, upper, lower, replace, and string split; understand table-valued and scalar-valued functions.

Master sql date and time functions for time series analysis, including dateadd, datediff, datepart, datename, getdate, current timestamp, and cast or convert.

Define inputs, the operation, and the output to build user defined functions in SQL; create scalar functions like square and cube, and inline or statement-based table valued functions returning tables.

Learn how to combine two tables with joins in SQL, including inner, left, right, and full joins, plus aliasing and matching on related columns.

Master SQL joins by exploring inner, left, right, and full joins, plus cross and self joins; learn how foreign keys bridge customers, orders, products, and order details.

Learn how to perform a self join in SQL by joining a table to itself using aliases, to reveal employee-manager relationships and compute salary comparisons.

Master union, union all, intersect, and except to combine two select queries with the same table structure; enforce data type, column order, column names, and the number of columns.

Explore sub queries in SQL, including inner and outer, non-correlated and correlated, with single-row and multi-row outputs, and practical examples like filtering by average salary and finding second highest.

Explore common table expressions (CTEs) in SQL. Save temporary results using the with clause to improve readability and replace subqueries, including salary and department examples and recursive CTE notes.

Master SQL window functions: understand row-by-row calculations with over, partition by, and order by to compute running totals, subject-wise totals, and rankings.

Learn practical SQL window functions: aggregate windows, over and partition by, to compute totals, running totals, region averages, and rankings using rank, dense_rank, and row_number.

Explore SQL window functions, focusing on lead and lag, using a daily temperature table to compute previous and next day values, differences, and trend classifications.

Learn how views in SQL create virtual tables from existing data to optimize queries, improve readability, and reuse results across queries, including simple, complex, and materialized views.

Learn how stored procedures save pre-compiled blocks of SQL, accept input parameters, and automate tasks, business logics, and batch operations, contrasting them with views and functions.

Explore triggers in SQL, a special kind of stored procedure that auto executes on events like insert, update, delete, and logon to enforce rules and audit activity.

Master SQL performance in this lecture by analyzing execution plans to reduce cost, using clustered and non-clustered indexes, avoiding select star, optimizing where clauses, and writing efficient joins.