آموزش SQL Server 2016 Administration

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

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

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

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