Microsoft SQL Server System Administration Fundamentals

Microsoft SQL Server System Administration Fundamentals

Audience

This course is for delegates who need to learn the essential skills necessary to maintain a Microsoft SQL Server 2008 or 2012 database infrastructure.

Prerequisites

  • An understanding of working in a Microsoft Windows operating system environment
  • An understanding of relational databases and design principles
  • Some experience of the SQL language would be beneficial

Duration

3 days. Hands on.

Course Objectives

This course is, effectively, an abridged version of the full 5 day Microsoft SQL Server Administration course.  It is intended for students who need to learn the essential skills necessary to maintain a Microsoft SQL Server 2008 or 2012 database infrastructure. Being concise and hands on, it is designed to ensure students are familiar with the Microsoft SQL Server administration concepts, tools and utilities as quickly as possible.

Upon successful completion of this course, students will be able to:

  • Perform an Installation of SQL Server 2008 and 2012
  • Configure SQL Server Post Installation
  • Plan and Create Databases
  • Configure and Manage Databases
  • Create a Database Schema
  • Create Tables in a Database
  • Understand and Implement Data Integrity
  • Understand and Implement SQL Server Indexes
  • Understand and Implement SQL Server Security
  • Understand Data Transfer Utilities
  • Backup and Restore Databases
  • Create and Implement Database Snapshots
  • Automate Tasks in SQL Server
  • Use the SQL Server Tools and Utilities to Monitor Performance

Course Content

Install and Configure SQL Server
Installation Prerequisites
The Installation Process
Post Install Configuration Options

Creating, Configuring and Managing Databases
Creating a Database
Configuring and Managing a Database
Database Schemas

Creating and Managing Tables
Creating a Table
Native SQL Server Data Types
Columns and Column Properties

Implementing and Managing Data Integrity
Introducing Data Integrity
Using Constraints to Implement Data Integrity

Creating and Managing Indexes
SQL Server Index Architecture
Creating Clustered Indexes
Creating Non-Clustered Indexes

SQL Server Security
Overview of SQL Server Security
Security at the Server Level
Security at the Database Level

Transferring Data
Overview of Data Transfer
Examining the Data Transfer Utilities
Bulk Loading Data Using the Import/Export Wizard
Introducing SQL Server Integration Services (SSIS)

Backups and Recovery
Backup Types and Strategies
Backing up a Database
Restoring a Database
Online Restore Operations
Database Snapshots
Recovering System Databases

SQL Server Automation
Overview of SQL Server Automation
The SQL Server Agent Service
Creating Maintenance Plans
Creating and Managing Jobs
Creating and Managing Operators
Creating and Managing Alerts

Monitoring SQL Server
Overview of Performance Monitoring
Viewing the Current Activity
Using System Monitor
Using SQL Server Profiler

Virtual Courses

ALL of our courses can be delivered virtually. And our Bath public schedule of courses are now available as live virtual sessions, using the popular Zoom Virtual Classroom and remote labs. Delegates can test their access at: www.zoom.us/test

Public Courses

There are no up-coming events

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...