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 is a 5 day course, with a total of 18 modules. Each day consists of expert instructor led training and the Developing SQL Database exam (Exam 70-762) is included as part of the course price. Upon completing the course, delegates may progress onto the Developing SQL Databases exam.
Module 1: Introduction to Database Development
Introduction to the SQL Server Platform
SQL Server Database Development Tasks
Module 2: Designing and Implementing Tables
Working with Schemas
Creating and Altering Tables
Lab: Designing and Implementing Tables
Module 3: Advanced Table Designs
Lab: Using Advanced Table Designs
Module 4: Ensuring Data Integrity through Constraints
Enforcing Data Integrity
Implementing Data Domain Integrity
Implementing Entity and Referential Integrity
Lab: Using Data Integrity Through Constraints
Module 5: Introduction to Indexes
Core Indexing Concepts
Data Types and Indexes
Heaps, Clustered, and Nonclustered Indexes
Single Column and Composite Indexes
Lab: Implementing Indexes
Module 6: Designing Optimized Index Strategies
The Database Engine Tuning Advisor
Lab: Optimizing Indexes
Module 7: Columnstore Indexes
Introduction to Columnstore Indexes
Creating Columnstore Indexes
Working with Columnstore Indexes
Lab: Using Columnstore Indexes
Module 8: Designing and Implementing Views
Introduction to Views
Creating and Managing Views
Performance Considerations for Views
Lab: Designing and Implementing Views
Module 9: Designing and Implementing Stored Procedures
Introduction to Stored Procedures
Working with Stored Procedures
Implementing Parameterized Stored Procedures
Controlling Execution Context
Lab: Designing and Implementing Stored Procedures
Module 10: Designing and Implementing User-Defined Functions
Overview of Functions
Designing and Implementing Scalar Functions
Designing and Implementing Table-Valued Functions
Considerations for Implementing Functions
Alternatives to Functions
Lab: Designing and Implementing User-Defined Functions
Module 11: Responding to Data Manipulation via Triggers
Designing DML Triggers
Implementing DML Triggers
Advanced Trigger Concepts
Lab: Responding to Data Manipulation by Using Triggers
Module 12: Using In-Memory Tables
Natively Compiled Stored Procedures
Lab: Using In-Memory Database Capabilities
Module 13: Implementing Managed Code in SQL Server
Introduction to CLR Integration in SQL Server
Implementing and Publishing CLR Assemblies
Lab: Implementing Managed Code in SQL Server
Module 14: Storing and Querying XML Data in SQL Server
Introduction to XML and XML Schemas
Storing XML Data and Schemas in SQL Server
Implementing the XML Data Type
Using the Transact-SQL FOR XML Statement
Getting Started with XQuery
Lab: Storing and Querying XML Data in SQL Server
Module 15: Storing and Querying Spatial Data in SQL Server
Introduction to Spatial Data
Working with SQL Server Spatial Data Types
Using Spatial Data in Applications
Lab: Working with SQL Server Spatial Data
Module 16: Storing and Querying BLOBs and Text Documents in SQL Server
Considerations for BLOB Data
Working with FILESTREAM
Using Full-Text Search
Lab: Storing and Querying BLOBs and Text Documents in SQL Server
Module 17: SQL Server Concurrency
Concurrency and Transactions
Lab: SQL Server Concurrency
Module 18: Performance and Monitoring
Working with extended Events
Live Query Statistics
Optimize Database File Configuration
Lab: Monitoring, Tracing, and Baselining
IT professionals who wish to become proficient in SQL Server 2016 product features and technologies when implementing a database. IT developers with an interest in the SQL Server 2016, may also be suited to this course.
Delegates wishing to attend this course are expected to have:
Basic knowledge of the Microsoft Windows operating system and its core functionality
Working knowledge of Transact-SQL
Working knowledge of relational databases
This 5 day Microsoft course is tailored to delegates who wish to develop the knowledge and skills required to develop a Microsoft SQL Server 2016 database. This course shall cover all the necessary tools and techniques required to develop a database.
Delegates who have completed the course are expected to be able to:
Design and Implement Tables
Describe advanced table designs
Ensure Data Integrity through Constraints
Describe indexes, including Optimized and Columnstore indexes
Design and Implement Views
Design and Implement Stored Procedures
Design and Implement User Defined Functions
Respond to data manipulation using triggers
Design and Implement In-Memory Tables
Implement Managed Code in SQL Server
Store and Query XML Data
Work with Spatial Data
Store and Query Blobs and Text Documents
We are fully accredited by Microsoft, for our Developing SQL Databases course and we are a Silver Partner.
Once the M20762 course has been completed the 70-762 exam can be taken. Developing SQL Databases exam information is protected as part of a Non-Disclosure Agreement. Therefore information on the exam format is not available. However information regarding how the exam content is divided is available and is as follows:
Design and implement database objects (25-30%)
Manage database concurrency (25-30%)
Implement programmability objects (20-25%)
Optimise database objects and SQL infrastructure (20-25%)
The percentages indicate the weighting of each of the major topic areas covered in the exam.
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 Silver 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
"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."
Diane Gray, Shell
Retired: Developing SQL Databases M20762CAD6195
Querying Data with Transact-SQL M20761CAD6195
Total without package: CAD12390
Package price: CAD7395 (Save CAD4995)