Further Details
Key Instructional Focus and Objectives:
Create databases and database files.
Create data types and tables
Use XML-related features in Microsoft SQL Server 2005
Plan, create, and optimize indexes
Implement data integrity in Microsoft SQL Server 2005 databases by using constraints, triggers, and XML shemas
Implement views
Implement stored procedures and functions
Implement managed code in the database
Use service Broker to build a messaging-based solution
Select SQL Servers to support an organization’s business needs
Design a security strategy for a SQL Server 2005 solutions
Design a data modeling strategy
Design a transaction strategy for SQL Server solution
Design a Notification Services solution
Design a Service Broker solutions
Plan for source control, unit testing, and deployment to meeting organisaiton’s needs
Evaluate advance query techniques
Evaluate advanced XML techniques
Guide price
£750 |
