Course details
Introduction
This four-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.
Course Content
- Module 1: Introduction to Database Development
- Module 2: Designing and Implementing Tables
- Module 3: Advanced Table Designs
- Module 4: Ensuring Data Integrity through Constraints
- Module 5: Introduction to Indexes
- Module 6: Designing Optimized Index Strategies
- Module 7: Columnstore Indexes
- Module 8: Designing and Implementing Views
- Module 9: Designing and Implementing Stored Procedures
- Module 10: Designing and Implementing User-Defined Functions
- Module 11: Responding to Data Manipulation via Triggers
- Module 12: Using In-Memory Tables
- Module 13: Implementing Managed Code in SQL Server
- Module 14: Storing and Querying XML Data in SQL Server
- Module 15: Working with SQL Server Spatial Data
- Module 16: Storing and Querying Blobs and Text Documents in SQL Server
About Torque IT
About Torque IT
With over 20 years of experience, Torque IT is recognised throughout the globe as the principal InformationCommunication Technology (ICT) training solutions provider to blue chip companies and the public sector.
The Torque IT business is based on a culture of customer service and an unwavering commitment to always providing the highest quality product and service available. Torque IT offers completely customizable training and enablement solutions that are tailored to your specific requirements whilst retaining the quality and credibility associated with standard vendor authorized training courses.
See all Torque IT courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft 365 Fundamentals (MS-900) Practice Exam Testprep TrainingUSD 16Duration: 1 To 3 Months
- Complete Guide to Microsoft Power Pages Course LineUSD 24Duration: Upto 4 Hours