If you have databases to manage, backup, restore and control access to, then this is the course you need.

You don't need any specific knowledge of SQL Server to attend this course, but a general knowledge of computers, relational databases and their design as well as a working knowledge of Transact SQL is required.

• Introduction to SQL Server - The platform, tools and SQL Server services
• Preparing for SQL Server - Architecture overview, resource planning and testing
• Installing SQL Server - Planning the installation, installing, upgrading and automating
• Working with Databases - Files, file groups and moving databases
• Recovery Models - Strategies available to backup and restore databases that match business needs
• Backup Databases - Backing up, managing backups and backup options
• Restore Databases - Restoring databases, including point in time recovery
• Import and Export Databases - Bulk operations to transfer data to and from a SQL database
• Authentication and Authorisation - Connections, logins and authorisation across servers
• Server and Database Roles - Working with server and fixed database roles

Introduction to SQL Server 2012 and its Toolset

• Introduction to the SQL Server Platform
• Working with SQL Server Tools
• Configuring SQL Server Services

 Preparing Systems for SQL Server 2012

• Overview of SQL Server Architecture
• Planning Server Resource Requirements
• Pre-installation Testing for SQL Server

 Installing and Configuring SQL Server 2012

• Preparing to Install SQL Server
• Installing SQL Server
• Upgrading and Automating Installation

 Working with Databases

• Overview of SQL Server Databases
• Working with Files and File Groups
• Moving Database Files

 Understanding SQL Server 2012 Recovery Models

• Backup Strategies
• Understanding SQL Server Transaction Logging
• Planning a SQL Server Backup Strategy

 Backup of SQL Server 2012 Databases

• Backing up Databases and Transaction Logs
• Managing Database Backups
• Working with Backup Options

 Restoring SQL Server 2012 Databases

• Understanding the Restore Process
• Restoring Databases
• Working with Point-in-time recovery
• Restoring System Databases and Individual Files

 Importing and Exporting Data

• Transferring Data To/From SQL Server
• Importing & Exporting Table Data
• Inserting Data in Bulk

 Authenticating and Authorizing Users

• Authenticating Connections to SQL Server
• Authorizing Logins to Access Databases
• Authorization Across Servers

 Assigning Server and Database Roles

• Working with Server Roles
• Working with Fixed Database Roles

The course runs from 9:30am through to 4:30pm on all three days. Refreshments are available from 9am. 

We provide:

• Full course material
• Certificate of attendance
• 90 days post course support
• Note pad and pen
• Polos!

Also includes:

• Free on-site parking
• Refreshments throughout the day
• Lunch at a local restaurant
• Free WiFi

Our Norwich on-site parking (NR3 1UB) is free and situated 5 minutes walk along the river to our training centre at St James Mill. If you arrive by train it is about 20 minutes on the Riverside walk or a short taxi ride to get to us. View full directions for Norwich and all our other venues.

You will learn in a relaxed environment with a small group of up to 8 people. A specialist tutor will guide and encourage you through all the learning necessary to develop your skills and questions are always welcome.