SQL Server database administration and operation

The course is designed for operators, system administrators, database administrators, database designers who will be responsible for configuring, operating, managing, backing up, restoring, maintaining and supporting SQL Server 2016 systems.

• SQL Server 2016 overview: architecture, building blocks, features, operator tasks and tools.
• Database, instance and database file management: data structures, database design and creation, database management, SQL Server 2016 instance management.
• Managing security: SQL Server security architecture; implementing security at database, server and schema levels; managing users and privileges; designing server and database roles; database access control; auditing solutions; using authentication certificates; using data encryption.
• Using policy-based management: creating policies, monitoring and managing file group usage.
• SQL Server 2016 database backup and restore: developing a backup and restore strategy, backing up and restoring user databases, compressed backup, online restore operations, using database snapshots, restoring system databases, backing up to Azure Windows Blob Store, using advanced backup and restore options.
• Automate administrative tasks using SQL Agent: configuration, defining jobs and operations, alerts, managing multiple servers, managing SQL Server Agent security.
• Manage SQL Server alerts and notifications: monitor SQL Server errors; configure database mailing; configure operators, alerts and sales; manage alerts in Azure SQL database.
• Introduction to Powershell: Configuring and administering SQL Server using PowerShell.
• Monitoring SQL Server, tracing data accesses: using diagnostic tools (System Monitor, SQL Profiler, SQL Trace, SQL Server Utility, Distributed Replay).
• SQL Server maintenance: troubleshooting methods, common problems, handling connectivity issues, using Database Engine Tuning Advisor, Resource Governor and Data Collector to improve performance, managing transactions and locks, handling data access issues, analyzing and troubleshooting basic performance issues, configuring alerts.
• Data migration, data transfer, importing, exporting, transforming data; basic use of SQL Server 2016 Integration Services (SSIS), using BCP and BULK INSERT to import data, using DACs to export and import data.

Basic knowledge of Windows Server 2012 or 2016, relational database management and SQL query basics. Completion of or knowledge of course 20461 or 20761 is recommended. As the course materials are in English, a basic level of English at document reading level is required. The lecture will be given in Hungarian.