Administering Microsoft SQL Server Databases

Course summary
5 days
Company-Specific / In-House

Administering Microsoft SQL Server Databases

Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... On completion of the course, delegates will be able to:

Plan a SQL Server instance
Install a SQL Server
Interpret the system databases, the physical configuration of databases and describe the most common setups
Understand the various backup methods and logging methodologies available (such as the transaction log) and be able to implement them
Create backups of SQL Server
Restore backups of SQL Server
Understand how to use the importing and exporting wizards, and appreciate their relationship to SSIS
Understand and implement the SQL server security model, and apply this at a login and user level
Understand the different types of roles among server and database (such as fixed server, user-defined)
Implement permission levels and fine-tuning access
Work with SQL Server Audit
Understand the SQL Server Agent and how this relates to the concept of jobs
Appreciate and use agent security and proxy accounts
Configure database mail, alerts and notifications.
Design and develop maintenance schedules
How to configure stored procedures
How to configure SQL Profiler
Introduce DMVs and the configuration of data collection.
Design Central Management Servers and Multi-Server queries
Work with SQL Server Virtualization and Data-Tier Applications
Troubleshoot SQL Server databases

Suitability - Who should attend?

This course is for people responsible for adminstering, installing and maintaining SQL Server databases. Database administrators, technical administrators and support staff are example job roles who would benefit from the training. Anybody looking to get into database administration would find this beneficial. As the course gives credit towards several Microsoft certifications this will also be useful for any IT professional looking to increase their knowledge.

This course would also be of benefit from anyone looking to develop applications that use information from SQL server databases, whether as desktop apps, web-based services or mobile applications.

Training Course Content

Module 1: Introduction to SQL Server 2012 and its Toolset

Introduction to the SQL Server Platform
Learn SQL Server Tools
Configuring services for SQL Server
How to verify installation of a SQL Server Component
Altering Service Accounts for New Instance
How to enable Named Pipes Protocol
How to make an AdvDev Alias
Time permitting: configuring a port for TCP/IP and the SQL Server browser

Module 2: Preparing Systems for SQL Server 2012

Overview of the architecture for SQL Server
How to plan your Server resource requirements
Important tests to carry out before installation
How to configure memory
How to conduct stress testing
Checking I/O operations

Module 3: Installing and Configuring SQL Server 2012

Preparing to Install SQL Server
How to install SQL Server
Performing upgrades
Installation automation tools
Review installation requirements
Creating an instance of SQL Server
Things to check post-installation
Server memory settings

Module 4: Working with Databases

Overview of SQL Server Databases
How to work with files
How to work with filegroups
Moving database files
Setting up tempdb
Creating and attaching sample databases
Adding many files to tempdb

Module 5: Understanding SQL Server 2012 Recovery Models

What backup strategies to consider
How SQL Server transaction logging works
How to plan a SQL Server backup strategy
Configure Recovery Models
Review recovery models and strategy

Module 6: Backup of SQL Server 2012 Databases

How to back up databases
How to back up transaction logs
Managing backups of your databases
Backup configuration options
Methods of applying compression
When to use a differential backup
Copy-only backups
Partial backups

Module 7: Restoring SQL Server 2012 Databases

Overview of the restore process
How to restore databases
Understanding Point-in-time recovery
Restoring system databases
Restoring individual files
Creating a strategy for restoring
How to restore the database
When to use STANDBY mode

Module 8: Importing and Exporting Data

How to transfer data to and from a SQL Server
How to import table data
How to export table data
Inserting data in bulk
Importing Excel data
Importing CSV files
How to create an extraction package
How to test an extraction package
Comparison of loading performance

Module 9: Authenticating and Authorizing Users

Authenticating the connection to the server
How to authorize logins
Authorizing logins across servers
Creating logins
Troubleshooting issues
Creating users
Correct access to restored

Module 10: Assigning Server and Database Roles

Understanding Server Roles
Understanding fixed database roles
How to create user-defined roles
Assigning server roles
Assigning fixed database roles
Assigning user-defined database roles
Checking role assignments

Module 11: Authorizing Users to Access Resources

Giving user access to objects
Allowing users to execute code
How to modify schema-level permissions
How to assign schema-level permissions
How to assign object-level permissions
Testing permissions

Module 12: Auditing SQL Server Environments

Auditing options for data access
How to implement an audit
How to manage an audit
Creating a configuration and carry out the audit
Creating server audit specifications
Creating database audit specifications
Testing audit functionality

Module 13: Automating SQL Server 2012 Management

Automating SQL Server Management
Working with the SQL Server agent
Configuring and managing SQL Server agent jobs
Creating a data extraction job
Scheduling the data extraction job
How to diagnose a failing job

Module 14: Configuring Security for SQL Server Agent

Overview of SQL Server agent security
How to configure credentials
How to configure proxy accounts
Diagnosing job execution failure
Resolving security issues
Advanced troubleshooting

Module 15: Monitoring SQL Server 2012 with Alerts and Notifications

Configuring database mail
How to monitor for errors
Setting up alerts, operators, and notifications
Implementing notifications
Implementing alerts

Module 16: Performing Ongoing Database Maintenance

Verifying the integrity of the database
Maintaining the indexes
Automating routine maintenance tasks
Using DBCC CHECKDB for integrity checking
Fixing fragementation
Designing a maintenance plan
Correcting table lock issues

Module 17: Tracing Access to SQL Server 2012

Configuring SQL Server Profiler to monitor activity
Configuring the Database Engine Tuning Advisor for performance
Configuring Tracing Options
Capturing a trace
Analyzing traces
Configuring a SQL trace

Module 18: Monitoring SQL Server 2012

How to oversee activity
How to capture performance data
How to analyze performance data
Understanding DMVs
Configuring the management data warehouse
Setting up data collection instances
Interpreting the data collector reports

Module 19: Managing Multiple Servers

Working with multiple servers
Virtualizing SQL Server
Configuring, creating and upgrading data-tier applications
Configuring CMS
Executing multi-server queries
Deploying an application for data-tier
Registering a data-tier application
Extracting a data-tier application
Upgrading a data-tier application

Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues

Establishing a methodology for troubleshooting
Diagnosing service-related issues
Diagnosing concurrency issues
Diagnosing login and connectivity issues
Diagnosing admin queries


Prices from £3000 (Guideline pricing). Promotional rates often available the further ahead you book. Contact us for quote.

Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....

Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Administering Microsoft SQL Server Databases.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award


We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL


Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number

Request information

Find out more about this Administering Microsoft SQL Server Databases course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here