Sale

Administering Microsoft SQL Server Databases (MS-20462)

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database.
    • Learning Style
      Virtual Instructor-Led
    • Difficulty
      Intermediate
    • Course Duration
      5 Days
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database.
Purchase As Subscription
Start Your 7-Day FREE Trial with our Master subscription plan that gives you access to this course PLUS:

  • 640+ high impact technical, end user and learning & business management courses
  • Includes courses in multi-modality - 100% online self-paced + Virtual Instructor Led courses
  • Course completion certificates
  • Live instructor Coach, tech support and you will be assigned your personal Learning Concierge
  • $166.5/Month
    Billed As One Annual Payment of
    $1,998.00
    Every Year Until Canceled
  • Subscribe Now
Purchase As Individual Course
  • Live Online Instructor Led Delivery
  • Attend from Home or Office
  • Guaranteed to Run Schedules
  • Virtual Hands-On Labs

  • Now Only $2,095.00 Regular Price $2,995.00
    Virtual Instructor-Led
  • Enroll Now
Purchase For Teams
Team Pricing Available - Request A Quote Today!

  • Group Discounts & Private Training Available
  • Free Learning Management Center
  • Group Reporting & Tracking
  • Author / Publish Your Own Courses
  • Request Team Enrollment

The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.


Course Objectives

  • Plan and install SQL Server.
  • Describe system databases, the physical structure of databases, and the most common configuration options related to them.
  • Explain the concept of the transaction log and the SQL Server recovery models and implement different backup strategies that are available with SQL Server.
  • Back up SQL Server databases.
  • Restore SQL Server databases.
  • Import and export data by using wizards, the bulk copy utility, and data-tier applications.
  • Work with SQL Server security models, logins, users, and contained databases.
  • Work with server roles and database roles.
  • Use permissions to secure resources.
  • Use SQL Server audit and Transparent Data Encryption.
  • Work with SQL Server Agent to configure and execute jobs.
  • Implement SQL Server Agent security, proxy accounts, and credentials.
  • Configure database mail, alerts, and notifications.
  • Create database maintenance plans.
  • Use SQL Server Profiler, SQL Trace, and Distributed Relay.
  • Use Distributed Management Views and configure data collection


Audience

  • 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 audience for this course is individuals who develop applications that deliver content from SQL Server databases.


Prerequisites

  • 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:
  • 20461C: Querying Microsoft SQL Server 2014
More Information
Brand Microsoft
Lab Access No
Technology Microsoft
Learning Style Virtual Instructor-Led
Difficulty Intermediate
Course Duration 5 Days
Language English
SATV Value 5 Days
VPA Eligible VPA Eligible
Write Your Own Review
You're reviewing:Administering Microsoft SQL Server Databases (MS-20462)
Your Rating