Press esc to close
Press esc to close
Fill out your contact details below and our training experts will be in touch.
If you wish to make any changes to your course, please log a ticket and choose the category ‘booking change’
Back to Course Information
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Lab: Working with SQL Server Spatial Data
Module 15: Incorporating Data Files into Databases
Lab: Implementing a Solution for Storing Data Files
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.
Before attending this course, delegates should possess or be able to demonstrate:
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:
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:
Why choose us
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.
All our trainers are highly qualified, have 10+ years of real-world experience and will provide you with an engaging learning experience.
We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible
We limit our class sizes to promote better discussion and ensuring everyone has a personalized experience
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.
Our courses can be adapted to meet your individual project or business requirements regardless of scope.
Cut unnecessary costs and focus your entire budget on what really matters, the training.
This gives your team a great opportunity to come together, bond, and discuss, which you may not get in a standard classroom setting.
Keep track of your employees’ progression and performance in your own workspace.
Course was run very smoothly, Richard our trainer was extremely knowledgeable and delivered the course in a succinct fashion with a twist of humour thrown in.
The course was great and the so was the trainer - brilliantly delivered and I would certainly recommend this course to my colleagues. Thanks to Richard for a great course and delivering it a tough environment virtually.
Richard was very knowledgeable and explained well
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
Microsoft Gold Learning Partner
Flexible delivery methods are available depending on your learning style.
Resources are included for a comprehensive learning experience.
"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