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
  • 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 Please contact us to discuss dates for this course, thank you

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

Printed: 22 Apr 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