English French German Italian Portuguese Russian Spanish


  • Database Training

    databaseInterSource offers live instructor-led courses on all important database programming technologies, including Crystal Reports, Microsoft Access, MySQL, Oracle, SQL, SQL Server, SSAS, SSIS, SSRS and Xcelsius.

    These live classes are offered both on client sites, at our Geneva training center, and via a Web interface.

  • About Database

    A database is a collection of data stored and maintained for one or more uses. Most modern databases are managed by a Database Management System (DBMS), a set of computer programs that controls the creation, maintenance, and the use of the database with computer as a platform or of an organization and its end users. It allows organizations to place control of organization-wide database development in the hands of database administrators (DBAs) and other specialists.

    The proper integration of databases can dramatically increase the functionality of all types of applications, whether or not Web-enabled.

    Read More
  • Course Details Database

    Classes are offered at client sites, at our Geneva training center, and via a live web conference. For detailed course outlines and scheduled classes, please see below.

    To book training, navigate to the course you need, then:

    • For scheduled online classes, register from the choices indicated.
    • If you need an alternative dates, time or location, or if you want a live classroom course, click on “request an offer for this course,” to complete the form.

    InterSource clients are active globally. Live web courses run during Eastern Standard Time (New York) business hours and are priced in US dollars.

    We also run live web conference classes during European business hours, which can be invoiced in local currencies. To discuss your requirements please contact us on +41 (22) 958 0114.

MOC 20462 - Administering Microsoft SQL Server 2014 Databases

 PDF PrintEmail

Course duration

  • 5 Days

Course Outline

This Administering Microsoft SQL Server 2014 Databases training class 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.

The primary audience for this course is individuals who administer and maintain SQL Server 2014 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 2014 databases.

  • Learn to plan and install SQL Server 2014.
  • Learn to describe system databases, the physical structure of databases, and the most common configuration options related to them.
  • Learn to explain the concept of the transaction log and the SQL Server recovery models and implement different backup strategies that are available with SQL Server.
  • Learn to back up SQL Server databases.
  • Learn to restore SQL Server databases.
  • Learn to import and export data by using wizards, the bulk copy utility, and data-tier applications.
  • Learn to work with SQL Server security models, logins, users, and contained databases.
  • Learn to work with server roles and database roles.
  • Learn to use permissions to secure resources.
  • Learn to use SQL Server audit and Transparent Data Encryption.
  • Learn to work with SQL Server Agent to configure and execute jobs.
  • Learn to implement SQL Server Agent security, proxy accounts, and credentials.
  • Learn to configure database mail, alerts, and notifications.
  • Learn to create database maintenance plans.
  • Learn to use SQL Server Profiler, SQL Trace, and Distributed Relay.
  • Learn to use Distributed Management Views and configure data collection.
  • 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.
  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
    5. Lab: Installing SQL Server 2014
      1. Performing Pre-installation Stress Tests
      2. Installing a SQL Server Instance
      3. Performing Post-Installation Checks
  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
    6. Lab: Creating and Configuring Databases
      1. Creating a Storage Pool
      2. Adjusting tempdb Configuration
      3. Creating and Configuring a Database
      4. Attaching a Database
      5. Using Buffer Pool Extension
  3. SQL Server 2014 Recovery Models
    1. Backup Strategies
    2. Understanding SQL Server Transaction Logging
    3. Planning a SQL Server Backup Strategy
    4. Lab: Understanding SQL Server Recovery Models
      1. Planning a Backup Strategy
      2. Configuring Recovery Models
      3. Reviewing Recovery Models and Strategy
  4. Backup of SQL Server 2014 Databases
    1. Backing up Databases and Transaction Logs
    2. Managing Database Backups
    3. Working with Backup Options
    4. Lab: Backing Up SQL Server Databases
      1. Investigating Backup Compression
      2. Performing Transaction Log Backups
      3. Performing Differential Backups
      4. Performing Copy-Only Backups
      5. Performing Filegroup Backups
  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
    5. Lab: Restoring SQL Server Databases
      1. Determining a Restore Strategy
      2. Restoring a Database
      3. Using STANDBY Mode
  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
    5. Lab: Importing and Exporting Data
      1. Importing an Excel Spreadsheet
      2. Importing a CSV File
      3. Creating and Testing an Extraction Package
      4. Creating and Deploying a Data-tier Application
      5. Comparing Loading Performance
  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
    5. Lab: Authenticating Users
      1. Creating Logins
      2. Correcting an Application Login Issue
      3. Creating Database Users
      4. Correcting Access to a Restored Database
  8. Assigning Server and Database Roles
    1. Working with Server Roles
    2. Working with Fixed Database Roles
    3. Creating User-defined Database Roles
    4. Lab: Assigning Server and Database Roles
      1. Assigning Server Roles
      2. Assigning Fixed Database Roles
      3. Creating and Assigning User-defined Database Roles
      4. Checking Role Assignments
  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
    4. Lab: Authorizing Users to Access Resources
      1. Assigning Schema-level Permissions
      2. Assigning Object-level Permissions
      3. Testing Permissions
  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
    5. Lab: Using Auditing and Encryption
      1. Determining Audit Configuration and Creating an Audit
      2. Creating Server Audit Specifications
      3. Creating Database Audit Specifications
      4. Testing Audit Functionality
      5. Using Transparent Data 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
    5. Lab: Automating SQL Server Management
      1. Creating a Job
      2. Scheduling a Job
      3. Troubleshooting a Failing Job
      4. Creating a Multi-Server Job
  12. Configuring Security for SQL Server Agent
    1. Understanding SQL Server Agent Security
    2. Configuring Credentials
    3. Configuring Proxy Server Accounts
    4. Lab: Configuring Security for SQL Server Agent
      1. Troubleshooting Job Execution Failure
      2. Resolving Security Issues
      3. Performing Further Troubleshooting
  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
    4. Lab: Monitoring SQL Server by Using Alerts and Notifications
      1. Configuring Database Mail
      2. Implementing Notifications
      3. Implementing Alerts
  14. Performing Ongoing Database Maintenance
    1. Ensuring Database Integrity
    2. Maintaining Indexes
    3. Automating Routine Database Maintenance
    4. Lab: Performing Ongoing Database Maintenance
      1. Check Database Integrity by Using DBCC CHECKDB
      2. Correcting Index Fragmentation
      3. Creating a Database Maintenance Plan
      4. Investigating Table Lock Performance
  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
    6. Lab: Tracing Access to SQL Server
      1. Capturing a Trace by Using SQL Server Profiler
      2. Analyzing a Trace by Using the Database Engine Tuning Advisor
      3. Configuring SQL Trace
  16. Monitoring SQL Server 2014
    1. Monitoring Activity
    2. Capturing and Managing Performance Data
    3. Analyzing Collected Performance Data
    4. SQL Server Utility
    5. Lab: Monitoring SQL Server
      1. Creating a Utility Control Point
      2. Configuring a Health Policy
      3. Configuring Instances for Data Collection
      4. Working with Data Collector Reports

InterSource Geneva, a premier Information Technology training firm, offers over 400 different courses on server, database and programming technologies, as well as end-user classes for the most popular office, graphics and design applications. We serve clients in Switzerland (Geneva, Lausanne, Bern, Basel, Zurich) and throughout Europe (France, Germany, Austria, Finland, Sweden, England, Netherlands, Spain, etc.).

InterSource offers custom, private courses at client sites, standard public courses in our Geneva classroom, and online training via live Web conference. Training is offered in English and many other languages (Francais, Deutsch, Espanol, Italiano.)

For an overall view of our offerings, please visit us at www.intersource.ch.