Developing SQL Databases

PT26820
Summary
This course will help you to learn how to use SQL Server product features and tools related to developing a database.
Prerequisites
This course provides you with the knowledge and skills to develop a Microsoft SQL Server database. Pre-Requisites: Students should have familiar with
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
Duration
5 Days/Lecture & Lab
Audience
The targeted audience for this course is IT Professionals and Developers.
Topics
  • Introduction to Database Development
  • 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
  • Storing and Querying BLOBs and Text ::Documents in SQL Server
  • SQL Server Concurrency
  • Performance and Monitoring

Related Scheduled Courses