Course structure
Get to know MS SQL Server:
Overview of MS SQL Server components
Editions and their differences
Tools for working with MS SQL Server
Install, update, and upgrade:
Instances and reason for their use
Select an account to run services, Collation
Install Cumulative Update
Upgrade the database system version
Configure the database system
Manage databases:
Database file properties and recommendations
Filegroups and how to use them
System databases
Create and configure user databases
Database metadata:
Back up and restore databases
Backup/Restore Strategy Design, RTO vs. RPO
Database Recovery Model
Database backup types and levels, most used scenarios
Possibilities of database recovery, practical situation and their solutions
OVERVIEW OF THE ETL PROCESS:
Overview of basic tools and methods of the ETL process
Optimizing the performance of the ETL process
BULK INSERT, BCP, Import/Export wizard, Integration Services
Monitoring:
Overview of methods and tools for monitoring the database system
Practical demonstrations of the most important monitoring techniques
Security:
Understanding security concepts
Server and database level authentication and authorization
Examples of most used permissions, data masking, SQL Audit
Task automation and system maintenance:
Introducing SQL Server Agent
Database mail, automating tasks
Best practices for maintaining the database system
How to diagnose and troubleshoot problems:
Analysis of problems and permeable in solving them
Troubleshoot service start problems, connection errors, DAC
Appendix: Overview of high availability techniques
Theoretical familiarization with techniques leading to high availability
Appendix: Overview of advanced components
Overview of advanced database system components and how to use them
