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
()