> > > 20764

Administering a SQL Database Infrastructure (20764)

Course Description Kurs tarihleri Course Outline
 

Course Overview

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

This course replaces Administering Microsoft SQL Server 2014 Databases (20462) (without the Installation Part).

Kimler katılmalı

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

önkoşullar

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.

The required knowledge can be gained from the course Querying Data with Transact-SQL (20761).

Kurs hedefi

After completing this course, students will be able to:

  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • Restore SQL Server databases
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server using PowerShell
  • Trace access to SQL Server
  • Monitor a SQL Server infrastructure
  • Troubleshoot a SQL Server infrastructure
  • Import and export data

Follow On Courses

Kurs içeriği

  • SQL Server Security
  • Assigning Server and Database Roles
  • Authorizing Users to Access Resources
  • Protecting Data with Encryption and Auditing
  • Recovery Models and Backup Strategies
  • Backing Up SQL Server Databases
  • Restoring SQL Server 2016 Databases
  • Automating SQL Server Management
  • Configuring Security for SQL Server Agent
  • Monitoring SQL Server with Alerts and Notifications
  • Introduction to Managing SQL Server by using PowerShell
  • Tracing Access to SQL Server with Extended events
  • Monitoring SQL Server
  • Troubleshooting SQL Server
  • Importing and Exporting Data
Classroom training
Modality: C

Süre 5 Gün

Online training
Modality: L

Süre 5 Gün

 
Reservasyon için şehir adını tıklayın Kurs tarihleri
Türkiye

Currently no local training dates available.  For enquiries please write to info@fastlane.si.

Avrupa
Almanya
2019-08-12 - 2019-08-16 garanti rendavu Hamburg Enroll
2019-08-26 - 2019-08-30 Münster Enroll
2019-09-16 - 2019-09-20 Stuttgart Enroll
2019-10-07 - 2019-10-11 Berlin Enroll
2019-10-28 - 2019-11-01 Frankfurt Enroll
2019-11-25 - 2019-11-29 Münih Enroll
2019-12-09 - 2019-12-13 Hamburg Enroll
Isviçre
2019-09-16 - 2019-09-20 Zürich Enroll
2019-11-25 - 2019-11-29 Zürich Enroll
Italya
2019-08-26 - 2019-08-30 Milano Enroll
2019-09-30 - 2019-10-04 Roma Enroll
2019-11-11 - 2019-11-15 Milano Enroll
North America
Amerika Birleşik Devletleri
2019-08-19 - 2019-08-23 Online training saat dilimi: US/Central Kurs dili: Ingilizce Enroll
2019-09-23 - 2019-09-27 Online training saat dilimi: US/Central Kurs dili: Ingilizce Enroll
Latin America
Arjantin
2019-08-12 - 2019-08-16 Online training saat dilimi: America/Buenos_Aires Kurs dili: İspanyolca Enroll
Peru
2019-11-11 - 2019-11-15 Online training saat dilimi: America/Lima Kurs dili: İspanyolca Enroll
Orta Doğu
Birleşik Arap Emirlikleri
2019-08-18 - 2019-08-22 Dubai Kurs dili: Ingilizce This course is being delivered by iTLS. Enroll
2019-10-13 - 2019-10-17 Dubai Kurs dili: Ingilizce This course is being delivered by iTLS. Enroll
2019-12-15 - 2019-12-19 Dubai Kurs dili: Ingilizce This course is being delivered by iTLS. Enroll
Qatar
2019-08-18 - 2019-08-22 Doha Kurs dili: Ingilizce Enroll
2019-12-22 - 2019-12-26 Doha Kurs dili: Ingilizce Enroll
Afrika
Mısır
2019-08-18 - 2019-08-22 Kahire Kurs dili: Ingilizce Enroll
2019-10-13 - 2019-10-17 Kahire Kurs dili: Ingilizce Enroll
2019-12-15 - 2019-12-19 Kahire Kurs dili: Ingilizce Enroll
Fast Lane bütün garanti Kurs tarihlerini katılımcı sayısı her ne olursa olsun gerçekleştirmektedir. Mücbir sebepler veya diğer öngörülemeyen olaylar, kaza yada hastalık gibi durumlarda bir dersin uygulanması imkansız.
Instructor-led Online Training WebEx aracılığıyla VoIP ortamında gerçekleştirilir. Herhangi bir online kurslar hakkında sorularınız varsa, bize bu numaradan +49 (0)40 25334610 ulaşabilir veya e-mail ile info@flane.de iletişime geçebilirsiniz.
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!