MENU
Úvod
Kurzy
Administering Microsoft® SQL Server® 2012 Databases
Archiv záujem o kurz

Administering Microsoft® SQL Server® 2012 Databases (MOC10775)

This 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. Some of the exercises in this course are azure enabled. That means you can perform those labs on azure or on a local computer just like you have always done. Please see the syllabus for details on the azure labs. This course maps to the skills and knowledge measured by Microsoft Exam 70-462, and in conjunction with on-the-job experience, can help prepare you for the exam.

Kurz je zaradený v kategórii: DatabázeMicrosoft SQLMS SQL
Microsoft

Náročnosť kurzu: pokročilý

Délka kurzu: 5 dní

Náplň kurzu:

  • Introduction to SQL Server® 2012 and Its Toolset
  • Preparing Systems for SQL Server 2012
  • Installing and Configuring SQL Server 2012
  • Working with Databases
  • Understanding SQL Server 2012 Recovery Models
  • Backup of SQL Server 2012 Databases
  • Restoring SQL Server 2012 Databases
  • Importing and Exporting Data
  • Authenticating and Authorizing Users
  • Assigning Server and Database Roles
  • Authorizing Users to Access Resources
  • Auditing SQL Server Environments
  • Automating SQL Server 2012 Management
  • Configuring Security for SQL Server Agent
  • Monitoring SQL Server 2012 with Alerts and Notifications
  • Performing Ongoing Database Maintenance
  • Tracing Access to SQL Server 2012
  • Monitoring SQL Server 2012
  • Managing Multiple Servers
  • Troubleshooting Common SQL Server 2012 Administrative Issues

Predpokladané znalosti: 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.

.

Termíny kurzu:

Tento kurz už nie je v našej ponuke. Pre viac informácií alebo ak máte záujem o realizáciu nás kontaktujte na skoleni@pcdir.cz alebo telefónu +420 543 533 610.