SQL Server TrackCourse 2 of 7

Microsoft SQL Server Database Development

This hands-on training covers everything from fundamental database concepts to advanced development techniques, including writing efficient queries, designing robust tables, implementing stored procedures and functions, managing concurrency, and working with modern data types like XML, JSON, and spatial data.

34 hours · 22 sessionsCAD $519Beginner to AdvancedHands-On Learning
Enrol in This Course

What you'll learn

  • Understand core database concepts and SQL Server architecture
  • Design and implement efficient tables, views, functions, and stored procedures
  • Handle errors and ensure data integrity using constraints and triggers
  • Perform complex data manipulation using MERGE and table-valued parameters
  • Develop highly concurrent applications with proper transaction and locking management

Prerequisites

SQL Server Querying Data or equivalent T-SQL experience.

Part of the SQL Server Track

Master Microsoft's enterprise database platform.

7 courses · approx. 20–28 weeksBeginner to Advanced
View full track

Course Modules

18 modules · instructor-led, hands-on delivery

01Introduction to Database Development
02Working with Data Types
03Designing and Implementing Tables
04Designing and Implementing Views
05Designing and Implementing User-Defined Functions
06Designing and Implementing Stored Procedures
07Handling Errors in T-SQL Code
08Ensuring Data Integrity through Constraints
09Responding to Data Manipulation via Triggers
10Merging Data and Passing Tables
11Creating Highly Concurrent Applications
12Using In-Memory Tables
13Reading Execution Plans
14Implementing Managed Code in SQL Server
15Storing and Querying XML and JSON Data
16Working with Spatial Data in SQL Server
17Working with Full-Text Indexes and Queries
18Working with Service Broker

Other courses in this track

01
Microsoft SQL Server Querying Data16 hours · 11 sessionsCAD $275
02

Microsoft SQL Server Database Development(current)

34 hours · 22 sessionsCAD $519
03
Microsoft SQL Server Database Administration28 hours · 19 sessionsCAD $427
04
05
Microsoft SQL Server Security and Protection13 hours · 9 sessionsCAD $325

Ready to Enrol?

CAD $519 · Get in touch and we'll get you started in Microsoft SQL Server Database Development.

Send an Enquiry