Learn about SQL Server 2016. Find out how to build new databases, tables, and queries; back up and restore SQL Server; and integrate with cloud services like Microsoft Azure.
Overview
Syllabus
Introduction
- Welcome
- What you should know before starting
- Using the exercise files
- Understanding core concepts of SQL Server 2016
- SQL Server editions
- Basic installation
- Advanced installation options
- Install SQL Management Studio
- Using SQL Server Configuration Manager
- Basics SQL Server Management Studio
- More about SQL Server Management Studio
- Activity Monitor
- Profiler
- Create a database
- Advanced database configuration options
- Install a sample database
- Create a table using Management Studio
- Understanding data column options
- Create a table using T-SQL
- Create relationships between tables
- In-memory tables
- Temporal tables
- Create a view
- Understanding the advanced options of views
- Stored procedures
- Parameterized stored procedures
- Built-in functions
- Scalar functions
- Introduction to XML
- Write queries to return XML
- Shred XML
- Working with XML schemas
- Storing XML
- Working with JSON
- Converting JSON to tabular data
- Storing JSON
- Overview of backup and restore in SQL Server
- Basic backups
- Basic restore
- Create maintenance plans to automate backups
- Add a cleanup task to a maintenance plan
- Review logs in SQL Server 2016
- Audit logins
- Understanding dynamic management views
- Using database console commands (DBCC)
- Overview of high availability in SQL Server 2016
- Overview of authentication in SQL Server
- Instance-level logins
- Database-level users
- Encrypt data
- Dynamic masking
- Basics of indexes
- Create an index
- Columnstore index
- Explore execution plans
- Overview of Query Store
- Back up to Azure
- Set up Stretch Database
- Monitor Stretch Database
- Next steps
Taught by
Martin Guidry
