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.
هذه الدورة مقدمة من :
Microsoft
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
