Learning Microsoft SQL Server 2022

Get an overview of how Microsoft SQL Server 2022 works, so that you can dig into its powerful capabilities.

Introduction

• Get to know SQL Server 2022
• What you should know

1. Getting Started

• What is SQL Server?
• Understand the editions of SQL Server
• Installing SQL Server

2. Working with the Server

• Configure and start the server
• Log into the server
• Enable the system administrator (SA) account

3. SQL Server Management Studio

• Tour the SSMS interface
• Install a sample database
• Create a new database on the server
• Understand SQL data types
• Create a data table
• Import data from a file

4. Write Transact-SQL Commands

• Create a SELECT statement
• Use functions to calculate values
• Join data from multiple tables
• Write an UPDATE statement
• Add data with an INSERT statement
• Create a view of the data

Conclusion

• Next steps