Home >> IT Training >> Microsoft Classes

SQL Server 2005 for Developers Training Classes

Our SQL Server 2005 for Developers training class is different from the rest because we hire only full-time, professional IT consultants. Not only do they have years of experience, but they have a talent for teaching and can pass that knowledge on to you. Because our IT training classes are taught by these experienced professionals in real time, you can get your workplace questions answered immediately, and put those answers to work right away. We teach you in five-day immersion sessions so that you leave feeling confident in your new abilities.

In our course, you will gain the knowledge necessary to implement Microsoft SQL Server 2005. You will learn to create a database, data types and tables. We will show you how to create and tune indexes as well as create constraints. You will also implement views and stored procedures and manage transactions and locks. The course ends by teaching you how to use the new security model as an optional lab. Not only do we teach you using proprietary materials, but we use Official Microsoft Learning Products so that you are getting the latest information available.

Our onsite SQL Server 2005 for Developers training class is a great choice for companies that have more than six employees who need this kind of training. Not only can we save you valuable commute time by eliminating the need for commuting, but we can save you 30% off the cost of a course taught in a traditional classroom setting. You provide the training room at your facility, and we'll bring the rest.

If you are ready to take the next step in your IT career, enroll in our SQL Server 2005 for Developers training class today. Just click on the blue button to start the registration process.

Enrollment Fee: $2995.00 USD
Number of Class Days: 5

SQL Server 2005 for Developers schedule:
	Mar 16 - 20, 2009	Los Angeles, CA
	Mar 30 - Apr 3, 2009	Ottawa, ON
	Mar 30 - Apr 3, 2009	San Francisco, CA
	Mar 30 - Apr 3, 2009	Houston, TX
	Apr 6 - 10, 2009	Chicago (Schaumburg), IL
	Apr 27 - May 1, 2009	Sacramento, CA
	May 4 - 8, 2009	Washington, DC
	May 4 - 8, 2009	Dallas, TX
	May 11 - 15, 2009	Atlanta, GA
	May 18 - 22, 2009	Morristown, NJ
	Jun 1 - 5, 2009	New York, NY
	Jun 1 - 5, 2009	Toronto, ON
	Jun 8 - 12, 2009	San Jose, CA
	Jun 15 - 19, 2009	Raleigh, NC
	Jun 22 - 26, 2009	Orlando, FL
	Jul 6 - 10, 2009	Chicago (Schaumburg), IL
	Jul 20 - 24, 2009	Ottawa, ON
	Jul 20 - 24, 2009	Washington, DC
	Aug 3 - 7, 2009	Dallas, TX
	Aug 10 - 14, 2009	Morristown, NJ
	Aug 24 - 28, 2009	Toronto, ON
	Aug 24 - 28, 2009	New York, NY
	Sep 14 - 18, 2009	Atlanta, GA

Training Class Outline:

1. Creating Databases and Database Files

*Create Databases
*Create Filegroups
*Create Schemas
*Create Database Snapshots

2. Creating Data Types and Tables

*Create Data Types
*Create Tables
*Create Partitioned Tables

3. Using Transact-SQL and XML

*Basic Select Statement and Select Operators
*Table Joins and Sub-queries
*Insert, Update, and Delete
*Aggregate Functions and Group By
*Compute, Compute By, Cube, and Rollup
*New Recursive Capabilities (CTEs)
*Pivot and Unpivot Operations
*Error Handling
*Retrieving XML by using FOR XML
*Shredding XML by using OPENXML
*Introducing XQuery
*Using the XML Data Type
*XML Web Services

4. Creating and Tuning Indexes

*Create Indexes
*Define Clustered, Non-Clustered, and Unique Indexes
*Define Index Creation Fill Factors
*Tune Indexes
*Optimize Indexes
*Use Online Index Operations
*Utilize Physical Storage
*Create XML Indexes

5. Implementing Data Integrity by Using Constraints

*Data Integrity Overview
*Implementing Constraints

6. Implementing Data Integrity by Using Triggers and XML Schemas

*Implementing Triggers
*Implementing XML Schemas

7. Implementing Views

*Introduction to Views
*Creating and Managing Views
*Optimizing Performance by Using Views

8. Implementing Stored Procedures

*Implementing Stored Procedures
*Creating Parameterized Stored Procedures
*Working with Execution Plans
*Handling Errors

9. Implementing Functions

*Create and Use Functions
*Work with Functions
*Control Execution Context

10. Implementing Managed Code in the Database

*Introduction to the SQL Server Common Language Runtime
*Import and Configure Assemblies
*Create Managed Database Objects
*Compare T-SQL and Managed Code

11. Managing Transactions and Locks

*Using Transactions
*Managing Locks

12. Using Service Broker and ADO.Net

*Service-Oriented Architecture (SOA)
*Service Broker Overview
*Create Service Broker Objects
*Send and Receive Messages
*Asynchronous Processing
*Example Application
*Explore ADO.Net 2.0
*Multiple Active Result Sets (MARS)
*Transparent Client Redirection

13. Using Notification Services

*Introduction to Notification Services
*Developing Notification Services Solutions
*Example Notification Services Application

14. Security - Native Data Encryption

*Object-Level Security
*New Schema Object
*Enable Native Data Encryption
*Example Application of Data Encryption