List Price: |
Special Price: |
|
 |
 |
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 server-side solutions for Microsoft SQL ServerT 2005. The course focuses on teaching database developers who work in enterprise environments to identify and place database technologies during design to achieve a suitable solution that meets the needs of an organization. Students will also learn to consider the solution from a system-wide view instead of from a single database or server perspective.
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
- Exam 70–442 : Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
Package Includes:
- 8 Sessions Featuring live instructor-led classroom sessions with full audio, video and demonstration components
- Printable courseware
- Sample code
- 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
This 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 - Server Solutions with SQL Server 2005
Server Solutions with SQL Server 2005
There is More to SQL Server Than Just SQL Server
Full-Text Services
Native XML Web Services
Replication Concerns
SQL Server Agent
New Database Mail
Demo - Turning on Database Mail
Notification Services
Service Broker
Reporting Services
SQL Server Integration Services
T-SQL Enhancements
Demo - Ranking Function
.NET CLR
SQLXML
Review
There is More to SQL Server Than Just SQL Server
Full-Text Services
Native XML Web Services
Replication Concerns
SQL Server Agent
New Database Mail
Demo - Turning on Database Mail
Notification Services
Service Broker
Reporting Services
SQL Server Integration Services
T-SQL Enhancements
Demo - Ranking Function
.NET CLR
SQLXML
Review
Module 2 - Security – Its More Than Just a Password
Security – Its More Than Just a Password
Security Concerns
Demo - SQL Injection
Who Are You?
Preferred Approach Toward Securing Native Web Services
Preferred Approach Toward Code Access Security
Preferred Approach Toward Reporting Services Security
Preferred Approach Toward Notification Services Security
Preferred Approach Toward Integration Services Security
Preferred Approach Toward Replication Security
Preferred Approach Toward Agent and Database Mail Security
Protect Objects With Roles and Schemas
Demo - Revoke Is Not Enough
Execution Context
Protect Stored Procedures, Views, and User Defined Functions
Protect Columns
How to Audit SQL Server
Protect your Audit
Not All Employees Are Equal
Demo - Remove Built-in Admins
Use DDL Triggers for Audit Information
Demo - Protect Tables From Oops!!
Review
Security Concerns
Demo - SQL Injection
Who Are You?
Preferred Approach Toward Securing Native Web Services
Preferred Approach Toward Code Access Security
Preferred Approach Toward Reporting Services Security
Preferred Approach Toward Notification Services Security
Preferred Approach Toward Integration Services Security
Preferred Approach Toward Replication Security
Preferred Approach Toward Agent and Database Mail Security
Protect Objects With Roles and Schemas
Demo - Revoke Is Not Enough
Execution Context
Protect Stored Procedures, Views, and User Defined Functions
Protect Columns
How to Audit SQL Server
Protect your Audit
Not All Employees Are Equal
Demo - Remove Built-in Admins
Use DDL Triggers for Audit Information
Demo - Protect Tables From Oops!!
Review
Module 3 - Plan for the Future by Planning for Today
Plan for the Future by Planning for Today
Using XML Requires Forethought
XML Has Redundant Data
How to Store – Character Type vs. New XML Type
Demo -What Impact Does XML Storage Have on Storage?
Model Your Database Solution
Balancing with OLAP
Rules of Normalization and When
Can I Index to Often?
Demo - Include Implications
Clustered Indexes on Non-Primary Keys
Scalability Up or Out
Spreading the Databases
Partition Tables and Indexes
Redundant Solutions with Scaling Out
Scaling Up
Review
Using XML Requires Forethought
XML Has Redundant Data
How to Store – Character Type vs. New XML Type
Demo -What Impact Does XML Storage Have on Storage?
Model Your Database Solution
Balancing with OLAP
Rules of Normalization and When
Can I Index to Often?
Demo - Include Implications
Clustered Indexes on Non-Primary Keys
Scalability Up or Out
Spreading the Databases
Partition Tables and Indexes
Redundant Solutions with Scaling Out
Scaling Up
Review
Module 4 - Transaction – Concurrency and Consistency
Transaction – Concurrency and Consistency
Exploring Data Phenomenon
Isolation Levels Options
Demo - Connection and Database Options for Row Versioning
Change Data Processing Plans
Balance Locks and Performance as a Result of Errors
Accessing Objects
Rollback Transactions Correctly
Long Running Transactions
Hints or Directives
Review
Exploring Data Phenomenon
Isolation Levels Options
Demo - Connection and Database Options for Row Versioning
Change Data Processing Plans
Balance Locks and Performance as a Result of Errors
Accessing Objects
Rollback Transactions Correctly
Long Running Transactions
Hints or Directives
Review
Module 5 - Defining a Push Solution with Notification Services
Defining a Push Solution with Notification Services
Where and How to Store Data
What is an Event Schema
How does Indexing Help?
Archiving Events
Demo - Subscription Classes
Plan Toward a Subscription Schema
Plan the Rules
Plan the Subscription Indexes
Maintain Subscriptions
Demo - Event Classes
Demo - Notification Classes
Define the Notification
Plan the Notification Indexes
Plan Toward Notification Delivery
Protocol Planning
Setting Execution Settings
Review
Where and How to Store Data
What is an Event Schema
How does Indexing Help?
Archiving Events
Demo - Subscription Classes
Plan Toward a Subscription Schema
Plan the Rules
Plan the Subscription Indexes
Maintain Subscriptions
Demo - Event Classes
Demo - Notification Classes
Define the Notification
Plan the Notification Indexes
Plan Toward Notification Delivery
Protocol Planning
Setting Execution Settings
Review
Module 6 -
Reliable Messaging with Service Broker
Reliable Messaging with Service Broker
Why Use Service Broker?
Locate Services
Locate Conversations
Plans for Dialogs
Plan for Queue Usage
Demo - Preparing Communication
Plan Toward Good Data Flow
Locate Data Staging
Locate Routes
Demo - Messaging
Plan for Activating Methods
Backup Planning
Review
Why Use Service Broker?
Locate Services
Locate Conversations
Plans for Dialogs
Plan for Queue Usage
Demo - Preparing Communication
Plan Toward Good Data Flow
Locate Data Staging
Locate Routes
Demo - Messaging
Plan for Activating Methods
Backup Planning
Review
Module 7 - Protect, Test, and Execute
Protect, Test, and Execute
Source Control Saves Time and Effort
Demo - Using Visual SourceSafe
Plan for Source Control
Protect Intellectual Property
Unit Tests Provide Low Level Confidence
Planning for Unit Tests
Perform Iterative Development
Compare Performance to Known Levels
Know What To Measure
Know How To Measure
Demo - Combining SQL Profiler and PerfMon
Adapting to Change
Put Services Where They Need to Be
Plan for Deployment
Module 7 Review
Source Control Saves Time and Effort
Demo - Using Visual SourceSafe
Plan for Source Control
Protect Intellectual Property
Unit Tests Provide Low Level Confidence
Planning for Unit Tests
Perform Iterative Development
Compare Performance to Known Levels
Know What To Measure
Know How To Measure
Demo - Combining SQL Profiler and PerfMon
Adapting to Change
Put Services Where They Need to Be
Plan for Deployment
Module 7 Review
Module 8 - T-SQL Programming Enhancements
T-SQL Programming Enhancements
Common Table Expressions
Performance Gains over Sub-Queries?
Demo - Using CTEs
Pivot Queries
Demo - Pivot Queries at Work
Ranking Queries
Demo - Ranking Query Usages
XQueries and FLWORs
Planning for XQueries
Follow the Path
WHERE Matters
Steps in Converting Data
To XML…
…And Back Again
Review
Course Closure
Common Table Expressions
Performance Gains over Sub-Queries?
Demo - Using CTEs
Pivot Queries
Demo - Pivot Queries at Work
Ranking Queries
Demo - Ranking Query Usages
XQueries and FLWORs
Planning for XQueries
Follow the Path
WHERE Matters
Steps in Converting Data
To XML…
…And Back Again
Review
Course Closure