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.
Overview
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
Taught by
Adam Wilbert
Related Courses
-
Microsoft SQL Server Development for Everyone
-
70-461, 761: Querying Microsoft SQL Server with Transact-SQL
-
Microsoft SQL Server 2017: Linux, Docker and macOS Hands-On
-
SQL Server: Automatic Tuning in SQL Server 2017 and Azure SQL Database
-
70-461 Sessions 1 and 2: Querying Microsoft SQL Server
-
Microsoft SQL for beginners : ( MS-SQL Server,T-SQL, SSMS )
