Designing Database Solutions for Microsoft SQL Server (M20465)

Course summary
5 days
Company-Specific / In-House

Designing Database Solutions for Microsoft SQL Server (M20465)

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

Map out a database server deployment suitable to a given business environment
Construct a comprehensive schema tailored to the business requirement
Create a robust database system appropriate to the business requirement
Appreciate where a binary large object data might be used
Optimize performance through indexes
Have a thorough overview of the security implications for the database solutions
Design a series of policies to manage their SQL server architecture
Design a regimen for monitoring server health
Using the SQL Server Utility to monitor server health
Design and deploy a range of backup solutions
Understand many methods of multi-server maintenance and automation
Use PowerShell for remote management
Optimize a replication strategy for a given business scenario
Design a solution that builds in high availability

Suitability - Who should attend?

This course is designed for database adminstrators and database professionals who are looking to plan major data solutions. They have responsibility for the planning and design of database structure, storage, objects, and servers. They will also be responsible for the ecosystem where the data solution is hosted.

Training Course Content

Module 1: Designing a Database Server Infrastructure

Overview of database server infrastructure
How to plan an effective infrastructure
Analyzing requirements to optimize for capacity
What to consider when consolidating database servers
Best practice for migrating resources

Module 2: Designing a Logical Database Schema

Key relational database design principles
How to use a schema
Best practice in designing tables
Denormalizing a database

Module 3: Designing a Physical Database Implementation

Working with files and filegroups
How to partition data
How to compress data

Module 4: Designing a Database Solution for BLOB Data

When to use BLOBs (Binary Large OBjects)
How to use FileStream with BLOBs
Considerations for full-text search

Module 5: Tuning Database Performance

Best use of indexes to optimize query performance
Designing and developing query plans
Tools and techniques for monitoring performance, system health and tuning

Module 6: Designing Database Security

Configuring security at a server level
Configuring security at a database level
Configuring transparent database encryption
How to audit activity on the database

Module 7: Using Policy-Based Management

An overview of policy-based management
How to design and create policy-based management

Module 8: Monitoring Server Health

An overview of health monitoring
Tools available for health monitoring
How the SQL Server Utility can help

Module 9: Designing a Database Backup Solution

SQL Server Backup and Restore
Planning and implementing a backup and recovery strategy

Module 10: Automating Multi-Server Maintenance

Introduction to automating maintenance
How to manage multiple servers

Module 11: Managing SQL Server with PowerShell

Overview of PowerShell

Module 12: Replicating Data

Overview of SQL Server replication
Designing a replication strategy

Module 13: Designing for High Availability

How to design for high availability
The advantages of AlwaysOn Availability groups


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 Designing Database Solutions for Microsoft SQL Server (M20465).

  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 Designing Database Solutions for Microsoft SQL Server (M20465) 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