This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.

Who Should Attend

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

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: Storing and Querying Spatial Data in SQL Server
  • Module 16: Storing and Querying BLOBs and Text Documents in SQL Server
  • Module 17: SQL Server Concurrency
  • Module 18: Performance and Monitoring

Frequently Asked Questions

"Developing SQL Databases - Course 20762-C Course" trainings are given in ("Group - One to one") two different  ways.
The one-to-one tuition fee is 1,490 $.

"Developing SQL Databases - Course 20762-C Course" trainings are given in two different ways.

The tuition fee as a group is 1,350 $. To create a group, you must be at least  3 people.
The one-to-one tuition fee is 1,490 $.

Our "Developing SQL Databases - Course 20762-C Course" trainings are one-to-one 5 days,

Our "Developing SQL Databases - Course 20762-C Course" trainings are group 3 days,
 

 

Exam & Certification

Participation Certificate

All trainees who participate in training will have an AcademyTech participation certificate.

Exam & Certification

Reviews

Recommendations by our happy graduates.

Request more information for
"Developing SQL Databases - Course 20762-C Course"

Prefered Mode of Contact