Managed Business & IT Training Solutions

MBIT Training Ltd

New Products

Free event - CompTIA Security+ primer

MBIT Training Ltd are pleased to offer a 'CompTIA Security+ primer'. This event features s...
£0.00 (GBP)

Implementing and Managing Windows 10 (20697-1 part of MCSA Windows 10)

This course provides students with the knowledge and skills required to install and config...
£1,950.00 (GBP)

Course: Supporting and Troubleshooting Windows 10 (10982)

This course is designed to provide students with the knowledge and skills required to supp...
£1,950.00 (GBP)

Introduction to Oracle 12c PL/SQL Programming

A Relational Database Management System (RDBMS) is a software system that allows you to cr...
£1,690.00 (GBP) £1,200.00 (GBP)

Oracle 11g Database Administration

This class will develop the key fundamental skills necessary to be an Oracle® DBA. Student...
£2,990.00 (GBP) £2,000.00 (GBP)

Microsoft Security Development Lifecycle (SDL)

The Security Development Lifecycle (SDL) is a software development process that helps deve...
£1,150.00 (GBP) £900.00 (GBP)

ITIL Foundation Certification - IT Service Management

The Information Technology Infrastructure Library (ITIL), is a set of detailed practices f...
£1,995.00 (GBP) £1,570.00 (GBP)

Course: Querying Microsoft SQL Server® 2014 (20461) part of MCSA SQL Server 2012 / 2014

This 5-day instructor led course provides students with the technical skills required to w...
£1,690.00 (GBP)

Course: Core Solutions of Skype for Business 2015 (20334 part of MCSE Communication)

This course provides students with the knowledge and skills that are required to plan, dep...
£1,790.00 (GBP)

Designing and Deploying Microsoft Exchange Server 2016 (20345-2 part of MCSE Messaging)

This course provides experienced Exchange Server administrators with the knowledge to desi...
£1,690.00 (GBP)

Administering Microsoft Exchange Server 2016 (20345-1 part of MCSE Messaging)

This 5-day instructor-led course teaches IT professionals how to administer and support Ex...
£1,690.00 (GBP)

Enabling and Managing Office 365 (20347 part of MCSA Office 365)

This is a 5-day instructor-led training (ILT) course that targets the needs of IT professi...
£1,990.00 (GBP) £1,690.00 (GBP)

Course: Developing SQL Data Models (20768 part of MCSA SQL 2016 BI)

This three-day instructor-led course is aimed at database professionals who fulfil a Busin...
£1,950.00 (GBP) £995.00 (GBP)

Course: Implementing a SQL Data Warehouse (20767 part of MCSA SQL 2016 BI)

This 5-day instructor led course describes how to implement a data warehouse platform to s...
£1,950.00 (GBP) £1,790.00 (GBP)

Course: Administering a SQL Database Infrastructure (20764 part of MCSA SQL 2016 DA)

This five-day instructor-led course provides students who administer and maintain SQL Serv...
£1,950.00 (GBP) £1,790.00 (GBP)

Course: Provisioning SQL Databases (20765 part of MCSA SQL 2016 DA)

This five day course is designed to teach students how to provision SQL Server databases b...
£1,950.00 (GBP)

Course: Developing SQL Databases (20762 part of MCSA SQL 2016)

This four-day instructor-led course provides students with the knowledge and skills to dev...
£1,950.00 (GBP) £1,290.00 (GBP)

Course: Querying Microsoft SQL Server (20761 part of MCSA SQL 2016)

The main purpose of this 3 day instructor led course is to give students a good understan...
£1,950.00 (GBP) £995.00 (GBP)

Identity with Windows Server 2016 (20742 part of MCSA Windows Server 2016)

This five-day instructor-led course teaches IT Pros how to deploy and configure Active Dir...
£1,790.00 (GBP)

Networking with Windows Server 2016 (20741 part of MCSA Windows Server 2016)

This 5-day classroom-based course provides the fundamental networking skills required to d...
£1,790.00 (GBP)

Installation, Storage, and Compute with Windows Server 2016 (20740 part of MCSA Windows Server 2016)

This five-day course is designed primarily for IT professionals who have some experience w...
£1,790.00 (GBP)

MCSA: Windows Server 2012

MCSA: Windows Server 2012 certification qualifies you for a position as a network or compu...
£3,275.00 (GBP) £2,695.00 (GBP)

Course: Automating Administration with Windows PowerShell (10961)

In this five day course you will learn to execute and monitor scripts more efficiently thr...
£1,550.00 (GBP)

Course: Automating Administration with Windows PowerShell 2.0 (10325)

This course 'Automating Administration with Windows PowerShell 2.0' provides students with...
£1,550.00 (GBP)

Course: Administering Microsoft SQL Server Databases (20462)

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.
SKU: 20462
GTIN: 20462
Manufacturer: Microsoft
*

Please select your required training start date:

*

Please select your desired location

£1,850.00 (GBP)

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.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Audience Profile:
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.

At Course Completion:

After completing this course, students will be able to:

  • Describe core database administration tasks and tools.
  • Install and configure SQL Server 2014.
  • Configure SQL Server databases and storage.
  • Plan and implement a backup strategy.
  • Restore databases from backups.
  • Import and export data.
  • Monitor SQL Server.
  • Trace SQL Server activity.
  • Manage SQL Server security.
  • Audit data access and encrypt data.
  • Perform ongoing database maintenance.
  • Automate SQL Server maintenance with SQL Server Agent Jobs.
  • Configure Database Mail, alerts and notifications.

(cited from Microsoft Learning website)