MCITP Certified: Database developers design and implement relational database models (logical and physical) and database storage objects. They also program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or the CLR. They retrieve or modify data using SQL queries or tune and optimize queries. Database developers are typically employed by mid-sized to large-sized organizations.
This course provides you with all you need to pass your Exam 70-442: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005. This course will give you the ability to build efficient, effective enterprise Microsoft SQL Server 2005 database solutions.
Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) is the premier certification for database designers and developers. This credential demonstrates that you can design a secure, stable, enterprise database solution by using Microsoft SQL Server 2005. Our 70-442 course teaches database developers working in enterprise environments to design server-side database solutions that utilize SQL Server 2005 services, how to design databases solutions that meet organizational data access needs and how to analyze and address performance bottlenecks that occur within their Microsoft® SQL Server™ 2005 database solutions. Computer Based Training is training that can be implemented from your desktop or laptop computer; of late this has been expanded to include having training material viewable on your Video IPod as well. Our courseware is one of the very best, easy to use, and provides a highly satisfying learning experience.
MCIPT: Database Developer
NOTE: All prices (above) are stated in Great British Pounds (£) and EXCLUDE any external examination fees. All prices are +VAT for EU sales
To view the total price including VAT, simply click the "buy" and "checkout" buttons, then select your country.
Overview of the Built-in SQL Server Services Evaluating When to Use the New SQL Server Services Evaluating the Use of Database Engine Enhancements
Overview of Authentication Modes and Authorization Strategies
Designing a Security Strategy for Components of a SQL Server 2005 Solution Designing Objects to Manage Application Access Creating an Auditing Strategy Managing Multiple Development Teams Using the SQL Server 2005 Security Features
Defining Standards for Storing XML Data in a Solution Designing a Database Solution Schema Designing a Scale-Out Strategy
Defining Data Behavior Requirements Defining Isolation Levels Designing a Resilient Transaction Strategy
Defining Event Data Designing a Subscription Strategy Designing a Notification Strategy Designing a Notification Delivery Strategy
Designing a Service Broker Solution Architecture Designing Service Broker Data Flow Designing Service Broker Solution Availability
Designing a Source Control Strategy Designing a Unit Test Plan Creating a Performance Baseline and Benchmarking Strategy Designing a Deployment Strategy
Evaluating Common Table Expressions Evaluating Pivot Queries Evaluating Ranking Queries Overview of XQuery Overview of Strategies for Converting Data Between XML and Relational Formats
Introduction to Data Access Technologies Choosing Technologies for Accessing Data Building a Data Access Layer Designing Data Access from SQL Common Language Runtime (CLR) Objects Available Data Object Models for Administering SQL Server
Exception Types and Their Purposes Detecting Exceptions Managing Exceptions
Common Scenarios for Row-Based vs. Set-Based Operations Selecting Appropriate Server-Side Cursors Selecting Appropriate Client-Side Cursors
Introduction to MARS Designing Query Strategies for Multiple Reads Designing Query Strategies for Mixing Reads and Writes in the Same Connection Concurrency Considerations When Using MARS
Why Caching Is Important Data and Query Caching in SQL Server 2005 Using Caching Technologies Outside of SQL Server Custom Caching Techniques
Identifying the Need to Scale Scaling Database Applications to Avoid Concurrency Contention Scaling SQL Server Database Systems Scaling Database Applications Using a Service-Oriented Architecture Improving Availability and Scalability by Scaling Out Front-End Systems
Importance of Benchmarking Key Measures for Query Performance: Sysmon Key Measures for Query Performance: Profiler Guidelines for Identifying Locking and Blocking
Performance Optimization Model Schema Optimization Strategy: Keys Schema Optimization Strategy: Responsible Denormalization Schema Optimization Strategy: Generalization
Performance Optimization Model: Queries What Is Query Logical Flow? Considerations for Using Subqueries
Performance Optimization Model: Query-Set-based solutions Five Steps to Building a Cursor Strategies for Refactoring Cursors
Performance Optimization Model: Indexes Considerations for Using Indexes Best Uses of the Clustered Index Best Practices for Non-Clustered Index Design How to Document an Indexing Strategy
Performance Optimization Model: Locking and Blocking Multimedia - "How to Use Efficient Queries to Reduce Locking and Blocking" Strategies to Reduce Locking and Blocking.
After Effects CS3 Training After Effects CS4 Training Encore CS3 Training Premiere CS3 Training Premiere CS4 Training Soundbooth CS3 Training Soundbooth CS4 Training