Realdolmen Education

Details

Day-to-day Database Management in Microsoft SQL Server 2014

This course is currently not scheduled on the open calendar, but can be organized on request.

Request Course

Duration

5 day(s)

Audience

This course is intended for Database Administrators of medium sized systems and Database Developers who have to maintain and administer their own system. The course does not intend to prepare people who plan on taking an exam but rather those who have to do the practical day to day management in an environment where the line between developer and administrator is very faint.

Prerequisites

Before attending this course, students must have a working knowledge of relational databases and a basic knowledge of the Microsoft Windows operating system and its core functionality.

Objectives

The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining and programming a database.

Methods

Instructor led training alternated with demo's and exercises. Each student disposes of a workstation. All the labs for this course can be performed using the provided virtual machines.

Description

After completing this course, students will be able to: Create databases, Create users and grant them permissions, Backup and restore databases, Import and export data, Monitor the system. On the other hand, they will also be able to : Create tables and set constraints, Create indexes and analyse performance, Create views, Create highly concurrent applications.

Contents

  • Module 1: Working with databases and storage
    • Introduction to data storage with SQL Server
    • Managing storage for system databases
    • Managing storage for user databases
    • Moving database files
    • Configuring the buffer pool extension
  • Module 2: Designing and implementing tables
    • Using data types
    • Working with character data
    • Designing tables
    • Working with schemas
    • Creating and altering tables
  • Module 3: Ensuring data integrity through constraints
    • Enforcing data integrity
    • Implementing domain integrity
    • Implementing entity and referential integrity
  • Module 4: Introduction to indexes
    • Core indexing concepts
    • Single-column and composite indexes
    • Table structures in SQL Server
    • Working with clustered indexes
    • Working with nonclustered indexes
  • Module 5: Advanced Indexing
    • Core concepts of execution plans
    • Common execution plan elements
    • Working with execution plans
    • Designing effective nonclustered indexes
    • Performance monitoring
  • Module 6: Designing and implementing views
    • Introduction to views
    • Creating and managing views
    • Performance considerations for views
  • Module 7: Planning and implementing a backup strategie
    • Understanding SQL Server recovery models
    • Planning a backup strategie
    • Backing up databases and transaction logs
    • Using backup options
    • Ensuring backup reliability
  • Module 8: Restoring SQL Server 2014 Databases
    • Understanding the Restore Process
    • Restoring Databases
    • Advanced restore scenarios
    • Point-in-time recovery
  • Module 9: Importing and Exporting Data
    • Introduction to transfering data
    • Importing and Exporting Table Data
    • Copying or moving a database
  • Module 10: Monitoring SQL Server 2014
    • Introduction to monitoring SQL Server
    • Dynamic management views and functions
    • Performance monitor
  • Module 11: Managing SQl Server security
    • Introduction to SQL Server security
    • managing server-level security
    • Managing database-level principals
    • managing database permissions
  • Module 12: Performing Ongoing Database Maintenance
    • Ensuring Database Integrity
    • Maintaining Indexes
    • Automating Routine Database Maintenance
  • Module 13: Automating SQL Server 2014 management
    • Automating SQL Server management
    • Implementing SQL Server agent jobs
    • managing SQL Server agent jobs
    • Managing job step security contexts
    • Managing jobs on multiple servers
  • Module 14: Monitoring SQL Server 2014 with notifications and alerts
    • Monitoring SQl Server errors
    • Configuring database mail
    • Configuring operators, notifications and alerts