Overview
-
Build on your knowledge of SQL Server 2016 by learning advanced concepts that help you design elegant database solutions for your organization.
Syllabus
-
Introduction
- Welcome
- Using the exercise files
- What you should know
- Translate business needs to structures
- Physical database design
- Leverage file groups
- Understanding RAID arrays
- Develop an indexing strategy
- Upgrade a SQL Server database
- Create additional SQL Server instances
- Backup and recovery strategies
- Database snapshots
- Backup encryption
- Restore tail-log backups
- Create a database schema
- Use schemas to enhance database security
- Data access and data layer architectures
- Linked server database models
- Automation strategies
- Create temp tables and table variables
- Store FILESTREAM and FileTable data
- Row and Page compression strategies
- Create table expressions
- Sort data with columnstore indexes
- Locking and concurrency strategy
- Create and manage transactions
- Transaction isolation strategy
- Create stored procedures
- Modify stored procedure parameters
- Error handling in stored procedures
- Introduction to SQL Server security
- Establishing user login roles
- Database and table permissions
- Object owner permissions
- Encrypting data
- Database server maintenance plans
- Verify integrity with console commands
- Repair fragmented indexes
- Database auditing strategies
- Investigate waits and deadlocks
- Introduction to activity monitoring
- SQL Server utility
- High-availability concepts and options
- Log shipping
- Leverage Always On Failover Cluster Instances
- Work with Always On Availability Groups
- Next steps
