MCTS SQL Server 2005/2008
Overview
In this challenging IT world
certification stands out.
It gets your foot in door which provides you the chance to move
forward in the hiring line.
With the MCTS SQL Server boot camp will prepare you for the
70-431/70-432 exam.
When you become certified you are:
·
Stand out with proof of your specific, real-world technology skills
·
Are productive and help increase customer satisfaction, reduce
network downtime, and push service to a higher level
·
Achieve success with each Microsoft certification it increases your
professional recognition
The MCTS SQL Server certification
highlights your area of expertise in managing and maintaining a
Microsoft SQL Server 2005/2008.
The candidate will have displayed their
experience installing, managing, monitoring, troubleshooting Microsoft
SQL Server 2005/2008, managing security, creating databases, complex
queries, views, stored procedures, functions and learning how to get the
most of the Microsoft SQL Server.
Here are some of the things that you will learn in this boot camp.
·
Install and configure SQL Server 2005
·
Manage database files
·
Backup and restore databases
·
Manage Security
·
Monitor SQL Server
·
Transfer data into and out of SQL Server
·
Automate administrative tasks
·
Replicate data between SQL Server
instances
·
Maintain high availability within the SQL
Server 2005 environment
·
Create databases and database files
·
Create data types and tables
·
Use XML-related features in Microsoft SQL
Server 2005/2008
·
Plan, create and optimize indexes
·
Implement data integrity in Microsoft SQL
Server 2005 databases by using constraints
·
Implement data integrity in Microsoft SQL
Server 2005 by using triggers
·
Implement views
·
Implement stored procedures
·
Implement functions
·
Implement managed code in the database
·
Manage transactions and locks
·
Use Service Broker to build a
messaging-based solution
·
Use Notification Services to generate and
send notifications
·
Get started with databases and
Transact-SQL.
·
Perform basic queries.
·
Group and summarize data.
·
Join data from multiple tables.
·
Work with subqueries.
·
Modify data.
·
Query metadata, XML, and full-text
indexes.
·
Use programming objects for data
retrieval.
·
Use advanced querying techniques.
·
Learn the differences between 2005/2008
·
MCTS Certification Readiness
70-431/70-432
What do the students get?
All VHD’s for the class
Test Prep Materials
Test Voucher
Snacks Provided (In House classes only)
Lunch Provided - Onsite Classes Only
Enjoy the cuisine of Palm Coast. Choices will include Italian,
Mexican, Chinese, Mediterranean and your usual American recipes.
Audience
IT Professionals, IT generalists,
and help desk professionals who want to learn about Microsoft SQL Server
2005 are the audience for this course.
IT
Professionals, IT generalists and help desk professionals should have at
least 3 years experience working in the IT field.
You
will learn all of the features and technologies for maintaining and
implementing a database on Microsoft SQL Server 2005.
Prerequisites
·
Working knowledge of relational databases
·
Some experience with database design
·
Experience with running commands from a
command window, such as the DOS command prompt.
·
An understanding of basic relational
database concepts, including:
·
Logical database design.
·
Physical database design.
·
How data is stored in tables (rows and
columns).
·
Data integrity concepts.
·
Relationships between tables and columns
(primary key and foreign key, one-to-one, one-to-many, and
many-to-many).
·
Basic knowledge of the Microsoft Windows
operating system and its core functionality. For example, how to use
Windows Explorer, open and save files, and what a client/server
application interaction means.
Course Length
5 Days (9AM-6PM)
M,W,F, 6-10PM, Sat 9AM-6PM (Online Course)
Pricing
In-House - Palm Coast, FL
|
Price Level |
Package |
Includes |
| Diamond |
4950.00 |
Travel*, Lodging, Laptop, Vouchers,
Breakfast, Lunch |
| Ruby |
3950.00 |
Lodging, Laptop, Vouchers, Breakfast, Lunch |
| Sapphire |
2750.00 |
Laptop, Vouchers,
Breakfast, Lunch |
| Pearl |
1750.00 |
Vouchers, Breakfast
and Lunch |
*Travel - Airfare, Car in the US and Canada, $500 for overseas travel
--Books and Test Materials are included
--Laptop Not required then take $500 off the price of the course
Online
|
Price Level |
Package |
Includes |
| Platinum |
3250.00 |
Desktop, Vouchers |
| Gold |
2750.00 |
Vouchers |
| Silver |
1750.00 |
Class Only |
Course Content
|
Module 1 – Installing SQL Server
2005
·
Selecting the Correct SQL Server 2005 Edition
·
Determining Infrastructure Requirements for SQL Server 2005
·
Using Default Named, or Multiple Instances fro SQL Server 2005
·
Installing a New Instance of SQL Server 2005
·
Upgrading to a SQL Server 2005 Installation
·
Lab
|
Module 2 – Configuring SQL Server
2005
·
Configuring Log and Data Files
·
Configuring Database Mail
·
Specifying a Recovery Model
·
Configuring Server Security Principals
·
Configuring Database Securables
·
Configuring Encryption
·
Configuring Encryption
·
Configuring Linked Servers
·
Lab
|
|
Module 3 – Creating Tables,
Constraints, and User-Defined Types
·
Creating Tables
·
Implementing Constraints
·
Creating User-Defined Types
·
Lab
|
Module 4 – Creating Indexes
·
Understanding Index Structure
·
Creating Clustered Indexes
·
Creating Nonclustered Indexes
·
Lab
|
|
Module 5 – Working with Transact-SQL
·
Querying Data
·
Formatting Result Sets
·
Modifying Data
·
Working with Transactions
·
Lab
|
Module 6
- Creating Partitions
·
Creating a Partition Function
·
Creating a Partition Scheme
·
Partitioning Tables and Indexes
·
Querying Partitions
·
Managing Partitions
·
Lab
|
|
Module 7 – Implementing Views
·
Creating a View
·
Modifying Data Through Views
·
Creating an Indexed View
·
Lab
|
Module 8 – Managing XML Data
·
Working with XML Structures
·
Retrieving XML Data by Using SQL Server Server-Side
Technologies
·
Retrieving XML Data Using SQL Server Middle-Tier Technologies
·
Modifying XML Data
·
Converting Between XML Data and Relational Data
·
Lab
|
|
Module 9 – Creating Functions,
Stored Procedures, and Triggers
·
Implementing Functions
·
Implementing Stored Procedures
·
Implementing Triggers
·
Lab
|
Module 10 – Working with Flat Files
·
Preparing to Work With Flat Files
·
Running the bcp Utility
·
Performing a Bulk Insert Task
·
Importing Bulk XML Data
·
Using the SSIS Import/Export Wizard
·
Lab
|
|
Module 11 – Backing Up, Restoring,
and Moving a Database
·
Backing Up a Database
·
Restoring a Database
·
Moving a Database
·
Lab
|
Module 12- Using Transact-SQL to
Manage Database
·
Managing Index Fragmentation
·
Managing Statistics
·
Shrinking Files
·
Using DBCC CHECKDB
·
Recovering Data from Database Snapshots
·
Lab
|
|
Module 13 – Working with HTTP
Endpoints
·
Understanding HTTP EndPoint Security
·
Creating a Secure HTTP EndPoint
·
Lab
|
Module 14 – Working with SQL Server
Agent Jobs
·
Creating a SQL Server Agent Job
·
Creating a Maintenance Plan
·
Configuring Operators
·
Configuring Alerts
·
Lab
|
Module 15 – Monitoring and
Troubleshooting SQL Server Performance
·
Working with SQL Server Profiler
·
Working with System Monitor
·
Using the Database Engine Tuning Advisor
·
Using Dynamic Management Views and Functions
·
Correlating Performance and Monitoring Data
·
Resolving Blocking and Deadlocking
·
Resolving Database Errors
·
Lab
|
Module 16 – Managing Database
Snapshots
·
Creating a Database Snapshot
·
Reverting a Database from a Database Snapshot
·
Lab
|
|
Module 17 – Implementing Database
Mirroring
·
Understanding Database Mirroring Roles
·
Preparing Databases for Database Mirroring
·
Establishing Endpoints
·
Understand Operating Modes
·
Failing Over a Database Mirror
·
Removing Database Mirroring
·
Lab
|
Module 18 – Implementing Log
Shipping
·
Preparing to Log Ship
·
Configuring Log Shipping Options
·
Configuring Log Shipping Mode
·
Implementing Log Shipping
·
Configuring Monitoring
·
Lab
|
|
Module 19 – Managing Replication
·
Understanding Replication Types
·
Setting up Replication
·
Configuring Replication Security
·
Configuring Conflict Resolution for Merge Replication
·
Monitoring Replication
·
Lab
|
Module 20 – Working with the Service
Broker
·
Exploring the Service Broker Architecture
·
Creating Message Type and Contracts
·
Creating Queues and Services
·
Creating Conversations
·
Sending and Receiving Messages
·
Lab
|
|
Module 21 – Creating Full-Text
Catalogs
·
Creating a Full-Text Catalog
·
Creating a Full-Text Index
·
Populating a Full-Text Index
·
Querying Data by Using a Full-Text Index
·
Lab
|
Module 22 – Introduction to SQL
Server 2008
·
The Evolution of SQL Server
·
Preparing for SQL Server 2008
·
Lab
|
|
Module 23 – SQL Server 2008
Manageability Enhancements
·
Central Management Servers
·
Implementing Constraints
·
Lab
|
Module 24 – SQL Server 2008
Performance Enhancements
·
Managing Workloads by Using Resource Governor
·
Monitoring Performance by Using the Data Collector
·
Managing Performance by Using Plan Guides
·
Lab
|
|
Module 25 – SQL Server 2008 Security
Enhancements
·
Encrypting Databases
·
SQL Server Audit
·
Lab
|
Module 26 – SQL Server 2008 Database
Development Enhancements
·
Enhancements to Transact-SQL and SQL Server Management Studio
·
Data Type Enhancements
·
Working with Spatial Data
·
Lab
|
|
Module 27 – SQL Server 2008
Availability Enhancements
·
Always on Technologies
·
Transactional Peer-to-Peer Replication
·
Lab
|
Module 28 – SQL Server Data Warehousing Enhancements
·
ETL Enhancements
·
Partitioning Enhancements
·
Optimizing Storage
·
Lab
|
|
Module 29 – SQL Server 2008
Reporting Services Enhancements
-
Reporting Services Architecture and
Management
-
Authoring Reports
-
Report Processing and Rendering
-
Lab
|
Module 30 – SQL Server 2008 Analysis
Services Enhancements
-
Multidimensional Analysis with SQL
Server 2008 Analysis Services
-
Data Mining with SQL Server 2008
Analysis Services
-
Lab
|
