Get an overview of how Microsoft SQL Server 2022 works, so that you can dig into its powerful capabilities.
Overview
Syllabus
Introduction
- Get to know SQL Server 2022
- What you should know
- What is SQL Server?
- Understand the editions of SQL Server
- Installing SQL Server
- Configure and start the server
- Log into the server
- Enable the system administrator (SA) account
- 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
- 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
- Next steps
Taught by
Adam Wilbert
