سرفصل ها و محتوای دوره آموزش Administration of SQL Server 2016 

 پیش نیاز: آشنایی با بانک های اطلاعاتی

سرفصل های دوره:

Design of a Data Center

SQL Server Hardware & Software requirements

Installing SQL Server 2016

Network Configuration

SQL Server Management Technologies

System Databases

Introduction to Schemas & Tables

Database Physical Design

Data Files & File groups      

Transaction Log File & Recovery Models      

Data Compression      

Data & Index Partitioning      

Database Maintenance

Backup & Restore

Database Snapshots

Maintenance Plan

Security

Authentication

(Authorization (Permissions

(Automating tasks ( Jobs /Alerts

Replication

Replication Topologies

Transactional Replication

Merge Replication

Peer to Peer Replication

Backup & Restore strategy for Replication

Monitoring and Performance Tuning

Hardware Monitoring

Software Montoring

Server and Database Auditing

Policy Based Management

Resource Governor

(High Availability (AlwaysOn