Overview
-
Never touched a database before? Get a quick introduction to SQL Server 2016. Start creating tables and manipulating data in less than 90 minutes.
Syllabus
-
Introduction
- Welcome
- What you should know
- What is SQL Server?
- Understand the editions of SQL Server
- Install SQL Server
- Configure and start the server
- Log in to 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
