آموزش SQL Server 2017 Administration

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

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

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

Design of Data Center

SQL Server Hardware & Software requirements

Installing SQL Server 2017

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

Introduction to In_Memory OLTP

Database Maintenance

Backup & Restore

File Group Backup and Restore

Partial Restore

Database Snapshots

Maintenance Plans

Security

Authentication

(Authorization(Permission

Dynamic Data Masking

Row Level Security

Always Encrypted

(Automating tasks (Jobs/Alerts

Replication

Replication Topologies

Transactional Replication

Merge Replication

Peer to Peer Replication

Backup & Restore strategy for Replicationp

Monitoring & Performance Tuning 

Hardware Monitoring

Software Monitoring

Wait Stats and Queue Analysis

Server & Database Auditing

Policy Based Management

Resource Governer

(High Availability(AlwaysOn