Overview
-
Get a quick introduction to SQL Server 2019. This course was designed to help brand-new users quickly get up and running with this professional-grade database management system.
Syllabus
-
Introduction
- Transform your powerful data with SQL Server 2019
- What you should know
- What is SQL Server?
- Understand the editions of SQL Server
- Install SQL Server
- Configure and start the server
- Log into the server
- Locate SQL Server documentation
- Tour the SSMS interface
- Install a sample database
- Create a new database on the server
- Understand SQL data types
- Create a data table
- Join tables together with keys
- Create a SELECT statement
- Use functions to calculate values
- Write an UPDATE statement
- Add data with an INSERT statement
- Create a view of the data
- Next steps
