Course OD20764B: Administering a SQL Database Infrastructure (90 Day)

There is a new revision coming soon.

Choose how you want to learn: online or in a classroom
Compare learning environments

On-demand training

Learn more

Classroom training

Learn more

Find a Microsoft Learning PartnerFind an on-demand training partnerFind a classroom training partner
Anytime accessYesNo
Anywhere access to recorded instructorYesNo
Microsoft official training contentYesYes
In-depth trainingYesYes
Hands-on labs Yes Yes
SATV redemption Yes Yes
Ask instructor questions in personNoYes
Attend live class in personNoYes
Attend live class remotelyNoYes
Time commitment Self-paced
(3 month access)
5 days
À propos de ce cours
Public(s) :IT Professionals
Technologie :SQL Server
Niveau :Advanced
Cette révision :B
Modalités d'examen :
Classroom
Durée :2 days
Langue(s) :English

Première publication :

18 May 2017
Présentation
À propos de ce cours This 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. Profil du participant

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. À la fin du cours

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

Détails du cours
Course Outline
Conditions préalables

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.

Communauté

Vous recherchez des ressources de formation, des événements et des conseils d'homologues ? Rejoignez la communauté de formation et de certification Microsoft.

Vous vous préparez à un examen ? Trouvez votre groupe d'étude de certification Microsoft.

Parlez-nous sur les réseaux sociaux :