Administering Microsoft SQL Server Databases Eğitimi

Administering Microsoft SQL Server Databases Eğitimi Administering Microsoft SQL Server Databases Eğitimi
Sosyal Medyada Paylaş!
Eğitim Detayları
5 Gün (30 Saat)
Kapalı Sınıf
Kadıköy

Eğitim İçeriği

Ön Koşul: Transact-SQL çalışma bilgisi, İlişkisel DB çalışma bilgisi önerilmektedir

1. Introduction to SQL Server 2014 Database Administration

  • Database Administration Overview
  • Introduction to the SQL Server Platform
  • Database Management Tools and Techniques

2. Installing and Configuring SQL Server 2014

  • Plan SQL Server Installation
  • Install SQL Server 2014 and Post-Installation Configuration

3. Work with Databases and Storage

  • Introduction to Data Storage with SQL Server
  • Manage Storage for System Databases and User Databases
  • Move Database Files
  • Configure the Buffer Pool Extension

4. Plan and Implement a Backup Strategy

  • SQL Server Recovery Models
  • Plan a Backup Strategy
  • Backup Databases and Transaction Logs
  • Backup Options and Backup Reliability

5. Restore SQL Server 2014 Databases

  • Restore Process and Databases Restoration
  • Advanced Restore Scenarios
  • Point-in-Tim Recovery

6. Import and Export Data

  • Transferring Data
  • Import and Export Table Data
  • Copy or Move a Database

7. Monitor SQL Server 2014

  • Introduction to Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Performance Monitor

8. Tracing SQL Server Activity

  • Trace SQL Server Workload Activity and Use Traces

9. Manage SQL Server Security

  • Introduction to SQL Server Security
  • Manage Server-Level Security and Database-Level Principals
  • Manage Database Permissions

10. Audit Data Access and Encrypt Data

  • Audit Data Access in SQL Server
  • Implement SQL Server Audit
  • Encrypt Databases

11. Perform Ongoing Database Maintenance

  • Ensure Database Integrity
  • Maintain Indexes
  • Automate Routine Database Maintenance

12. Automate SQL Server 2014 Management

  • Implement and Manage SQL Server Agent Jobs
  • Manage Job Step Security Contexts
  • Manage Job on Multiple Servers

13. Monitor SQL Server 2014 Using Alerts and Notifications

  • Monitor SQL Server Errors
  • Configure Database Mail
  • Configure Operators, Alerts, and Notifications

KAYIT & ÖDEME

Bilgi ve Kayıt için lütfen form bilgilerini eksiksiz doldurun. En kısa zamanda size dönüş yapıp gerekli işlemlerle ilgili olarak bilgi verilecektir.

Ödeme Seçenekleri: EFT / Havale ile ödeme

Kayıt ve ödeme için bilgi iste

İlginizi Çekebilecek Diğer Eğitimler