MS20462_2

Ladda ner som PDF

Installing 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 who installs SQL Server
  • Continued MS20462_1

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:

Language

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

Courseware

Microsoft 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.
  • Design a logical schema for a database based on application requirements
  • Design the physical implementation of a database for a given set of requirements
  • Evaluate options for including binary large object data in a database design
  • Explain the concept of the transaction log and the SQL Server recovery models and implement different backup strategies that are available with SQL Server.
  • 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.
  • Design an optimal replication strategy from a given set of business and technical requirements
  • Plan and implement a high availability solution

 

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... 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.
  • Design a logical schema for a database based on application requirements
  • Design the physical implementation of a database for a given set of requirements
  • Evaluate options for including binary large object data in a database design
  • Explain the concept of the transaction log and the SQL Server recovery models and implement different backup strategies that are available with SQL Server.
  • 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.
  • Design an optimal replication strategy from a given set of business and technical requirements
  • Plan and implement a high availability solution

 

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: 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 3: Designing a Physical Database Implementation

  • Files and Filegroups
  • Partitioning Data
  • Compressing Data
  • Lab : Designing a Physical Database Implementation

Module 4: Designing a Database Solution for BLOB Data

  • Considerations for BLOB Data
  • Working with FileStream
  • Using Full-text Search
  • Lab : Creating a Database Solution for BLOB Data

Module 7: Authenticating and Authorizing Users

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

  • Authenticating Connections to SQL Server
  • Authorizing Logins to Access Databases
  • Authorization Across Servers
  • Partially Contained Databases

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.

  • Working with Server Roles
  • Working with Fixed Database Roles
  • Creating User-defined Database Roles

Module 9: Authorizing Users to Access Resources

This module covers permissions and the assignment of permissions.

  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level

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.

  • Options for Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit
  • Protecting Data by Using Encryption

Module 6: Designing Database Security

  • Designing Server-Level Security
  • Designing Database-Level Security
  • Transparent Database Encryption
  • Auditing Database Activity

Lab : Planning Database Security

Module 12: Replicating Data

  • SQL Server Replication
  • Planning Replication
  • Lab : Planning and Implementing SQL Server Replication

Module 13: Designing for High Availability

  • High Availability in SQL Server 2012
  • AlwaysOn Availability Groups
  • Lab : Implementing High Availability

Utbildningen levereras i samarbete med

Kurs-ID: MS20462_2
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
10 okt – 12 okt
Boka nu!
14 nov – 16 nov
Boka nu!
Göteborg
10 okt – 12 okt R
Boka nu!
14 nov – 16 nov R
Boka nu!
Malmö
10 okt – 12 okt R
Boka nu!
14 nov – 16 nov R
Boka nu!
Cloud Access
i Läs mer

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

10 okt – 12 okt
Boka nu!
14 nov – 16 nov
Boka nu!

Tipsa