Overview
-
Get started with SQL Server 2017. Explore the most important features of SQL Server, and learn how the server operates, how to create tables and manipulate data, and more.
Syllabus
-
Introduction
- Welcome
- What you should know
- What is SQL Server?
- Understand the editions of SQL Server
- Installing 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
