This course is targeted at the professional level SQL Server 2008 Database Developer.
After the completion of this course the candidates will be able to implement tables and views, implement programmable objects, work with query fundamentals and apply additional query techniques in SQL Server 2008 R2
They will also learn how to work with additional SQL Server 2008 R2 components, XML data and gather performance information and perform query optimization.
Then the course will move on to designing conceptual and logical database design, designing strategies for database access, optimal query performance and transactions and concurrency.
After completing this course, students will be able to:
- Design a database design strategy
- Design a database for optimal performance
- Design security for a database
- Design programming objects
- Design queries for performance
- Design a transaction and concurrency strategy
- Design an XML strategy
|
Database Developer: SQL Server 2008 |
|||||
|
Course# |
Course Contents |
Exam# |
Exam |
Regular Track (days) |
Fast Track (days) |
|
2778 |
Writing Queries Using Microsoft SQL Server 2008 Transact-SQL |
70-433 |
TS: Microsoft SQL Server 2008, Database Development |
3 |
2 |
|
6232B |
Implementing a Microsoft SQL Server 2008 R2 Database |
6 |
4 |
||
|
50401 |
Designing and Optimizing Database Solutions with Microsoft SQL Server 2008 |
70-451 |
PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008 |
5 |
3 |
|
Total duration |
14 |
9 |
|||
Prerequisite:
· Working knowledge of relational databases (database design skills).
· Core Windows Server skills.
· Basic programming language.