close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

Course Information

Developing Microsoft SQL Server 2014 Databases Course Outline | M20464

This course includes the following modules:

Module 1: Introduction to Database Development

This module introduces database development and the key tasks that a database developer would typically perform.

Lessons:

  • Introduction to the SQL Server Platform
  • SQL Server Database Development Tasks

Lab: Introduction to Database Development

Module 2: Designing and Implementing Tables

This module explains how to design, create, and alter tables. It also focuses on working with schemas.

Lessons:

  • Designing Tables
  • Data Types
  • Working with Schemas
  • Creating and Altering Tables
  • Partitioning Data
  • Compressing Data

Lab: Designing and Implementing Tables

Module 3: Ensuring Data Integrity through Constraints

This module explains how to enforce data integrity, and implement domain integrity to maintain high quality data. In addition, it focuses on implementing Entity and Referential Integrity.

Lessons:

  • Enforcing Data Integrity
  • Implementing Domain Integrity
  • Implementing Entity and Referential Integrity

Lab: Ensuring Data Integrity through Constraints

Module 4: Introduction to Indexing

This module describes the concept of an index and discusses selectivity, density, and statistics. It covers appropriate data type choices and choices around composite index structures.

Lessons:

  • Core Indexing Concepts
  • Data Types and Indexes
  • Single Column and Composite Indexes

Lab: Implementing Indexes

Module 5: Designing Optimised Index Strategies

This module explains covering indexes and the INCLUDE clause as well as the use of padding, hints, and statistics. The module also covers the use of the Database Engine Tuning Advisor and index-related dynamic management views to assess indexing strategies.

Lessons:

  • Covering Indexes
  • Managing Indexes
  • Working with Execution Plans
  • Using the DTE

Lab: Designing Optimised Index Strategies

Module 6: Columnstore Indexes

This module explains columnstore indexes and how to use them to maximise the performance and scalability of database applications.

Lessons:

  • Introduction to Columnstore indexes
  • Creating Columnstore Indexes
  • Working with Columnstore Indexes

Lab: Using Columnstore Indexes

Module 7: Designing and Implementing Views

This module introduces Views, and explains how to create and manage Views. It also focuses on the performance consideration for Views.

Lessons:

  • Introduction to Views
  • Creating and Managing Views
  • Performance Considerations for Views

Lab: Designing and Implementing Views

Module 8: Designing and Implementing Stored Procedures

This module describes the potential advantages of the use of stored procedures along with guidelines on creating them.

Lessons:

  • Introduction to Stored Procedures
  • Working with Stored Procedures
  • Implementing Parameterised Stored Procedures
  • Controlling Execution Context

Lab: Designing and Implementing Stored Procedures

Module 9: Designing and Implementing User-Defined Functions

This module explains how to design and implement user-defined functions that enforce business rules or data consistency, and modify and maintain existing functions written by other developers.

Lessons:

  • Overview of Functions
  • Designing and Implementing Scalar Functions
  • Designing and Implementing Table-Valued Functions
  • Implementation Considerations for Functions
  • Alternatives to Functions

Lab: Designing and Implementing User-Defined Functions

Module 10: Responding to Data Manipulation via Triggers

This module explains what DML triggers are and how they enforce data integrity. It also focuses on the different types of triggers available, and how to define triggers in a database.

Lessons:

  • Designing DML Triggers
  • Implementing DML Triggers
  • Advanced Trigger Concepts

Lab: Responding to Data Manipulation via Triggers

Module 11: Using In-Memory Tables

This module covers the creation of in-memory tables and native stored procedures and discusses the advantages and disadvantages of using in-memory tables.

Lessons:

  • In-Memory Tables
  • Native Stored Procedures

Lab: In-Memory OLTP

Module 12: Implementing Managed Code in SQL Server 2014

This module explains how to use CLR integrated code to create user-defined database objects that are managed by the .NET Framework.

Lessons:

  • Introduction to SQL CLR Integration
  • Importing and Configuring Assemblies
  • Implementing SQL CLR Integration

Lab: Implementing Managed Code in SQL Server 2014

Module 13: Storing and Querying XML Data in SQL Server

This module introduces XML and shows how XML data can be stored within SQL Server and then queried, including queries written in a language called XQuery.

Lessons:

  • Introduction to XML and XML Schemas
  • Storing XML Data and Schemas in SQL Server
  • Implementing the XML Data Type
  • Using the T-SQL FOR XML Statement
  • Getting Started with XQuery

Lab: Storing and Querying XML Data in SQL Server 2014

Module 14: Working with SQL Server 2014 Spatial Data

This module introduces Spatial Data, and explains how to work with SQL Server Spatial Data Types.

Lessons:

  • Introduction to Spatial Data
  • Working with SQL Server Spatial Data Types
  • Using Spatial Data in Applications

Lab: Working with SQL Server Spatial Data

Module 15: Incorporating Data Files into Databases

Lessons:

  • Querying Data with Stored Procedures
  • Implementing FILESTREAM and File Tables
  • Searching Data Files

Lab: Implementing a Solution for Storing Data Files

Show moredowndown

Who should attend this Microsoft SQL Server Course?

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.

The secondary audiences for this course are individuals who are developers from other product platforms or previous versions of SQL Server looking to become skilled in the implementation of a SQL Server 2014 database.

This course is also intended for delegates preparing for the Microsoft Exam 70-464, Developing Microsoft SQL Server Databases.

Prerequisites

Before attending this course, delegates should possess or be able to demonstrate:

  • Knowledge of writing T-SQL queries
  • Knowledge of basic relational database concepts​

Developing Microsoft SQL Server 2014 Databases Training | M20464

This 5-day course is intended to teach delegates about SQL Server 2014, with a focus on logical table design, indexing, and query plans. It also explains how to create 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. Taking this course will also help delegates to prepare for Exam 70-464, Developing Microsoft SQL Server Databases.

This Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack course is fully accredited by Microsoft through the Microsoft Silver Partnership held by The Knowledge Academy.

After completing this course, delegates will be able to:

  • Introduce the entire SQL Server platform and its major tools. The course 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 (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
  • 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 and 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 a 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

Show moredowndown

Developing Microsoft SQL Server 2014 Databases Exam Information | M20464

Taking this course will help to prepare delegates for the Microsoft Exam 70-464, Developing Microsoft SQL Server Databases. The Knowledge Academy does not provide the exam and it must be taken separately. The examination will cover the following areas:

  • Implement database objects (30–35%)
  • Implement programming objects (15-20%)
  • Design database objects (25–30%)
  • Optimise and troubleshoot queries (25–30%)

What's included in this Microsoft SQL Server Course?

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

Show moredowndown

Why choose us

Ways to take this course

Our easy to use Virtual platform allows you to sit the course from home with a live instructor. You will follow the same schedule as the classroom course, and will be able to interact with the trainer and other delegates.

Our fully interactive online training platform is compatible across all devices and can be accessed from anywhere, at any time. All our online courses come with a standard 90 days access that can be extended upon request. Our expert trainers are constantly on hand to help you with any questions which may arise.

This is our most popular style of learning. We run courses in 1200 locations, across 200 countries in one of our hand-picked training venues, providing the all important ‘human touch’ which may be missed in other learning styles.

best_trainers

Highly experienced trainers

All our trainers are highly qualified, have 10+ years of real-world experience and will provide you with an engaging learning experience.

venues

State of the art training venues

We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible

small_classes

Small class sizes

We limit our class sizes to promote better discussion and ensuring everyone has a personalized experience

value_for_money

Great value for money

Get more bang for your buck! If you find your chosen course cheaper elsewhere, we’ll match it!

This is the same great training as our classroom learning but carried out at your own business premises. This is the perfect option for larger scale training requirements and means less time away from the office.

tailored_learning_experience

Tailored learning experience

Our courses can be adapted to meet your individual project or business requirements regardless of scope.

budget

Maximise your training budget

Cut unnecessary costs and focus your entire budget on what really matters, the training.

team_building

Team building opportunity

This gives your team a great opportunity to come together, bond, and discuss, which you may not get in a standard classroom setting.

monitor_progress

Monitor employees progress

Keep track of your employees’ progression and performance in your own workspace.

What our customers are saying

Frequently asked questions

FAQ's

Please arrive at the venue at 8:45am.
There are no formal prerequisites for attending this course.
Anyone who is interested in pursuing a career IT Professionals or Microsoft Technologies.
We are able to provide support via phone & email prior to attending, during and after the course.
Delegate pack consisting of course notes and exercises, Manual, Experienced Instructor, and Refreshments
This course is 5 day(s)
Once your booking has been placed and confirmed, you will receive an email which contains your course location, course overview, pre-course reading material (if required), course agenda and payment receipts
The price for Retired: Developing Microsoft SQL Server Databases M20464 certification in the United Kingdom starts from £3995
The Knowledge Academy is the Leading global training provider in the world for Retired: Developing Microsoft SQL Server Databases M20464.

Why choose us

icon

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

icon

Trusted & Approved

Microsoft Gold Learning Partner

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo

Looking for more information on Microsoft SQL Server Training?

backBack to course information

Get a custom course package

We may not have any package deals available including this course. If you enquire or give us a call on 01344203999 and speak to our training experts, we should be able to help you with your requirements.