Our E-learning curriculum is specifically designed with the busy professional in mind. All of our programs are produced using advanced learning concepts that encompass learning techniques that are designed for adult learning. E- learning is very popular today for a very good reason – It Works! People everywhere are discovering that they can fulfill their learning objectives conveniently (at their own pace, on their own time) and affordably (online classes start at a fraction of the cost of traditional classroom training).
Our easy-to-use delivery format allows you to concentrate on the lesson at hand and not how to run the delivery software – saving you time and frustration. Our comprehensive course materials are delivered in an easy-to- understand format – allowing you to get the most out of your time online.
Demonstrate your specialized technical expertise with a Microsoft Certified Technology Specialist (MCTS) credential. By earning this credential, you can prove your ability to successfully implement, build on, troubleshoot, and debug a particular Microsoft technology, such as a Windows operating system, Microsoft Exchange Server, Microsoft SQL Server, and Microsoft Visual Studio.
The Microsoft Certified Technology Specialist (MCTS) certifications provide the foundation for Microsoft Certification. These certifications are designed to validate your skills on the features and functionality of key technologies. You can show your depth of knowledge in one specific technology, earn multiple MCTS certifications to show breadth across different products, or build on the MCTS to earn a Microsoft Certified IT Professional (MCITP) credential.
MCTS candidates are capable of implementing, building, troubleshooting, and debugging a particular Microsoft technology.
AUDIENCE PROFILE:
Candidates should have one to two years of experience using Microsoft SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who work in jobs in which database development is their main area of responsibility, or they work in environments in which databases are central to their primary job roles. These job roles include the following:
- IT generalists who work in environments in which SQL Server 2008 is part of an overall solution
- IT professionals who manage systems that run SQL Server 2008
- Developers who build applications that use SQL Server 2008
- IT professionals who work with third-party applications that are built on SQL Server 2008
COURSE FEATURES:
- Instructor led training by the industry’s finest experts delivered via streaming video online or DVD
- Software demonstrations where the instructor shows you how to perform a task onscreen.
- Interactive multimedia presentations
- Easy to navigate controls
- Course bookmarking which allows you to resume training where you left off the last session.
- Hands-on activities and labs
- Review Questions
- Practice Exam Simulators with three different training and testing modes. These simulators can also be used for pre- and post-testing.
- Free technology upgrades for one year
- Educational support
COURSE OUTLINE
Course: 70-433
Course Introduction
Instructor Introduction
Course Outline
Module 1: Implementing Tables
Module Overview
Implementing Schemas
Creating Tables
Implementing Filestreams
Working Constraints
Partitioning Tables
Module Overview
Module 2: TSQL Fundamentals
Module Overview
Retrieving Data
Modifying Data
Module Review
Module 3: Advanced Querying Concepts
Module Overview
Built-In Functions
Handling Transactions and Errors
Advanced Query Techniques
Module Review
Module 4: Specialized Data Types
Module Overview
XML
Spatial Types
Module Review
Module 5: Creating Objects
Module Overview
Views
Stored Procedures
Functions
Triggers
CLR-Based Objects
Module Review
Module 6: Service Broker
Module Overview
Service Broker Concepts
Implementing the Service Broker
Module review
Module 7: Managing SQL
Module Overview
Database Mail
External Tools
Tracking Data Changes
Module Review
Module 8: Creating and Maintaining Indexes
Module Overview
Indexes
Specialized Indexes
Module Review
Module 9: SQL Server Concurrency
Module Overview
Locks and Latches
Isolation Levels
Monitoring Locks
Module Review
Module 10: Optimizing Performance
Module Overview
System Monitor
SQL Server Profiler
Database Engine Tuning Advisor
Module Review
Course Review
Exam Tips
To order contact Specialized Solutions at:
Specialized Solutions
Corporate Training Division
3727 Jonlen Drive
Cincinnati, OH 45227
Toll Free – 1-877-291-9797
Direct – 513-878-1116