Untitled Document

Maintaining a Microsoft SQL Server 2005 Database

List Price:	Special Price:
~~$595.00~~

The Technology Specialist certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise in their specialized technologies.

This video-based course provides students with the knowledge and skills to design databases for Microsoft SQL ServerT 2005 using business requirements to guide their decisions (beyond structured third normal form [3NF] modeling techniques). Students will also learn to incorporate security requirements throughout their design.

This course is a requirement for the following Exam(s) :

Exam 70–441 : Designing Database Solutions by Using Microsoft SQL Server 2005 Open License 6.0

Package Includes:

6 Sessions Featuring live instructor-led classroom sessions with full audio, video and demonstration components
Printable courseware
Sample codes
Exclusive LearningZone Live Mentor (Value at $195)
Help Whenever you need it! Exclusive LearningZone - Chat Live with our Certified Instructors anytime around the clock (7x24)
Focused on practical solutions to real-world development problems
Free 1 Year Upgrade Policy

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
Our Training is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Distance Education Certificate of Completion.

Module 1 - Steps to Designing Databases for SQL Server 2005

Steps to Designing Databases for SQL Server 2005
Steps to Designing Stable Databases
Find a Plan and Stick To It
Know the Core Scope
Seek Knowledge
Create a Contract
Consider History..
Upgrade and Integrate
Demo - Requirements Document
A Picture Is Worth…
ORM
ER
UML
Decision Making
Demo - Modeling
Review

Module 2 - Logical Levels of Modeling

Logical Levels of Modeling
Move from Conceptual to Logical
Focus On Real World Dependencies
Primary Key: Substitutes or Real Attributes
Move Toward Logical ER
Model Theorys Functional Dependencies
Demo - Generate a Logical ER Form
Why Normalize?
Normalize How?
Demo - Normalization Examples
OLAP Designs
Creating the Fact Table
Creating Dimensions
Refactor a Logical Model
Review

Module 3 - Physical Levels of Modeling

Physical Levels of Modeling
Naming Conventions for Identifiers
Additional Naming Conventions for Identifiers
Demo - Showing Identifiers at Work
RDMS Specific Data Type Decisions
CLR Thoughts
XML Thoughts
How to Store – Character Type vs. New XML Type
Computed Columns Thoughts
Thoughts on Column Constraints
Thoughts on Table Constraints
New Data Definition Triggers
Demo - Creating DDL Triggers
“Who Are You? What Do You Want?”
Protect the Data
Audits
Configuration Settings
Improve I/O Performance
Database Options
Sample Your Design
Extract-Transform-Load
Review

Module 4 - Performance Considerations to Make During Design

Performance Considerations to Make During Design
Clustered Index Thoughts
Non-Clustered Index Thoughts
Thoughts on XML Data Indexes
Demo - Defining XML Indexes
Thoughts on Computed Column Indexing
Why Use Views
Thoughts on Indexed Views
Demo - Balancing Indexes with Cost
Benefit with Partition Tables
Thoughts on Summary Tables
You Might Denormalize Now
Thoughts on Snapshot Isolation
Tempdb Does a Lot of Work
Demo - Evaluating Tempdb Resources
Validate Database Solution
Review

Module 5 - Data Access Designs

Data Access Designs
SQL 2005 Provides Great Granularity of Permissions
Define Access Policies
User Defined Functions
Special User Defined Functions Thoughts
New User Defined Aggregates
Demo - User Defined Aggregates
Stored Procedures
Demo - EXECUTE AS
Review

Module 6 - Dependencies Count In Designs

Dependencies Count In Designs
If You Must Cross-DB…
Old School Procedures
Demo - Creation of Least Privilege Accounts
Reach Out To COM
Demo -Wrap an OLE Automation Or Do in CLR
Reach Beyond the Instance
Spread Data Around
High Availability
Review
Course Closure