-
Module 1: Core concepts
17 Lessons-
StartModule introduction
-
StartWhat is SQL Server?
-
StartWhat is T-SQL?
-
StartTypes of SQL statements
-
StartLogins
-
StartUsers
-
StartSSMS
-
StartDocumentation
-
StartServer names and instances
-
StartDatabases
-
StartSchemas
-
StartTables
-
StartColumns
-
StartStored procedures
-
StartFunctions
-
StartModule 1 quiz
-
StartModule 1 lab
-
-
Module 2: Planning for SQL Server installation
14 Lessons-
StartModule introduction
-
StartDetermining required resources
-
StartPlanning for IO
-
StartPlanning for CPU
-
StartPlanning for memory
-
StartPlanning for networking
-
StartPlanning for service accounts
-
StartVirtualizing SQL Server
-
StartPre-installation testing
-
StartDownloading installation media
-
StartDownloading latest CU
-
StartDownloading Report Server
-
StartModule 2 quiz
-
StartModule 2 lab
-
-
Module 3: Installing SQL Server
20 Lessons-
StartModule introduction
-
StartInstallation resources
-
StartInstallation window order
-
StartEdition
-
StartLicense terms
-
StartGlobal rules and updates
-
StartInstall rules
-
StartInstallation type
-
StartAzure extension
-
StartFeature selection
-
StartInstance configuration
-
StartServer configuration
-
StartReporting services
-
StartPatching
-
StartPost-installation checks
-
StartUnattended installation
-
StartRenaming a server
-
StartChanging service accounts
-
StartModule 3 quiz
-
StartModule 3 lab
-
-
Module 4: Managing SQL Server databases
16 Lessons-
StartModule introduction
-
StartSystem databases
-
StartDatabase files
-
StartDatabase data
-
StartNumber of database files
-
StartSize of database files
-
Starttempdb
-
StartCreating a user database
-
StartConfiguring database options
-
StartFilegroups
-
StartMoving database files
-
StartMoving system databases
-
StartShrinking database files
-
StartModule 4 quiz
-
StartModule 4 lab
-
StartModule 4 lab solution
-
-
Module 5: Planning a backup and recovery strategy
14 Lessons-
StartModule introduction
-
StartData modification
-
StartTransaction log
-
StartFull recovery model
-
StartSimple recovery model
-
StartBulk logged recovery model
-
StartDefining RTO
-
StartDefining RPO
-
StartDefining 9s of availability
-
StartRecommended strategy
-
StartBackup testing and retention
-
StartModule 5 quiz
-
StartModule 5 lab
-
StartModule 5 lab solution
-
-
Module 6: SQL Server backup and recovery types
16 Lessons-
StartModule introduction
-
StartFull backup
-
StartDifferential backup
-
StartLog backup
-
StartPartial backup
-
StartCopy only backup
-
StartFile or filegroup backup
-
StartTail log backup
-
StartBackup media
-
StartRestore phases
-
StartRecovery types
-
StartStrategy example 1
-
StartStrategy example 2
-
StartStrategy example 3
-
StartStrategy example 4
-
StartModule 6 quiz
-
-
Module 7: Implementing a backup strategy
11 Lessons -
Module 8: Implementing a recovery strategy
13 Lessons-
StartModule introduction
-
StartViewing backup file contents
-
StartRestore a database
-
StartRestore transaction logs
-
StartWith standby
-
StartPoint in time recovery
-
StartStopping at marked transactions
-
StartPerform file or filegroup restore
-
Startmaster database restore
-
Startmodel database restore
-
StartRestoring other system databases
-
StartModule 8 quiz
-
StartModule 8 lab
-
-
Module 9: Managing users and roles
21 Lessons-
StartModule introduction
-
StartAuthentication vs Authorization
-
StartSQL Server authentication options
-
StartCreating Windows logins
-
StartCreating SQL Server logins
-
StartDatabase users from logins
-
StartContained database users
-
StartSpecial users
-
StartInpersonation vs Delegation
-
StartMismatched SIDs
-
StartServer level permissions
-
StartFixed server roles
-
Startpublic server role
-
StartUser-defined server roles
-
StartFixed database roles
-
StartUser-defined database roles
-
StartApplication roles
-
StartAdding role members
-
StartModule 9 quiz
-
StartModule 9 lab
-
StartModule 9 lab solution
-
-
Module 10: Managing server and database permissions
19 Lessons-
StartModule introduction
-
StartServer principals
-
StartDatabase principals
-
StartSecurables
-
StartAssigning permissions
-
StartGRANT option
-
StartTable and view permissions
-
StartColumn permissions
-
StartDefault schemas
-
StartResolving object names
-
StartSchema permissions
-
StartStored procedure permissions
-
StartOwnership chaining
-
StartFunction permissions
-
StartAssembly permissions
-
StartTesting permissions by impersonation
-
StartModule 10 quiz
-
StartModule 10 lab
-
StartModule 10 solution
-
-
Module 11: Auditing SQL Server Databases
15 Lessons-
StartModule introduction
-
StartSQL Server auditing prior to 2008
-
StartUsing triggers for auditing
-
StartUsing SQL Trace for auditing
-
StartC2 common criteria
-
StartSQL Server auditing from 2008
-
StartEnabling SQL Server audit
-
StartAudit destinations
-
StartServer audit specifications
-
StartDatabase audit specifications
-
StartReading audit output
-
StartAudits on failover servers
-
StartModule 11 quiz
-
StartModule 11 lab
-
StartModule 11 lab solution
-
-
Module 12: Table and index structures
18 Lessons-
StartModule introduction
-
StartFiles extents and pages
-
StartTable structure heap
-
StartTable structure clustered index
-
StartNon-clustered index over heap
-
StartNon-clustered index over clustered index
-
StartIndex column order
-
StartRID and clustered index lookups
-
StartCovering indexes
-
StartIncluded columns
-
StartFiltered non-clustered indexes
-
StartIndexed views
-
StartPrimary keys and indexes
-
StartUnique constraints and indexes
-
StartForeign keys and indexes
-
StartModule 12 quiz
-
StartModule 12 lab
-
StartModule 12 lab solution
-
-
Module 13: Table partitioning
15 Lessons-
StartModule introduction
-
StartTable partitioning overview
-
StartUsing partitioned views
-
StartUsing vertical partitioning of data
-
StartUsing partitioned tables
-
StartCreate partition function
-
StartCreate partition scheme
-
StartCreate partitioned table
-
StartBenefits of partitioning
-
StartSliding window designs
-
StartSWITCH data in and out
-
StartPartition alignment for indexes
-
StartModule 13 quiz
-
StartModule 13 lab
-
StartModule 13 lab solution
-
-
Module 14: Table compression and columnstores
19 Lessons-
StartModule introduction
-
StartLarge databases are costly
-
StartCompress data files?
-
StartTable compression
-
StartDeprecated vardecimal data type
-
StartPage compression
-
StartCreate with compression
-
StartRebuild with compression
-
StartIndex compression
-
StartEstimating space savings
-
StartSpace requirements
-
StartxVelocity compression
-
StartColumnstore indexes
-
StartRestrictions in 2012
-
StartEnhancements in 2014
-
StartEnhancements in 2016
-
StartModule 14 quiz
-
StartModule 14 lab
-
StartModule 14 lab solution
-
-
Module 15: Automating management with SQL Server Agent
15 Lessons-
StartModule introduction
-
StartAutomating administration
-
StartSQL Server Agent
-
StartSQL Server Agent core objects
-
StartCreating jobs
-
StartCreating job steps
-
StartScripting jobs
-
StartJob schedules
-
StartJob security
-
StartT-SQL job step permissions
-
StartNon-T-SQL job step permissions
-
StartCredentials and proxies
-
StartWorking with Powershell and DBA tools
-
StartModule 15 quiz
-
StartModule 15 lab
-
-
Module 17: Using Alerts and Notifications for Monitoring
10 Lessons -
Module 18: Automating routine database maintenance
12 Lessons-
StartModule introduction
-
StartDatabase integrity
-
StartDatabase page verification
-
StartLogical consistency checks
-
StartUseful DBCC options for Consistency
-
StartRepairing databases
-
StartIndexes and performance
-
StartIntentional internal fragmentation
-
StartAdjusting fragmentation
-
StartDatabase maintenance plans
-
StartModule 18 quiz
-
StartModule 18 lab
-
-
Module 19: Importing and exporting SQL Server data
10 Lessons -
Module 20: Governing resources
15 Lessons-
StartModule introduction
-
StartResource governor overview
-
StartAlternatives to resource governor
-
StartGoverned resources
-
StartWorkload groups
-
StartResource pools
-
StartInternal and default groups and pools
-
StartEffective max and shared percentages
-
StartClassifier functions
-
StartUseful DMVs
-
StartDynamic change effects
-
StartDetecting classifier failures
-
StartBest practices to follow
-
StartModule 20 quiz
-
StartModule 20 lab
-
-
Module 21: Introduction to advanced and related concepts
14 Lessons-
StartModule introduction
-
StartEncryption
-
StartTransparent database encryption
-
StartIn-memory OLTP and natively compiled procedures
-
StartFilestream and file tables
-
StartReplication
-
StartRow level security
-
StartData masking
-
StartHigh availability
-
StartArc enabling servers
-
StartTracing activity using SQL Trace and Extended Events
-
StartLinked servers
-
StartFull-text indexing
-
StartService Broker
-
