MS20462_1

Ladda ner som PDF

Maintenance of Microsoft SQL Server Databases - Optimized

This 3-day instructor-led optimized 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.

Optimerad kurs, tre fokuserade dagar (original fem dagar)

Audience

  • DBA responsible for the operation of existing SQL Server
  • IT Support/Operation without specific DBA role
  • Outsourcing Partners

Prior knowledge

This course requires that you meet the following prerequisites:

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

Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills:

Certification

This course helps people prepare for exam 70-462

Language

The course is taught in Swedish (Contact us if you prefer English).

Courseware

Microsoft modulized dMOC

Informator Training Cloud

Our training portal supports your development throughout the training. The portal saves you time and is designed to give you a more effective learning experience - leading to better results and greater knowledge enforcement after the course. Read more >

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

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.

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

Module 2: Working with Databases

This module describes he preinstalled system databases,... Läs mer

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

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.

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

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.

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

Module 3: Designing a Physical Database Implementation

  • Files and Filegroups
  • Partitioning Data
  • Compressing Data

Lab : Designing a Physical Database Implementation

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.

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

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.

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

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.

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

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.

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

Module 12: Configuring Security for SQL Server Agent

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

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

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

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

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

Module 14: Performing Ongoing Database Maintenance

This module covers database maintenance plans.

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

Module 8: Monitoring Server Health

  • Introduction to Health Monitoring
  • Options for Monitoring Health
  • Using the SQL Server Utility

Lab : Monitoring Server Health

Utbildningen levereras i samarbete med

Kurs-ID: MS20462_1
Längd: 3 dagar
Pris exkl moms: 28 450 kr

Frågor om kursen!?

Har du frågor om kursens innehåll, leveransdatum/ort eller behöver en företagsanpassad variant? Fyll i formuläret nedan!


Kan betalas med:
TRAINING CARD SA-VOUCHER

Ort och datum

Stockholm
17 okt – 19 okt
Boka nu!
7 nov – 9 nov
Boka nu!
Göteborg
17 okt – 19 okt R
Boka nu!
7 nov – 9 nov R
Boka nu!
Malmö
17 okt – 19 okt R
Boka nu!
7 nov – 9 nov R
Boka nu!
Cloud Access
i Läs mer

Delta på kursen från ditt hem, jobb eller annan plats.

17 okt – 19 okt
Boka nu!
7 nov – 9 nov
Boka nu!

Tipsa