Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Learning Microsoft SQL Server 2016


Introduction
Welcome
What you should know

1. Get Started
What is SQL Server?
Understand the editions of SQL Server
Install SQL Server

2. Work with the Server
Configure and start the server
Log in to 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