MOC on DEMAND 20462: Administering Microsoft SQL Server Databases

Description

During this five-day course, students are provided with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Those that may be interested in this course are: IT professionals who administer and maintain SQL Server databases, 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. Professionals who develop applications that deliver content from SQL Server databases

Upon completion of his course, students will be able to:

  • Describe core database administration tasks and tools
  • Install and configure SQL Server 2014
  • Configure SQL Server databases and storage
  • Plan and implement a backup strategy
  • Restore databases from backups
  • Import and export data
  • Monitor SQL Server
  • Trace SQL Server activity
  • Manage SQL Server security
  • Audit data access and encrypt data
  • Perform ongoing database maintenance
  • Automate SQL Server maintenance with SQL Server Agent Jobs
  • Configure Database Mail, alerts and notifications
     

Prerequisites

It is recommended that the student have the following:

  • 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 interested in this course can meet the prerequisites for this course by gaining the knowledge in 20461: Querying Microsoft SQL Server ****

Contact Us

THE ACADEMY

1.800.482.3172

FTL: 954.351.7040

MIA: 305.648.2000


Request More Information

 

Current Promotions!

 

  _____________________________________

 

 

 

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Sign up for our Email Newsletter!

          

 

Students - Orbund Log-In

 

 

 

 

 

Top
  • Follow us on
  • Facebook Academy Page
  • Twitter Academy Page