Developing SQL Databases

Product information

IT

Reviews

4 out of 5 stars

(no reviews)

Level: Certificate

Inquire Now

Entry Requirement

Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of Transact-SQL. Working knowledge of relational databases.

Course Content

  • Introduction to Database Development
  • Designing and Implementing Tables
  • Advanced Table Designs
  • Ensuring Data Integrity through Constraints
  • Introduction to Indexes
  • Designing Optimized Index Strategies
  • Columnstore Indexes
  • Designing and Implementing Views
  • Designing and Implementing Stored Procedures
  • Designing and Implementing User-Defined Functions
  • Responding to Data Manipulation via Triggers
  • Using In-Memory Tables
  • Implementing Managed Code in SQL Server
  • Storing and Querying XML Data in SQL Server
  • Storing and Querying Spatial Data in SQL Server

Inquire Now