Bend, Oregon MOC 20462 SQL Server Training - Dynamics Edge

Bend, Oregon MOC Class 20462 SQL Server Training -> Administering Microsoft SQL Server Databases (2014)

Dynamics Edge4.67 4.67 out of 50 stars, based on 80 reviews.*

Please choose Dynamics Edge MOC Class 20462 quality SQL Server training course that will make the best results for you. We may have custom options for you.

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.

Who Should Attend

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 Outline

Module 1: Installing SQL Server 2014

This module introduces the SQL Server 2014 platform. It describes the components, editions, and versions of SQL Server 2014, SQL Server services and configuration options, and service accounts. The module also explains how to assess resource requirements for SQL Server 2014 and how to install SQL Server 2014.

Lessons

Module 2: Working with Databases

This module describes he preinstalled system databases, the physical structure of databases, and the most common configuration options related to them.

Lessons

Module 3: SQL Server 2014 Recovery Models

In this module, you will consider how to create a strategy that is aligned with organizational needs and see how the transaction logging capabilities of Microsoft SQL Server can help you to achieve an appropriate outcome.

Lessons

Module 4: Backup of SQL Server 2014 Databases

In this module, you will explore the key backup types in more depth and learn how to implement the backups. You will also see how to apply options that affect the way that the backups work.

Lessons

Module 5: Restoring SQL Server 2014 Databases

In this module, you will see how to restore user and system databases and how to implement point-in-time recovery.

Lessons

Module 6: Importing and Exporting Data

This module covers the use of the import/export wizards and explains how they relate to SSIS. It also introduces BCP and BULK INSERT.

Lessons

Module 7: Authenticating and Authorizing Users

This module covers SQL Server security models, logins, users, and contained databases.

Lessons

Module 8: Assigning Server and Database Roles

This module covers fixed server roles, user-defined server roles, fixed database roles, and user-defined database roles.

Lessons

Module 9: Authorizing Users to Access Resources

This module covers permissions and the assignment of permissions.

Lessons

Module 10: Protecting Data by Using Encryption and Auditing

This module describes the available options for auditing in SQL Server, how to use and manage the SQL Server audit feature, and how to implement encryption.

Lessons

Module 11: Automating SQL Server 2014 Management

This module describes how to use SQL Server Agent for automation. It also explains the benefits of using master and target servers to centralize the administration of automation.

Lessons

Module 12: Configuring Security for SQL Server Agent

This module describes the considerations for SQL Server Agent security, including proxy accounts and credentials.

Lessons

Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications

This module covers the configuration of database mail, alerts, and notifications.

Lessons

Module 14: Performing Ongoing Database Maintenance

This module covers database maintenance plans.

Lessons

Module 15: Tracing Access to SQL Server 2014

This module describes how to use SQL Server Profiler and SQL Trace stored procedures to capture information about SQL Server. It also describes how to use Distributed Replay to capture trace information from multiple servers and how to monitor locking.

Lessons

Module 16: Monitoring SQL Server 2014

This module explains how to use Distributed Management Views to monitor SQL Server. It also describes how to configure data collection and the SQL Server Utility.

Lessons

Labs

Lab: Installing SQL Server 2014
Lab: Creating and Configuring Databases
Lab: Understanding SQL Server Recovery Models
Lab: Backing Up SQL Server Databases
Lab: Restoring SQL Server Databases
Lab: Importing and Exporting Data
Lab: Authenticating Users
Lab: Assigning Server and Database Roles
Lab: Authorizing Users to Access Resources
Lab: Using Auditing and Encryption
Lab: Automating SQL Server Management
Lab: Configuring Security for SQL Server Agent
Lab: Monitoring SQL Server by Using Alerts and Notifications
Lab: Performing Ongoing Database Maintenance
Lab: Tracing Access to SQL Server
Lab: Monitoring SQL Server

What You'll Learn

After completing this course, students will be able to:

Is your class or class date not listed here? Take a look at our SQL Server complete Course Catalog

Or, call DynamicsEdge now (800) 453-5961 for us to prepare you a Customized Course

Last updated: 2019-02-17

Bend, Oregon SQL Server Training

Dynamics Edge locations in Bend, Oregon:

Dynamics Edge needs to obtain more information about your SQL Server custom training that you need in Bend, Oregon . Please call Dynamics Edge at (800) 453-5961 or e-mail Dynamics Edge at sales@dynamicsedge.com and specify that you are looking for a custom class at this location.

Please contact us for a list of our Bend, Oregon locations.

More SQL Server training classes

*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular courses offered on this page.