Admission
Candidates for this package typically work in an enterprise environment that has more than 500 personal computers and more than 100 servers and mostly create solutions for all types of enterprise issues. Candidates should have experience with the following:
•Writing transact SQL queries
•Programming the database
•Troubleshooting programming objects (for example, stored procedures, triggers, user-defined functions [UDFs], user-defined types [UDTs], and queries)
•Database performance tuning and optimization
•Designing databases at both the conceptual and logical levels
•Implementing databases at the physical level
•Might be involved in designing and troubleshooting the data access layer of the application
•Gathering business requirements
Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
Exam # |
Duration |
Language |
Level |
Type |
Classroom |
Code |
Fees |
-- |
40 |
English |
Professional |
Course |
Classroom |
Cs234 |
0 LE |
Description :
Objectives :
-
Designing a Database Strategy
-
Designing Database Tables
-
Designing Programming Objects
-
Designing a Transaction and Concurrency Strategy
-
Designing an XML Strategy
-
Designing Queries for Performance
-
Designing a Database for Optimal Performance
Topics :
Designing a Database Strategy
-
Identify which SQL Server components to use to support business requirements.
Design a database model.
-
Design a data model by using the Entity Framework.
-
Design an application strategy to support security.
-
Design a solution by using Service Broker.
-
Design a Full-Text Search strategy.
Designing Database Tables
-
Identify the appropriate usage of new data types
-
Design tables.
-
Design data integrity.
Designing Programming Objects
-
Design T-SQL stored procedures.
-
Design views.
-
Design T-SQL table-valued and scalar functions.
-
Design Common Language Runtime (CLR) table-valued and scalar functions.
-
Design CLR stored procedures, aggregates, and types.
-
Evaluate special programming constructs.
Designing a Transaction and Concurrency Strategy
-
Design the locking granularity level.
-
Design for implicit and explicit transactions.
-
Design for concurrency.
Designing an XML Strategy
-
Design XML storage.
-
Design a strategy to query and modify XML data.
-
Design a query strategy by using FOR XML.
-
Design a strategy to transform XML into relational data.
Designing Queries for Performance
-
Optimize and tune queries.
-
Analyze execution plans
-
Evaluate the use of row-based operations vs. set-based operations.
Designing a Database for Optimal Performance
-
Optimize indexing strategies.
-
Design scalable database solutions.
-
Resolve performance problems by using plan guides.
-
Design a table and index compression strategy.
-
Design a table and index partitioning strategy.
Recommended Knowledge :
Recommended Course(s) :
MCTS: SQL Server 2008, Database Development
Training Materials :
Microsoft Official Courseware (MOC)
Labs :
This course includes several labs to ensure you will gain the targeted skills and experience.
Credential :
Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008: counts as credit toward the following certification(s):
•Microsoft Certified IT Professional (MCITP): Database Developer 2008
Category :
DataBase
The Instructor: