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: Developing Microsoft SQL Server Databases (20464)

This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.
SKU: 20464
GTIN: 20464
Manufacturer: Microsoft
*

Please select your required training start date:

*

Please select your desired location

£1,950.00 (GBP)

This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.

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 IT Professionals who want to become skilled on SQL Server 2014 product features and technologies for implementing a database.

At Course Completion:

After completing this course, students will be able to:

  • Introduce the entire SQL Server platform and its major tools. It will cover editions, versions, basics of network listeners, and concepts of services and service accounts.
  • Determine appropriate data types to be used when designing tables, convert data between data types, and create alias data types.
  • Be aware of good design practices regarding SQL Server tables and be able to create tables using T-SQL. (Note: partitioned tables are not covered).
  • Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints.
  • Determine appropriate single column and composite indexes strategies.
  • Create tables as heaps and tables with clustered indexes. Also consider the design of a table and suggest an appropriate structure.
  • Read and interpret details of common elements from execution plans.
  • Design effective non-clustered indexes.
  • Design and implement views
  • Design and implement stored procedures.
  • Work with table types, table valued parameters and use the MERGE statement to create stored procedures that update data warehouses.
  • Design and implement functions, both scalar and table-valued. (Also describe where they can lead to performance issues).
  • Perform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency.
  • Use both traditional T-SQL error handling code and structured exception handling.
  • Design and implement DML triggers
  • Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server.
  • Store XML data and schemas in SQL Server.
  • Perform basic queries on XML data in SQL Server.
  • Work with the GEOGRAPHY and GEOMETRY data types
  • Implement and query a full-text index.

(cited from Microsoft Learning website)