SQL Server 2012 Administration

Identify, configure and support all major aspects of Microsoft SQL Server 2012 databases
Overview

Microsoft SQL Server 2012 is a powerful data platform that will help you quickly build solutions and insights across the organisation.  With the development of SQL Server Always On technologies, it provides near zero downtime.  To benefit from such a powerful product, you will need to be able to identify, configure, and support all major aspects of Microsoft SQL Server 2012 databases.

Course Code
SQ124ADM
Duration
4 Days
Delivery Style
Classroom
Course Type
Public or Private
Max Delegates
12
Available as Nutshell
No

Book your team training at your premises

  • Date
  • Venue
  • Cost
  • More info

Book your place

Purpose of this course

The course covers essential topics in SQL Server Administration including installation, using policies, security, backup, recovery, availability management and monitoring.  The course will include lectures, demonstrations and exercises to consolidate the topics covered.

Who is this course for

Database administrators and support technicians who need to be able to implement and manage Microsoft SQL Server 2012 databases.

You will learn how to
  • Install an instance of SQL Server
  • Create and configure databases
  • Backup and restore databases
  • Maximise the availability of SQL Server
  • Create logins
  • Manage user and role permissions
  • Prevent transaction logs from using unlimited disk space
  • Monitor SQL Server databases
Benefits for your organisation

SQL Server is becoming an increasingly popular choice for enterprise wide applications. This course will give your organisation the confidence to exploit, manage and support this product both safely and securely. It will help ensure best practices are being followed with SQL Server.

Benefits for you as an individual

Many roles now require knowledge of SQL Server. This course will equip you with the skills to manage and support Microsoft SQL Server 2012. You will have confidence in the major topics for SQL Server administration.

Overview of SQL Server Concepts and Features
  • SQL Server 2012 Features
  • Server Components
  • Architecture
  • Administering SQL Server 2012
  • Installing SQL Server 2012
  • SQL Server 2012 Editions
Installing Microsoft SQL Server 2012
  • System Requirements
  • Performing SQL Server 2012 Setup
  • Installing SQL Server 2012
  • Upgrading From Previous Versions of SQL Server
  • Post-installation Configuration
  • Dedicated Administrator Connection
Designing and Implementing Databases
  • Organising Data
  • Post-Installation Databases
  • Database Files
  • Planning a Database
  • Creating Databases
  • Working with Filegroups
  • Filestream Data
  • Database Options
  • Managing Databases
Securing SQL Server
  • SQL Server Security
  • SQL Server Security Terminology
  • Authentication Modes
  • Database Access Security
  • Permissions and Securable
  • Policy-based Management
  • Transparent Data Encryption
  • Auditing
  • Simple Auditing
  • Security Checklists
Importing, Exporting and Accessing Data
  • Importing and Exporting Data
  • Copying Databases with Management Studio
  • Using the Import/Export Wizard
  • Introduction to Integration Services
  • Linked Servers
  • Other Data Transfer Methods
Disaster Recovery
  • Disaster Recovery Fundamentals
  • Basic Backup and Restore Operations
  • Further Backup Concepts
  • Further Recovery Concepts
  • Backup Compression
  • Recovering System Databases
Enhancing Database Availability
  • SQL Server 2012 Database Availability
  • Clustering SQL Server
  • Database Snapshots
  • Database Mirroring
  • Replication
  • Configuration Replication
  • Log Shipping
Monitoring the Database Server
  • Monitoring Systems
  • Database Mail
  • Using Operators and Alerts
  • Monitoring with SQL Profiler
  • Using Windows Performance Monitor
  • SQL Server Logs
  • Activity Monitor
  • Performance Data Collection
  • SQL Server Utility
  • Using DBCC to Check Integrity
  • DDL Triggers
Maintenance and Optimisation
  • Managing Jobs
  • Database Maintenance Plans
  • Implementing Multi-server Jobs
  • Viewing the Execution Plan
  • Using the Database Tuning Advisor
  • Index Fragmentation
  • SQL Server
Prerequisites

Delegates must have a good working knowledge of Microsoft SQL Server. This can be obtained by attending our SQL Server Essentials course. Delegates must have a basic knowledge of Microsoft Windows.

About the Lead Trainer

Stephen has 20 years’ experience in the IT industry. A member of the Institute of IT Training and British Computer Society with a degree in business computing systems, Stephen has a solid foundation upon which his ITIL® Expert qualification sits.