Learning Microsoft SQL Server 2016

Never touched a database before? Get a quick introduction to SQL Server 2016. Start creating tables and manipulating data in less than 90 minutes.

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