Learning Microsoft SQL Server 2019

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.

Introduction

• Transform your powerful data with SQL Server 2019
• What you should know

1. Get Started with SQL Server

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

2. Work with the Server

• Configure and start the server
• Log into the server
• Locate SQL Server documentation

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
• Join tables together with keys

4. Write Transact-SQL Commands

• 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

Conclusion

• Next steps