Learn SQL administration guides you to install SQL Server 2019 Developer edition directly on your desktop, set up SSMS and Adventureworks 2019, and adapt 2012 scripts to 2019.

Install SQL Server 2019, including Developer edition, SSMS, and Visual Studio 2019 Community Edition; follow step-by-step download, ISO setup, and prerequisites, and note changes from 2014 to 2019.

This video guides you through installing SQL Server 2019, installing SSMS, and restoring the AdventureWorks 2019 database, with tips on connecting to the right instance and navigating SSMS.

Install Visual Studio 2019 and set up SSRS and SSIS to create reports and packages in SQL Server 2019, including configuring the report server and its databases.

Learn to navigate the SQL Server 2019 course by skipping post addendum videos and proceeding to what is a database and a table, while practicing T-SQL with Adventureworks 2019.

Download and extract the Learn SQL docs and SQL scripts from the course zip, then access folders and the associated documents for each video.

Learn a practical, step-by-step path to becoming a production SQL database administrator with five courses on SQL basics, SQL server administration, SSRS, ETL, and high availability.

Compare SQL Server 2014 and 2017, demonstrate installing SQL Server 2017 on Linux via virtual machines, and reinforce core database administration principles applicable across versions.

Gather and download six essential applications for a production SQL Server administrator, including VirtualBox, SQL Server 2016, SSMS, AdventureWorks database, Visual Studio, and the Windows Server ISO.

Create a virtual machine with VirtualBox, install a Windows operating system from an ISO, and allocate memory and disk space for SQL Server 2017 and SSMS.

Install SQL Server 2017 in a virtual machine, set up a shared folder with the host, download the evaluation media, run setup, and use the front-end management GUI for administration.

Install sql server and SSMS, restart the virtual machine, connect to sql server via the SSMS interface, then restore the Adventureworks 2017 database for hands-on administration practice.

Compare SQL Server 2014 and 2017, showing that database administration principles apply across versions and that AdventureWorks references may require 2017 updates to avoid errors.

Download the Adventureworks 2012 data file, attach it to the SQL Express server, and move the MDF to the SQL data folder while resolving the log file.

Define the database as a container of objects and a table as columns and rows, and explain how relational databases use joins for crud and security.

Learn how the select statement retrieves data from single or multiple tables, using the asterisk or specific columns, and discover calculated and concatenated fields, distinct values, and top clauses.

Learn to use the where clause to filter rows, minimize the result set by selecting specific columns, and apply and/or with parentheses, including fully qualified names and proper quotes.

Explore the like operator in a where clause to filter sql server data by patterns. Learn how starts with, ends with, contains, and not like using percent and bracket syntax.

Sort data with the order by clause to arrange results in ascending or descending order. Use multiple columns, such as first name and last name, to refine the order.

Explore the insert into command in SQL, inserting single or multiple rows with or without column lists, handling null values, and matching data types in SQL Server using SSMS.

Learn how to safely use the update statement in T-SQL to modify specific columns with a where clause, including updating multiple columns and using expressions.

Master the delete command to remove records safely with a where clause, backed by a backup copy, and compare it with truncate, which frees space and cannot be filtered.

Learn how the in operator filters first names by listing multiple values in the where clause, delivering efficient results on large datasets in T-SQL.

Learn to use the between operator in where clauses to filter date, text, and numeric ranges, including not between and not in, with practical AdventureWorks examples.

discover how to create a database in SQL Server with the create database command, and compare model defaults to custom production configurations, including MDF and LDF file sizes.

Create a table in SQL Server by defining columns and data types, including sizes, applying not null and primary key constraints, using identity for auto incremented IDs, then insert data.

Learn to create local and global temp tables in SQL Server, including their scope, naming with hashes, and behavior on session disconnect or service restart.

Explore how constraints in T-SQL enforce data rules, including not null, default, and unique, and learn to create or alter tables to apply them and prevent violations.

Explore primary keys, foreign keys, and check constraints in t-sql, including unique, not null, auto increment, and data integrity practices for table design.

Learn to combine data from two or more tables using inner, left outer, right outer, and full outer joins in T-SQL, guided by primary and foreign key relationships.

Learn union, intersect, and except to combine two tables, enforce matching column counts and types, and return distinct results by default, with order by applied in the last select statement.

Learn how to use aggregates in SQL, including sum, average, min, max, and count, with group by and where clauses, plus practical examples on books and sales data.

Learn how the group by clause aggregates identical rows into named groups and how the having clause filters those groups after grouping, using sums and counts.

Explore how to use the alter statement in T-SQL to modify existing tables—adding, changing, or dropping columns and constraints—demonstrated on an employee table with an age check constraint.

Discover how null values represent unknown data in SQL Server, and use is null, is not null, and update or alter to manage blanks in tables.

Learn to use the is null command in T-SQL to replace null values with a value, with examples replacing address line two with unknown and titles or suffix with blanks.

Use the select into command to copy entire or partial data from one table to another, creating a destination table named with today's date, using where clauses and inner joins.

Explore subqueries by nesting a select inside another statement, where inner query executes first and outer query filters with the where clause, using insert, update, or delete as needed.

Explore data types and how they enforce data integrity in SQL Server, covering int, decimal, varchar, char, date, datetime, and large data types with practical examples.

Explore how cast and convert change data types in SQL Server, enabling calculated fields in reports and queries.

Explore key T-SQL string functions, including length, left trim, right trim, concat, substring, replace, and case conversions, with practical examples of trimming spaces and formatting names.

Explore numeric and date functions in T-SQL, including round, is numeric, getdate, dateadd, datediff, datename, and datepart, with practical examples on the AdventureWorks 2012 salesperson table.

Create views as virtual tables from a dynamic select query to restrict columns, hide complex joins, and propagate updates between base tables and views.

Master the case statement as a conditional tool in t-sql, using simple and searched cases. Create alias columns to present results without updating data, with rating, time, and grades examples.

Explore how indexes speed data retrieval, including clustered, non-clustered, composite and unique indexes, with practical syntax examples and implications for SQL Server performance.

Explore how triggers fire on insert, delete, and update to enforce data integrity in SQL Server, using after and instead of triggers with the inserted and deleted conceptual tables.

Learn to use the design query editor to build T-SQL queries with inner joins on product, product category, and product subcategory, generating SQL and applying filters, group by, and having.

Explore ranking functions in T-SQL, including row_number, rank, and dense_rank, and learn to partition data using the over clause and order by to rank within groups.

Learn to administer SQL Server in production environments. Install SQL Server, configure domain and virtual machines, manage data and logs, and implement backups in part one of a three-course series.

Receive a guided, step-by-step roadmap to becoming a SQL DBA, with a recommended course sequence from Learn T-SQL from Scratch to advanced SQL administration, plus links and downloads.