The administrator's tasks and the means provided to him or her.

• General architecture of SQL Server.
• Installation, migration.
• Configuration tools. SQL Server Configuration Manager.
• Service and network management tools.
• Overview of client tools.
• System databases and objects.
• Hands-on work
• Installing SQL Server. Use of dynamic consultation tools. Configuration using Policy Based Management (PBM).

Object allocation.

• Partitioning tables and indexes. Partitioning function. Partitioning scheme.
• Computed columns.
• Managing the size and growth of databases.
• Database snapshots. Snapshot tasks.
• Inserting and importing data. Main BULK INSERT or BCP options.
• Hands-on work
• Creating a database. File management. Creating snapshots.
• Security and encryption.

Authentication modes. Name resolution.

• Roles: Server roles, fixed roles of databases, user-created roles, application roles.
• Assigning privileges (Grant, Revoke, Deny, etc.). Ownership chaining.
• Contained Databases.
• Runtime context.
• Data encryption (symmetrical, asymmetrical). Encryption architecture.
• Database primary key. Backing up and restoring keys. Extensible Key Management.
• SQL Server certificates, example of use.
• Encryption metadata.
• Transparent Data Encryption.
• Database auditing, syntax for creating events to audit.
• Hands-on work
• Working with permissions and access controls. Certificate management.

Organizing work: Categories of work, types of steps, rules of precedence and errors, notifications.

• Scheduling work, specific MSDB roles. Execution log, monitor.
• Configuring the SQL agent. Alert and notification configuration. Operator management.
• Sending emails from SQL Server: Configuring the settings of Database Mail, or of the Agent for sendign emails.
• Multiserver work configuration. Event redirection.
• DDL triggers. SQL Server events: Performance, WMI, WQL.
• Verification of physical integrity. Recovering low-level information on the SQL Server engine (DBCC).
• Reminders about index structure and maintaining indexes. Indexed views. Full-text index.
• Recompute statistics.
• Maintenance plan tool. Using SQL Server Data Tools.
• Hands-on work
• Automating and scheduling administrative work.

Recovery models (full, basic, block, etc.) and how they influence data recovery.

• Setting up a backup strategy.
• Backup security.
• T-SQL backups: Integrity. Multifile, multifamily backups.
• Scheduling backups.
• Restoring databases, repairing damaged environments.
• Restoring logs.
• Restoring to a different database.
• Page recovery.
• System database backups. Restoring the master.
• Hands-on work

The profiler and eXtended Events (XEvents) for tracking usage.

• Extended events.
• DDL triggers for tracking structure modifications.
• Metadata views and dynamic management views. Stored metadata procedure.
• The Windows performance monitor. User counters and events. Database Tuning Advisor.
• Viewing locks and blockages, detecting and handling deadlocks.
• Configuring the server and the databases. Resource governor.