Administering Microsoft SQL Server Databases - MOC20462

52 Bewertungen

Beschreibung

This five-day instructor-led course provides students 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.

error_outline Wichtige Information

Dieses Seminar behandelt prüfungsrelevante Themen zum Microsoft Examen: 70-462 Administering Microsoft SQL Server 2012/2014 Databases

expand_more chevron_right Zielgruppe

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.

expand_more chevron_right Vorkenntnisse

This course requires that you meet the following 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.

expand_more chevron_right Detail-Inhalte

  1. Installing SQL Server 2014
    1. Introduction to the SQL Server Platform
    2. SQL Server Services and Configuration Options
    3. Considerations for Installing SQL Server
    4. Installing SQL Server 2014
      1. Installing SQL Server 2014
  2. Working with Databases
    1. Overview of SQL Server Databases
    2. Creating Databases
    3. Using Database Files and Filegroups
    4. Moving Database Files
    5. Buffer Pool Extension
      1. Creating and Configuring Databases
  3. SQL Server 2014 Recovery Models
    1. Backup Strategies
    2. Understanding SQL Server Transaction Logging
    3. Planning a SQL Server Backup Strategy
      1. Understanding SQL Server Recovery Models
  4. Backup of SQL Server 2014 Databases
    1. Backing up Databases and Transaction Logs
    2. Managing Database Backups
    3. Working with Backup Options
      1. Backing Up SQL Server Databases
  5. Restoring SQL Server 2014 Databases
    1. Understanding the Restore Process
    2. Restoring Databases
    3. Working with Point-in-Time Recovery
    4. Restoring System Databases and Individual Files
      1. Restoring SQL Server Databases
  6. Importing and Exporting Data
    1. Transferring Data To/From SQL Server
    2. Importing and Exporting Table Data
    3. Inserting Data in Bulk
    4. Deploying and Upgrading Data-tier Applications
      1. Importing and Exporting Data
  7. Authenticating and Authorizing Users
    1. Authenticating Connections to SQL Server
    2. Authorizing Logins to Access Databases
    3. Authorization Across Servers
    4. Partially Contained Databases
      1. Authenticating Users
  8. Assigning Server and Database Roles
    1. Working with Server Roles
    2. Working with Fixed Database Roles
    3. Creating User-defined Database Roles
      1. Assigning Server and Database Roles
  9. Authorizing Users to Access Resources
    1. Authorizing User Access to Objects
    2. Authorizing Users to Execute Code
    3. Configuring Permissions at the Schema Level
      1. Authorizing Users to Access Resources
  10. Protecting Data by Using Encryption and Auditing
    1. Options for Auditing Data Access in SQL Server
    2. Implementing SQL Server Audit
    3. Managing SQL Server Audit
    4. Protecting Data by Using Encryption
      1. Using Auditing and Encryption
  11. Automating SQL Server 2014 Management
    1. Automating SQL Server Management
    2. Working with SQL Server Agent
    3. Managing SQL Server Agent Jobs
    4. Multi-Server Management
      1. Automating SQL Server Management
  12. Configuring Security for SQL Server Agent
    1. Understanding SQL Server Agent Security
    2. Configuring Credentials
    3. Configuring Proxy Server Accounts
      1. Configuring Security for SQL Server Agent
  13. Monitoring SQL Server 2014 by Using Alerts and Notifications
    1. Configuring Database Mail
    2. Monitoring SQL Server Errors
    3. Configuring Operators, Alerts, and Notifications
      1. Monitoring SQL Server by Using Alerts and Notifications
  14. Performing Ongoing Database Maintenance
    1. Ensuring Database Integrity
    2. Maintaining Indexes
    3. Automating Routine Database Maintenance
      1. Performing Ongoing Database Maintenance
  15. Tracing Access to SQL Server 2014
    1. Capturing Activity by Using SQL Server Profiler
    2. Improving Performance by Using the Database Engine Tuning Advisor
    3. Working with Tracing Options
    4. Distributed Replay
    5. Monitoring Locks
      1. Tracing Access to SQL Server
  16. Monitoring SQL Server 2014
    1. Monitoring Activity
    2. Capturing and Managing Performance Data
    3. Analyzing Collected Performance Data
    4. SQL Server Utility
      1. Monitoring SQL Server
  • expand_more chevron_right event_available 14.12.-18.12.2020 14.12.2020 Seminarzeitentimer5 Tage5 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,265.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,265.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 01.02.-05.02.2021 01.02.2021 Seminarzeitentimer5 Tage5 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,265.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,265.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 01.02.-05.02.2021 01.02.2021 Seminarzeitentimer5 Tage5 T roomETC-Graz Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,265.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,265.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 22.03.-26.03.2021 22.03.2021 Seminarzeitentimer5 Tage5 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,265.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,265.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 03.05.-07.05.2021 03.05.2021 Seminarzeitentimer5 Tage5 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,265.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,265.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 21.06.-25.06.2021 21.06.2021 Seminarzeitentimer5 Tage5 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,265.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,265.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 21.06.-25.06.2021 21.06.2021 Seminarzeitentimer5 Tage5 T roomETC-Graz Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,265.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,265.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 09.08.-13.08.2021 09.08.2021 Seminarzeitentimer5 Tage5 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,265.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,265.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 27.09.-01.10.2021 27.09.2021 Seminarzeitentimer5 Tage5 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,265.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,265.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 15.11.-19.11.2021 15.11.2021 Seminarzeitentimer5 Tage5 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,265.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,265.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 15.11.-19.11.2021 15.11.2021 Seminarzeitentimer5 Tage5 T roomETC-Graz Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,265.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,265.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services

Ähnliche Seminare

2 Bewertungen

  • Super Kurs, informativ, interessant und lehrreich! Sympathische Trainerin vermittelt die Inhalte gut verständlich!

    — Georg T. · 05.02.2016
  • gute Kursunterlagen, verständlich vermittelt.

    — Helmut S. · 26.11.2015