We use cookies to offer you a better experience and to analyse how visitors use our site, you may consent to our cookies by continuing to use our site, or you may view more information and choose to reject cookies by clicking here. Thank you

Contact us online or call us on 0191 377 8377

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields

PDF
Course SQL Server Administering Microsoft SQL Databases 20462
  • Public Scheduled Price£2295 +VAT
  • Course Duration5 Days
  • Course Options
    Public Scheduled
    Public Scheduled
    Fixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Private
    Private
    Flexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Virtual

Overview
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.
Prerequisites
    • 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
    • Some experience with database design
    • Working knowledge of relational databases
    • Working knowledge of Transact-SQL
    • Basic knowledge of the Microsoft Windows operating system and its core functionality
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.
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.
What's included
    • For courses held on our premises, complimentary tea, coffee and biscuits are available. Lunch is not provided, however, there is a wide variety of eateries within a short walk of the centre.
    • Comprehensive course materials and exercises
Course Content
    • 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
    • Working with Databases
      Overview of SQL Server Databases

      Creating Databases

      Using Database Files and Filegroups

      Moving Database Files

      Buffer Pool Extension
    • SQL Server 2014 Recovery Models
      Backup Strategies

      Understanding SQL Server Transaction Logging

      Planning a SQL Server Backup Strategy
    • Backup of SQL Server 2014 Databases
      Backing up Databases and Transaction Logs

      Managing Database Backups

      Working with Backup Options
    • Restoring SQL Server 2014 Databases
      Understanding the Restore Process

      Restoring Databases

      Working with Point-in-Time Recovery

      Restoring System Databases and Individual Files
    • 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
    • Authenticating and Authorizing Users
      Authenticating Connections to SQL Server

      Authorizing Logins to Access Databases

      Authorization Across Servers

      Partially Contained Databases
    • Assigning Server and Database Roles
      Working with Server Roles

      Working with Fixed Database Roles

      Creating User-defined Database Roles
    • Authorizing Users to Access Resources
      Authorizing User Access to Objects

      Authorizing Users to Execute Code

      Configuring Permissions at the Schema Level
    • 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
    • Automating SQL Server 2014 Management
      Automating SQL Server Management

      Working with SQL Server Agent

      Managing SQL Server Agent Jobs

      Multi-Server Management
    • Configuring Security for SQL Server Agent
      Understanding SQL Server Agent Security

      Configuring Credentials

      Configuring Proxy Server Accounts
    • Monitoring SQL Server 2014 by Using Alerts and Notifications
      Configuring Database Mail

      Monitoring SQL Server Errors

      Configuring Operators, Alerts, and Notifications
    • Performing Ongoing Database Maintenance
      Ensuring Database Integrity

      Maintaining Indexes

      Automating Routine Database Maintenance
    • 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
    • Monitoring SQL Server 2014
      Monitoring Activity

      Capturing and Managing Performance Data

      Analyzing Collected Performance Data

      SQL Server Utility

 

Course Dates

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk

Printed: 23 Aug 19

 

 

 

Contact us

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields