SQL for Beginners: A Fast Practical Crash Course

Explore how a database organizes data as a structured, searchable system that ensures integrity and scalable access. Compare with spreadsheets and file systems for relationships and complex queries.

Explore how a database structures data with tables, columns, rows, primary keys, and foreign keys, and learn how normalization reduces redundancy and strengthens relationships to organize information efficiently.

Learn SQL, the declarative standard for working with relational databases. Explore DML and DDL commands, including SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, ALTER TABLE, and DROP TABLE.

Download and install SQL Server Express and SSMS, create a Northwind database, run the instnwnd.sql script, and verify all tables are created.

Master the select statement as the core tool for retrieving data, choosing columns from a table, using star for quick views, and ending queries with a semicolon.

Filter data with the where clause to keep only rows that meet a condition, using equals, greater than, less than, and not equal operators.

Master using and, or, and not in SQL to build precise filters in the where clause. Learn how to combine conditions with parentheses to control evaluation order.

Master the like operator to perform pattern matching in SQL using % and _ wildcards and bracket sets to filter results, such as names starting with Joe or containing son.

Null represents missing data in SQL and is not the same as zero or empty string; aggregates ignore nulls, while isNull replaces null and nullif produces null under a condition.

Learn to use the order by clause to sort query results in ascending or descending order. Sort by multiple columns, such as city asc then last name desc.

Learn how inner join merges data from categories and products on a related column using the on keyword, returning only matching rows, with aliases simplifying queries.

Explore outer joins in SQL, including left joins that return all left rows with nulls for unmatched right rows and right joins that do the reverse, with employees and departments.

Explore aggregate functions that summarize data across many rows to calculate totals, averages, and extremes. Learn how count, sum, avg, min, and max support reporting and decision-making with practical examples.

Master the group by clause to summarize data by categories using aggregate functions like count, sum, and avg. Group by one or more columns and apply having to filter groups.

Explore SQL set operations: union, union all, intersect, and except. Use union for unique results, union all for duplicates, intersect for common rows, and except for differences.

Use subqueries to embed one query inside another and filter results by aggregates in the where clause. Add dynamic per-row values in the select clause with correlated subqueries and aliases.

Explore correlated subqueries, which depend on the outer query and are evaluated once per row for row-by-row comparisons, referencing outer columns to compute the average salary for the employee's department.

Master advanced join techniques, including cross apply and outer apply for table-valued functions, comparisons within the same table, optional relationships, and self-joins for hierarchical data like employees and managers.

We introduce common table expressions (CTEs) and show how the with clause defines a result set you can reference in select, insert, update, or delete; use recursion for hierarchical data.

Learn how analytic functions compute values across related rows, returning every row, using over, partition by, and order by for running totals, ranking, and row comparisons with lag and lead.

Learn the core DML commands in SQL Server: insert, update, and delete, including syntax, where clauses, and tips for safe data modification and rollback.

Explore SQL views as virtual tables that do not store data, simplify queries, restrict access, and present up-to-date data from base tables like employees and departments.

Discover how SQL triggers automate actions on specific tables or views to enforce rules, preserve data integrity, track data changes, and respond to defined events.

Learn to create SQL Server Agent jobs using SSMS or T-SQL, defining steps, schedules, and attaching schedules in MSDB, and verify behavior in development before production.

Discover how database indexes speed data retrieval by enabling quick lookups on indexed columns, avoiding full table scans; create IX_MYINDEX on employees (first name, last name) to accelerate queries.

Learn stored procedures in SQL Server as reusable saved code that improves performance and security by limiting direct table access. Create and run them with exec and pass parameters.

Explore stored procedure structure with input and output parameters, default dates, and joins that return customer orders and totals; use exec to capture outputs and apply try-catch with a transaction.

Explore best practices for advanced stored procedures in SQL Server, emphasizing performance, security, and maintainability.

Master core SQL syntax elements for stored procedures and functions by learning declare, assign defaults, temp tables, begin and end blocks, print, while loops, and if statements.

Explore advanced control flow in sql stored procedures, including loops, if statements, try-catch, and transactions, with meaningful variable names, comments, and print debugging while classifying counters as even or odd.

Explore how SQL cursors process data one row at a time, enabling complex row-by-row calculations and per-row error handling when set-based queries fall short.

Manage transactions to ensure all actions succeed or fail together, using begin, commit, and rollback to protect data integrity, with try/catch handling errors gracefully in a bank transfer scenario.

Explore SQL control flow concepts, including print statements for debugging, the if statement for conditional branches, while loops that print iterations, and SELECT INTO for storing query results in variables.

Learn how stored functions provide reusable scalar or table-valued routines for consistent calculations and validations inside select, where, or order by, while restricting temp tables, transactions, and data modification.

Learn how SQL Server authentication protects databases by comparing Windows authentication, SQL Server authentication, and mixed mode, and how principles, roles, and permissions control access and keep data secure.

Explore SQL Server authentication methods, comparing Windows authentication—relying on Windows identities for stronger security and easier management—with SQL Server authentication, which uses server-managed logins and passwords and enforces password policies.

Learn how roles and groups centralize security in sql server, covering server-level and database roles, built-in and custom roles, schema-based permissions, and least-privilege practices.

Organize permissions with server roles at the SQL Server instance level and database roles within each database, including application roles, to maintain consistent, hierarchical security across logins, users, and applications.

Explore built-in database roles to simplify permission management and secure access. Learn key roles such as DB Owner and DB Data Reader and apply the minimum role principle.

Explore how database backups protect data by choosing the right recovery model: simple, full, or bulk logged, based on data loss tolerance and maintenance needs.

Select the right backup method to balance storage, performance, rapid recovery, and off-site storage. Learn full, differential, and transaction log backups, plus recovery mode options for point-in-time restoration.

Back up system databases regularly to protect the SQL Server environment, including master after config changes and point-in-time backups, MSDB jobs, and model if modified, while tempdb requires no backups.

Explore sql server restoration options, including point-in-time recovery with full and log backups. Restore to the same or a different database, or recover from backup devices or an existing source.

Automate routine database maintenance with SQL Server maintenance plans via a visual interface, scheduling full, differential, and transaction log backups, integrity checks, indexes and statistics maintenance, and notifications.