Loading Course Schedule...
PT26820
Training 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.
Course 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