MS10775-Administering Microsoft SQL Server 2012 Databases

Msp Libra
A Bologna

1.650 
+IVA
Vuoi parlare del corso con un consulente?
Confronta questo corso con altri simili
Leggi tutto

Informazione importanti

  • Corso intensivo
  • Livello avanzato
  • Bologna
  • 45 ore di lezione
  • Durata:
    5 Giorni
Descrizione

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. Also this course helps you prepare for the Exam 70-462.The Beta version of this course (10775AB) utilizes pre-release software in the virtual machine for the labs. Microsoft SQL Server 2012 Release Candidate 0 (RC0) is used in this course. Some of the exercises in this course are SQL Azure enabled.

Informazione importanti
Sedi

Dove e quando

Inizio Luogo
Consultare
Bologna
Bologna, Italia
Visualizza mappa

Domande più frequenti

· Requisiti

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. • Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills: • 10774A: Writing T-SQL Queries for Microsoft SQL Server 2012

Cosa impari in questo corso?

SQL
SQL SERVER 2012
Administering SQL SERVER 2012

Programma

After completing this course, students will be able to:

· Plan and install SQL Server.

· Describes the system databases, the physical structure of databases and the most common configuration options related to them.

· Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.

· Create SQL Server Backups.

· Restore SQL Server databases.

· Use the import/export wizards and explain how they relate to SSIS.

· Work with SQL Server security models, logins and users.

· Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.

· Work with permissions and the assignment of permissions.

· Work with SQL Server Audit.

· Work with SQL Server Agent, jobs and job history.

· Implement SQL Server agent security, proxy accounts and credentials.

· Configure database mail, alerts and notifications.

· Create database maintenance plans.

· Work with SQL Profiler and SQL Trace stored procedures.

· Introduce DMVs and the configuration of data collection.

· Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.

· Troubleshoot SQL Server databases.


Confronta questo corso con altri simili
Leggi tutto