Administering Microsoft SQL Server 2014 Databases

Duration: 
5 days
Codes: 
20462 SQL
Versions: 
2014

Overview

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Audience

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.

Skills Gained

  • Plan and install SQL Server.
  • Describe system databases, the physical structure of databases, and the most common configuration options related to them.
  • Explain the concept of the transaction log and the SQL Server recovery models and implement different backup strategies that are available with SQL Server.
  • Back up SQL Server databases.
  • Restore SQL Server databases.
  • Import and export data by using wizards, the bulk copy utility, and data-tier applications.
  • Work with SQL Server security models, logins, users, and contained databases.
  • Work with server roles and database roles.
  • Use permissions to secure resources.
  • Use SQL Server audit and Transparent Data Encryption.
  • Work with SQL Server Agent to configure and execute jobs.
  • Implement SQL Server Agent security, proxy accounts, and credentials.
  • Configure database mail, alerts, and notifications.
  • Create database maintenance plans.
  • Use SQL Server Profiler, SQL Trace, and Distributed Relay.
  • Use Distributed Management Views and configure data collection.

Prerequisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

Click a Date to Enroll.

Course Location Days Cost Date
Suffolk
Ipswich5 7499 £7499 19-01-10
Dorset
Poole5 7499 £7499 19-01-10
Hampshire
Portsmouth5 7499 £7499 19-01-10
Surrey
Guildford5 7499 £7499 19-01-10
Essex
Chelmsford5 7499 £7499 19-01-10
Warwickshire
Warwick5 7499 £7499 19-01-10
Hertfordshire
Watford5 7499 £7499 19-01-10
London
London5 2445 £2445 19-01-10
Tyne and Wear
Newcastle5 2310 £2310 19-01-10
Edinburgh
Edinburgh5 2310 £2310 19-01-10
Dorset
Fleet5 7499 £7499 19-01-10
Manchester
Manchester5 2795 £2795 19-01-10
Leicestershire
Leicester5 7499 £7499 19-01-10
London
London5 2795 £2795 19-01-10
Northern Ireland
Belfast5 5495 £5495 19-01-10
Wiltshire
Swindon5 7499 £7499 19-01-10
Wallisellen
Wallisellen5 4280 £4280 19-01-10
London
London5 2310 £2310 19-01-10
Manchester
Manchester5 2310 £2310 19-01-10
Kent
Canterbury5 7499 £7499 19-01-10
Glamorgan
Cardiff5 5495 £5495 19-01-10
Surrey
Guildford5 7499 £7499 19-01-10
Suffolk
Ipswich5 7499 £7499 19-01-10
Dorset
Poole5 7499 £7499 19-01-10
Hampshire
Portsmouth5 7499 £7499 19-01-10
Manchester
Stockport5 1945 £1945 19-01-10
Midlands
Birmingham5 2795 £2795 19-01-10
Dorset
Bournemouth5 7499 £7499 19-01-10
Wiltshire
Swansea5 7499 £7499 19-01-10
Tyne and Wear
Newcastle upon Tyne5 2310 £2310 19-01-10
Edinburgh
Edinburgh5 2310 £2310 19-01-10
Devon
Exeter5 2310 £2310 19-01-10
Dorset
Fleet5 7499 £7499 19-01-10
Buckinghamshire
Milton Keynes5 2795 £2795 19-01-10
Midlands
Northampton5 7499 £7499 19-01-10
Oxfordshire
Oxford5 7499 £7499 19-01-10
Devon
Plymouth5 7499 £7499 19-01-10
London
London5 2795 £2795 19-01-10
London
London5 1945 £1945 19-01-10
Manchester
Manchester5 2310 £2310 19-01-10
Kent
Canterbury5 7499 £7499 19-01-10
Essex
Chelmsford5 7499 £7499 19-01-10
Lancashire
Chorley5 7499 £7499 19-01-10
Midlands
Coventry5 2310 £2310 19-01-10
Cheshire
Crewe5 7499 £7499 19-01-10
Midlands
Birmingham5 2310 £2310 19-01-10
Dorset
Bournemouth5 7499 £7499 19-01-10
Bristol
Bristol5 2310 £2310 19-01-10
Wiltshire
Swansea5 7499 £7499 19-01-10
Wiltshire
Swindon5 7499 £7499 19-01-10
Warwickshire
Warwick5 7499 £7499 19-01-10
Hertfordshire
Watford5 7499 £7499 19-01-10
London
London5 2310 £2310 19-01-10
Yorkshire
Leeds5 2795 £2795 19-01-10
Nottinghamshire
Nottingham5 5495 £5495 19-01-10
Oxfordshire
Oxford5 7499 £7499 19-01-10
Devon
Plymouth5 7499 £7499 19-01-10
Leicestershire
Leicester5 7499 £7499 19-01-10
Aberdeenshire
Aberdeen5 5495 £5495 19-01-10
Yorkshire
Leeds5 2310 £2310 19-01-10
Midlands
Northampton5 7499 £7499 19-01-10
Lancashire
Chorley5 7499 £7499 19-01-10
Cheshire
Crewe5 7499 £7499 19-01-10
Dublin
Dublin5 5495 £5495 19-01-10