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

سجل الأن