MCTS Training
Exam 70-442: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
Product Code:MS-70442

List Price

Sale Price

Quantity
$995.00 $795.00 $636.00
Product Options:
  Media Content
  

 
  Program Licensing
  

 

Untitled Document
Package Includes
This exam is a requirement for the following Certification(s) :

MCTS Training
  • 2 DVDs featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable Courseware
  • Exclusive LearningZone Live Mentor Click for Details (Value at $390) Help whenever you need it! Exclusive LearningZone - Why wait for email support? Chat Live with our Certified Instructors anytime around the clock (24x7)
  • Microsoft Authorized MeasureUp Exam Simulations
  • Proven technique- Actual Exam Secrets Review
  • Exclusive Exam Pass Guarantee
  • Free 1 Year Upgrade Policy
2005 database design developer mcitp microsoft server solution sql
Keith Nicholson

Keith Nicholson - SQL 2005 Trainer (MCT, MCDBA, MCSD.NET, MCSE Security, CEH, Security+)
Keith Nicholson is an engaging international speaker and trainer focusing on .NET development and database technologies. A year ago, Keith completed a multi-city tour and introduced the new features and benefits of .NET 2.0. Prior to founding KSDynamics, Keith architected and created some award-winning applications using .NET and SQL Server. He is the INETA Membership Manager for user groups in Arkansas, Oklahoma and North Texas. Keith has been a Microsoft MVP for over 2 years in .NET development (C#). He enjoys sharing his enthusiasm and helps others gain a love for technology and its uses.

Course Features:
  • Main Menu
    Move through hours of in-depth content - quickly and easily due to the efficient and organized structure.
  • PowerPoint
    Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...
  • Exclusive Learning Zone
    Train around the clock, around the world. Our certified online instructors are located at global support centers in the U.S., U.K., Australia, and Singapore to provide real-time answers to technology- and soft-skill-related questions 24x7. This means access to a live subject matter expert no matter where you are - day or night. This level of student/instructor interaction provides real-time training specific support and extends training beyond content and instructor-led solutions by providing flexibility to accommodate individual needs and schedules.
  • Controls
    Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.

  • Full Motion Video
    All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.
  • Study Guides
    Printable study guides for the entire course are available. This allows all material to be viewed, reviewed, and printed for viewing at a later date.
  • Review Exercises
    Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.
  • Resume
    All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you where.
  • Live Demonstrations
    Demonstrations are a way for the instructor to show and tell the user how to perform a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like.
  • Certificate of Completion
    Career Academy is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Career Academy Distance Education Certificate of Completion.
Course Outline TXT


Part 1
Course Introduction
Module 01 - Accessing Data with SQL Server 2005
Accessing Data with SQL Server 2005
Accessing Data Over The Years
Reaching The Server
MDAC vs. SQLNCLI
Demo - SQLNCLI
ADO.NET SqlClient
Native XML Web Services
Remote Data Calls
Data Access Layers
Data Pooling
Demo - Connection Pooling
CLR in SQL
SQLNCLI Objects
Managing SQL Server Objects
Module 01 Review
Module 02 - Exception Handling
Exception Handling
Exceptions, Bugs, Defects
Severity Levels
Patterns to Creating Exceptions
How to CATCH the Exception
Deadlocks
What Is Done With Errors?
Demo - Recognizing and Dealing with Errors
Even If Code is Good
Module 02 Review
Module 03 - Cursors and Sets
Cursors and Sets
Cursors Have Their Place...
...Yet, Not Usually in SQL Server
So, Why Do We Create Them?
Thoughts on Refactoring
A Good Use for Pivots
CTE's Make Life Easier
Server Side Cursors
Client Side Cursors
Demo - Data Connection
Module 03 Review
Module 04 - Multiple Active Result Sets
Multiple Active Result Sets
Destination - MARS
MARS Depends on Client Libraries
Snapshot Isolation in MARS
System Catalog Views
Demo - Snapshot Isolation
Interleaving
Data Manipulation Practices With MARS
Lessons on MARS
Module 04 Review
Module 05 - Store Your Cache for Databases Applications
Store Your Cache for Databases Applications
Demo - Cache
So Much Cache! Where to Begin?
Balance the Budget
DataSet Benefits
Denormalization is Not a Bad Word
Let Someone Else Hold Your Cache
Persist Data at Client
Module 05 Review
Module 06 - Serve Several Requests with a Scalable Architecture
Serve Several Requests with a Scalable Architecture
High Availability vs. Scalability
Scalability Up or Out
It’s All About Your Attitude
Spreading the Databases
Partition Tables & Indexes
Distributed Data Options
Not All Requests Are Alike
Demo - Set Operations
Demo - External Data
Designing the Middle Tier
Component Services
Service Oriented Architecture
Bypass the Physical Middle Man
Demo - CLR
Scaling Out Application Servers
Module 06 Review
Course Closure


Part 2
Course Introduction
Module 01 - Generating Measurements for SQL Server Database Performance
Generating Measurements for SQL Server Database Performance
What to Consider When Evaluating Performance
How to Focus on Queries
Demo - SQL Server Performance Tools
Highlights on Performance (and Resource) Monitor
Highlights on Profiler
Locks Are a Good Thing ... Usually
Demo - Query Performance
Module 01 Review
Module 02 - Solidify The Database
Solidify The Database
Microsoft Performance Optimization Model
Start with the Foundation
Demo - Schema Design
Model Theory’s Functional Dependencies
Normalize How?
You Might Denormalize Now
Generalization
Demo - Normalization
Module 02 Review
Module 03 - Enhance Queries for Better Results
Enhance Queries for Better Results
Generate a Good Plan
Execution Plan Flow No Aggregations
Execution Plan Flow With Aggregations
Demo - Efficient Queries
Thoughts on Subqueries
Recommendations for High Performing Queries
Demo - Subqueries
Module 03 Review
Module 04 - Cursor Acceptance and Avoidance
Cursor Acceptance and Avoidance
Plan for Result Set Benefits
Cursors Have Their Place...
Demo - Cursors
...Yet Not Usually in SQL Server
So, Why Do We Create Them?
Thoughts on Refactoring
A Good Use for Pivots
Common Table Expressions
CTE's Make Life Easier
Demo - Pivots and CTE's
Module 04 Review
Module 05 - Find the Right Data Quickly with the Best Indexes
Find the Right Data Quickly with the Best Indexes
Find the Right Data Quickly
Allocation Units are the Internals of SQL Server
Index Preparation Is Key
Clustered Index Thoughts
Non-Clustered Index Thoughts
Proactive Planning of Indexes
If The Cart is In Front...
Demo - Indexes
Module 05 Review
Module 06 - Too Many Cooks in the Pot?
Too Many Cooks in the Pot?
Dealing With Locks and Blocks
The Act of Science and Art
It’s All About Your Attitude
Demo - Locking
Exploring Data Phenomenon
Isolation Levels Options
Lock Escalation and Snapshot Options
Lock Conflicts
Demo - Isolation Levels
Module 06 Review
Course Closure

Search
 

Advanced Search


Cart
Your Cart Is Empty

Buy 2 Courses get and additional course free Free Training

Our reputation speaks for itself! See what others are saying... Testimonials

30-Day Money Back Satisfaction Guarantee

Computer Training

"Career Academy's Visual Studio.NET training videos are excellent. the extra information - web site references, tips, techniques, and other general historical information - really made the difference. The classroom like presentations are superb. I give this product a high endorsement. "

Roger Bundy
Chief Technology Officer,
Co-Founder
Southern California
.NET User Group
 www.SocalNETug.org