Administering Microsoft SQL Server Databases (70-462)

Administering Microsoft SQL Server Databases (70-462) Training
Administering Microsoft SQL Server Databases (70-462)
  • Administering Microsoft SQL Server Databases (70-462)

    5 Days Course
    SQL Server
    1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
    Loading...

    Reviews

    Course Details

    Overview

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

    Objectives

    After completing this course, students will be able to:

    • 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.

    Outline

    LESSON 1 – WORKING WITH DATABASES

    • Overview of SQL Server Databases
    • Creating Databases
    • Using Database Files and Filegroups
    • Moving Database Files
    • Buffer Pool Extension

    LESSON 2 – SQL SERVER 2014 RECOVERY MODELS

    • Backup Strategies
    • Understanding SQL Server Transaction Logging
    • Planning a SQL Server Backup Strategy

    LESSON 3 – BACKUP OF SQL SERVER 2014 DATABASES

    • Backing up Databases and Transaction Logs
    • Managing Database Backups
    • Working with Backup Options

    LESSON 4 – RESTORING SQL SERVER 2014 DATABASES

    • Understanding the Restore Process
    • Restoring Databases
    • Working with Point-in-Time Recovery
    • Restoring System Databases and Individual Files

    LESSON 5 – IMPORTING AND EXPORTING DATA

    • Transferring Data To/From SQL Server
    • Importing and Exporting Table Data
    • Inserting Data in Bulk
    • Deploying and Upgrading Data-tier Applications

    LESSON 6 – AUTHENTICATING AND AUTHORIZING USERS

    • Authenticating Connections to SQL Server
    • Authorizing Logins to Access Databases
    • Authorization Across Servers
    • Partially Contained Databases

    LESSON 7 – ASSIGNING SERVER AND DATABASE ROLES

    • Working with Server Roles
    • Working with Fixed Database Roles
    • Creating User-defined Database Roles

    LESSON 8 – AUTHORIZING USERS TO ACCESS RESOURCES

    • Authorizing User Access to Objects
    • Authorizing Users to Execute Code
    • Configuring Permissions at the Schema Level

    LESSON 9 – PROTECTING DATA BY USING ENCRYPTION AND AUDITING

    • Options for Auditing Data Access in SQL Server
    • Implementing SQL Server Audit
    • Managing SQL Server Audit
    • Protecting Data by Using Encryption

    LESSON 10 – AUTOMATING SQL SERVER 2014 MANAGEMENT

    • Automating SQL Server Management
    • Working with SQL Server Agent
    • Managing SQL Server Agent Jobs
    • Multi-Server Management

    LESSON 11 – CONFIGURING SECURITY FOR SQL SERVER AGENT

    • Understanding SQL Server Agent Security
    • Configuring Credentials
    • Configuring Proxy Server Accounts

    LESSON 12 – MONITORING SQL SERVER 2014 BY USING ALERTS AND NOTIFICATIONS

    • Configuring Database Mail
    • Monitoring SQL Server Errors
    • Configuring Operators, Alerts, and Notifications

    LESSON 13 – PERFORMING ONGOING DATABASE MAINTENANCE

    • Ensuring Database Integrity
    • Maintaining Indexes
    • Automating Routine Database Maintenance

    LESSON 14 – TRACING ACCESS TO SQL SERVER 2014

    • Capturing Activity by Using SQL Server Profiler
    • Improving Performance by Using the Database Engine Tuning Advisor
    • Working with Tracing Options
    • Distributed Replay
    • Monitoring Locks

    LESSON 15 – MONITORING SQL SERVER 2014

    • Monitoring Activity
    • Capturing and Managing Performance Data
    • Analyzing Collected Performance Data
    • SQL Server Utility

    LESSON 16 – INSTALLING SQL SERVER 2014

    • Introduction to the SQL Server Platform
    • SQL Server Services and Configuration Options
    • Considerations for Installing SQL Server
    • Installing SQL Server 2014

    Target 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.

    Course Schedule

      Dec 25 - Dec 29, 2017
    London
      Mar 19 - Mar 23, 2018
    London
      Jun 18 - Jun 22, 2018
    London
      Sep 17 - Sep 21, 2018
    London
      Dec 17 - Dec 21, 2018
    London