SQL Developers are responsible for developing SQL databases and writing applications to interface with SQL
databases. Development often consists of designing tables, storing procedures, views and functions.

  • 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: Column store 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
To Download Track Details, Click Here.

This course is presented by :

  • Development of high-quality database solutions
  • Develop, implement and optimize stored procedures and functions using T-SQL
  • Review and interpret ongoing business report requirements
  • Research required data
  • Build appropriate and useful reporting deliverables
  • Analyze existing SQL queries for performance improvements
  • Suggest new queries
  • Develop procedures and scripts for data migration
  • Provide timely scheduled management reporting
  • Investigate exceptions with regard to asset movements
Schedule Track