SQL Server Database Administration and Operations - Basic Course

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.

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.