Learning Microsoft SQL Server 2022

Course details

In this course, database expert Adam Wilbert introduces you to the newest version of SQL Server 2022 and SQL Server Management Studio. No prior SQL database experience is expected. Learn how to set up your own database server and begin creating databases for your valuable data. Adam explains Microsoft SQL Server 2022 as a relational database management system (RDBMS) and shows you how to get it installed and configured. He goes over working with the server, then gives you a tour of SQL Server Management Studio, including creating a new database, creating a data table, importing data from a file, and more. Adam guides you through writing several types of Transact SQL commands. Plus, he recommends additional courses to help you continue learning more about Microsoft SQL Server 2022.

Concepts

0. Introduction

01 - Get to know SQL Server 2022
02 - What you should know
03 - Explore the code challenge environment

1. Getting Started

04 - What is SQL Server
05 - Understand the editions of SQL Server
06 - Installing SQL Server

2. Working with the Server

07 - Configure and start the server
08 - Log into the server
09 - Enable the system administrator (SA) account

3. SQL Server Management Studio

10 - Tour the SSMS interface
11 - Install a sample database
12 - Create a new database on the server
13 - Understand SQL data types
14 - Create a data table
15 - Import data from a file

4. Write Transact-SQL Commands

16 - Create a SELECT statement
17 - Use functions to calculate values
18 - Join data from multiple tables
19 - Write an UPDATE statement
20 - Add data with an INSERT statement
21 - Create a view of the data
22 - Solution - Select data from a table
23 - Solution - Join related tables with a query
24 - Solution - Use functions to calculate values
25 - Solution - Update the data stored in a table

Conclusion

26 - Next steps