SQL Server 2008 Database Development

Our SQL Server 2008 Database Development Training Teaches You: T-SQL, .NET/CLR Development, Data Partitioning, Advanced Query Techniques and Much More. Plus, 70-433 Exam Coverage!

This Course Includes All of the Following:

Instant Online Access Begin Streaming Your Training Immediately
Physical Media Shipped Directly to Your Doorstep For Free, Worldwide

Transcender Practice Exam Practice For Your Exam With This Award-Winning Exam Preparation

$397
Paying with Purchase Order?
View Outline
Our Total Experience Guarantee is Very Simple

If you are not satisfied with our training, our service, or our support FOR ANY REASON, return your course within 90 days for a FULL REFUND (up to $397). You have my word.

Scott Skinger Founder & President of TrainSignal, Inc.

Overview

Mobile On-Demand Training Train Where You Want, When You Want
Additional Training Formats High Resolution Video, MP3 Audio and PDF of Instructor Notes
Watch a Demo

A Letter from Mel Haynes
(MCITP: Database Administrator 2008, MSCS, MCTS, MCP)

If you want to develop hands-on experience as a SQL Server 2008 Developer, or prepare for the 70-433 exam then this course is for you!

We are excited to announce our much anticipated SQL Server 2008 Database Development Training course. These days, a database can utilize many different elements and is no longer used to simply store data.

With that in mind, this course is designed to teach you how to design databases, design applications and build the functionality that best supports your end users and ultimately supports a business as a whole.

Database Development is one of the few jobs that seems to always be in demand. Follow along with the many real world examples in this course to develop your own databases and applications and lay the foundation towards becoming a database developer.

Professional Training

Over 10 Hours (10 Hours, 0 Minutes, 0 Seconds) of SQL Server 2008 Database Development Videos Jam Packed on 2 DVDs!
Multiple File Formats Make it convenient for you to learn anywhere you go! iPod Video, Mp3 Audio, .WMV & high quality .AVI video
PDF of Instructor Notes allow you to follow along with the videos and take more organized notes
Instant Access Online to the entire training course

Exam Preparation

Exam Coverage This course covers exam objectives required for you to pass:
- 70-433 - TS: Microsoft SQL Server 2008, Database Development Exam
FREE, FULL VERSION of Transcender's Practice Exam for:
- 70-433 - TS: Microsoft SQL Server 2008, Database Development Exam
We've partnered with Transcender®, the leading exam simulation provider in the world! Purchased separately, you would pay $139! But you get it FREE as the perfect training companion to our SQL Server 2008 Database Development!

Course Outline

SQL Server 2008 Database Development - Course Outline

Lesson 1 - SQL Server 2008 Database Development

Learn about your instructor and find out what is in the course.

Target Audience
Prerequisites
About Your Instructor
Course Topics
The Environment
SQL Certifications Overview

Lesson 2 - Designing and Developing a SQL Server 2008 Database Application

In this Video you will learn the basics of what application development is and you will get your first look at the scenario we will be using throughout the course.

Designing and Developing a Database Application
Our Scenario
Database Schema for Veronica?s Veronicas

Lesson 3 - Transact-Structure Query Language

In this Video you will learn how and when to properly use the basic statements and clauses you will encounter when constructing your database.

The SELECT Statement
The WHERE Clause
Nested SELECT Statement
The INSERT Statement
The UPDATE and DELETE Statements
The MERGE Statement
MERGE Statement Demo
The GROUP BY and HAVING Statements

Lesson 4 - Constraints and Triggers

In this Video you will learn about data integrity and how constraints and triggers enforce data integrity.

Data Integrity
Enforcing Data Integrity
Primary Key Constraint Violation
Selecting Two-Column Primary Key
UNIQUE Constraints
FOREIGN KEY Constraints
CHECK Constraints
CHECK Constraints Using GUI
Constraints: Enabling and Disabling
Triggers in SQL Server 2008
DML Triggers
Creating a Trigger
Testing Triggers
Constraints vs. Triggers

Lesson 5 - User Defined Functions

In this Video you will see how to create User Defined Functions and you will discover the rules that are associated with UDFs.

User-Defined Functions Basics
Creating User-Defined Function
User-Defined Function Benefits
Schema Binding

Lesson 6 - Advanced Query Techniques

In this Video we are going beyond the basics of query techniques. You will see how to use common table expressions, ranking and built-in functions, and we will work hands-on with examples of how and when to use these expressions and functions.

Common Table Expressions
Recursion Example
Rank Functions – ROW_NUMBER Function
Rank Functions – NTILE Function
Other Rank Functions
Built-In Functions

Lesson 7 - Stored Procedures

In this Video you will work hands on to create simple and more complicated Stored Procedures. Plus, we will take a detailed look at how to view and modify stored procedures.

Stored Procedure Basics
Types of Stored Procedures
Creating and Modifying a Simple Stored Procedure
Benefits of Stored Procedures vs. Transact-SQL
Creating a More Complicated Stored Procedure
Modifying a More Complicated Stored Procedure
Creating a Stored Procedure from a Template
Stored Procedures vs. Functions
Table Value Parameters

Lesson 8 - Handling Errors

It is inevitable that you will encounter certian types of errors in your SQL Server. In this Video you will discover the different types of errors, how to properly use an error handler, and you will work hands on to create transactions.

Types of Errors
Syntax Errors
Handling Database Engine Errors
TRY...CATCH Construct
Retrieving Error Information
Error Severity
RAISERROR
Creating a New Error Message
sys.message Catalog View
Transactions
Using Debugger

Lesson 9 - .NET/CLR Development

In this Video you will discover the differences between CLR and T-SQL. Plus, you will create, load and run your own .NET application in SQL Server.

Common Language Runtime (CLR)
CLR vs. T-SQL
SQL-CLR Types Mapping
Steps for Using SQLCLR
Re-creating a Table
Review of the Steps
CLR Permission Sets
Execution Plans

Lesson 10 - Data Partitioning

In this Video you will learn how to create your own partitioned database tables and indexes, and you will learn how to verify data distribution.

Data Partitioning Diagram
Re-Creating Our Database
Creating and Using Data Partitions
Steps for Creating Partitioned Tables

Lesson 11 - Application Performance

In this Video you will see how to properly utilize the Database Engine Tuning Advisor (DTA) to analyze queries, how to use trace output for analysis, and you will see how to use two different statements to view query performance.

Database Engine Tuning Advisor Tuning Capabilities
Analyzing Query in Database Engine Tuning Advisor
DTA Requires a Workload
Creating a Trace with SQL Server Profiler
SHOWPLAN Statements
SET STATISTICS Statements

Lesson 12 - Working with XML Data

In this Video you will learn how to retrieve SQL Server relational data as XML. Plus, you will learn how to ""Shred"" and Store XML in your SQL Server.

Markup Languages
Why XML and SQL Server?
Some XML Basics
XML Support in SQL Server 2008
The 4 “FOR XML” Modes
XML Data Type
OpenXML Statement

Lesson 13 - Database Mail

In this Video you will learn the steps you will need to take to create a SMTP server, create Database Mail profiles, and create Database Mail accounts.

Database Mail Players
Simple Mail Transfer Protocol (SMTP) Server
Database Mail Profiles and Accounts
Public vs. Private Profiles
Configuring Database Mail
Stored Procedures
Database Mail SMTP Authentication

Lesson 14 - Full-Text Search

In this Video you will create your own Full-Text Catalog and Full-Text Index. Plus, you will learn how to use these objects to perform Full-Text Queries.

Basic Setup of a Full-Text Search
Configuring Full-Text Searches
WHERE CONTAINS Statement
Performing Full-Text Search in Spanish
Writing Full-Text Queries
Stop Words

Lesson 15 - PowerShell in SQL Server 2008

In this Video you will learn several of the key aspects of PowerShell that you should be able to take advantage of as a SQL Server 2008 Developer.

Microsoft?s Common Engineering Criteris
SQL Server 2008 PowerShell Extensions
The Hierarchy
SQL Server Specific PowerShell cmdlets
Using SQL Server PowerShell Provider
Microsoft.SQLServer.Management.Smo
A Developers Top “n” cmdlets

Lesson 16 - Service Broker

In this Video you will see how to utilize Service Broker to send messages between SQL Server boxes, which will allow you to trigger functionality on other servers.

What Does Service Broker Do?
Service Broker - A.K.A. Service-Oriented Architecture (SOA) - Terms
Creating Objects for Service Broker Communication
Sending Messages with Service Broker

Lesson 17 - Introduction to Integration Services

In this Video you will learn how to use SQL Server Integration Services to perform simple transformations in SQL Server.

Business Intelligence Development Studio
Installing Business Intelligence Environment and Integration Services (SSIS)
Building SSIS Package
Creating OLE DB Connection
Connecting Controls Using Data Manager
Running Transformation
Microsoft Integration Services

Lesson 18 - Introduction to Reporting Services

In this Video you will learn how to access the Reporting Services Configuration Manager. Plus, you will work to create your own simple reports under SQL Server Reporting Services (SSRS) using both Report Builder and Report Designer.

Business Intelligence Development Studio
Reporting Services
Building a Report Using Report Designer
Report Builder 3.0
Building a Report Using Report Builder 3.0

Lesson 19 - Certification 101

The path to certification will be clear once you watch this SQL Server 2008 certification road map. I cover all the certification levels, tracks and exams to get you certified in SQL Server 2008.

The Certification Hierarchy
Microsoft Certified Technology Specialist (MCTS)
Microsoft Certified IT Professional (MCITP)
Microsoft Certified Master (MCM)

Certified Instruction

Mel Haynes (MCITP: Database Administrator 2008, MSCS, MCTS, MCP, MS)

Mel has been delivering technical training since 1994. He has trained students across the USA, in Canada, Germany and the UK.

As a Member of Technical Staff (MTS) at Bell Labs in Naperville he worked as a C/UNIX software developer and in Quality Assurance (QA) for 5ESS international switching.

Mel first taught computer science while completing his Masters in Computer Science at Bradley University in Peoria, IL. He started working with Visual Basic in 1992 and began teaching VB as an MCT in 1995. He later moved on to include ASP, C#.net, VB.Net, Java, various web related developer topics, as well as SQL Server and Windows administration.

Mel has developed and delivered Master Data Management (MDM) training and is currently focused on SQL Server 2008. Mel is a gifted IT professional and communicator able to make complex concepts clear and easy to understand.

Courses Instructed by Mel Haynes

FAQ

SQL Server 2008 Database Development - FAQ

Am I qualified to take this course?: YES! If you have done any type of distributed application development, taken our SQL Server 2008 Administration Training course, or have experience installing SQL Server and setting up user accounts, you’ll benefit from this in-depth course!

Note: Some Windows Server experience will be beneficial, but not required.

Do I need any special equipment to complete this training course?: NO All you need is a computer with Internet Explorer and a media player; however, working hands-on with SQL Server 2008 may enhance your training experience.
Is this course part of any Microsoft certification track?: YES! This course will help you prepare for the 70-433 Microsoft SQL Server 2008, Database Development exam.

Order SQL Server 2008 Database Development Now!

$397

"Within 2 months time...I passed the 70-432 exam with flying colours!": Mel, I must say, I have never had such a good teacher

I first started purchasing your products last year when I decided to do the SQL Server 2008 Admistration Training.

I was a bit sceptical of the training but just decided to give a try, I was shocked to find out that it was the most amazing, clear, training I have ever had!

Within 2 months time after receiving the product from you, I went and sat my first Microsoft SQL Server 2008 Administration Exam and passed with flying colours!
Dennis BuGumba MCTS
"TrainSignal products not only teach me how to maintain my network, I actually gain understanding that is invaluable for the tests as well...": I just wanted to send in my thanks. It’s really nice to have a product out there for net admins that really delivers.

Everyone else seems to brag about how you can use their products to pass a test. I've taken and passed several tests, and few contained the content I need on a day-to-day basis.

TrainSignal products not only teach me how to maintain my network, I actually gain understanding that is invaluable for the tests as well. I bought your product at my previous employer and will buy it for my current employer as funds become available.

Though your product is amazing, I would like to make one request that I feel would complete the package. Most admins are clueless when it comes to scripting.

Everyone seems to have tons of advanced scripting, but just like everything else, there are little to no explanations for the beginner. Could you please consider adding something in that area to your training? Keep up the good work.

Thanks
David Morehead www.wcsmiami.org
"Its like having a Veteran walk you through training camp, building your confidence so you know what it takes to get it done.": Just want to say great job by you and the team on the training videos. The videos and the lab books trail each other so you align the image of it being done with the instructional reading. Its like having a Veteran walk you through training camp building your confidence so you know what it takes to get it done.

If your goal is certification then partner the video with test questions and you will solidify the knowledge from the video in your mind for the test and while really getting to know your craft!
Andrew (MCSE, A+, N+)
"I shall continue to buy your products without a question of a doubt.": I have purchased almost all of your videos so far and I must say that they have been value for money; in as much as that I have gained lots of new skills.

Moreover, I find your service absolutely excellent and I feel totally appreciated as a customer. I shall continue to buy your products without a question of a doubt.

Kind regards,
Keith Greaves Fruitree director
"...the best paying job of my IT career. Your videos had a big part in that...": I wanted to let you know I was asked today (3/16/2007) to provide references for a Network Engineer position at a large world-wide law firm. Providing references is typically the last step before an offer. This potentially could be the best paying job of my IT career. Your videos had a big part in that.

I have two and half years experience with Active Directory and Exchange 2003, but your videos showed me just what I needed to pass their skills assessment test. The price was well worth it.
Bill Boyd
"You guys have a unique ability to explain and visually demonstrate these esoteric topics in a way that is easy to understand...": I just wanted to let you know I have been very impressed with the orders we have placed with you.

Last year we bought the Microsoft Server Complete Library. It is one of the best I have seen.

You guys have a unique ability to explain and visually demonstrate these esoteric topics in a way that is easy to understand.

I have attended many training classes where I was getting good information but because of the way it was taught I had to force myself to pay attention and in some cases just try not to fall asleep.

These videos are just the opposite. If I am not careful I will sit up too late watching them. Well, we just received our most recent order. This time we decided to order all of your VMWare Videos. If they are as good as your other work then I know I'm going to be happy.

Thanks for the help and keep up the good work.
Del Bullion VDI Communications, Inc.
"I will recommend TrainSignal to all of my tech buddies...": I wanted to write and express my great satisfaction with the Exchange Server 2003 for SophiesToyBox.com. I am very impressed with the course. I felt as though I was actually performing the tasks during the course.

Scott was great at explaining things and even going through the quirks that would surely happen during an install. I am very pleased with the material and plan to be back to purchase more. Great job. I will recommend TrainSignal to all of my tech buddies.
William R. Cunningham (Reggie) Systems Administrator, Institute for Safe Medication Practiceswww.ismp.org
"I am on my way to becoming an MCSE and have found your videos very informative. However, your service deserves even more praise.": I inadvertently ordered two of the same course on Routing and Remote Access and when I discovered my mistake, I was very upset.

Internet based companies are often hard to deal with. If you try to return something, they put you off -sometimes indefinitely. I was almost sure that I would encounter problems when I attempted to exchange the video.

I called Ashley on the phone and informed her of my intent to exchange the duplicate video for another. She told me that she would send the other video when I returned mine.

I sent the video back by UPS and within a few days I received a package with the new Active Directory tutorial movie. I was so impressed that your company did not try to hold the movie hostage or to delay sending it. Even though I am an avid supporter of technology, I have to agree with those who say that the age of impersonal commerce has opened doorways to poor service.

I hope your company is successful and that others realize the benefit of doing business with someone they can trust!

Sincerely,
Nancy Ashley Ware
"I will be happy to recommend your products to anyone I know...": Just to let you guys know I received my order this morning. Extremely happy with the fast delivery service, since I ordered the product on Tuesday afternoon and I received them Thursday morning (48hrs delivery from the US to the UK, that puts to shame some mail order companies in the UK) I will be happy to recommend your products to anyone I know.
Daniel Jenkins Surrey, Great Britain
"I highly recommend your products and I buy every new release that comes out.": I would like to say that I have had many “live” classes in everything from MCSE to CCNA and your classes are as good or better. You can play the CDs over and over or go back and review something that you did not really understand the first time.

I highly recommend your products and I buy every new release that comes out. Please keep up the great work!

Thanks,
Joseph McElveen Insync Network Systems, Savannah, Georgia
"Your way of running business is a rare example...": There truly is power in a good name and a way of running business. Good impressions and positive experiences with a company definitely affect how people think when they think of your name - in this case, TrainSignal.

All that is to say thank you and that I will truly enjoy the material. I have studied all the other many hours diligently and will continue on my certification path.

You guys are doing it right; it's great to take part in your program and business.
John Archer

Looking For Volume User Licensing For SQL Server 2008 Database Development?

24/7 Access to Training

Online access to all training through My Online Training, with an option for physical media.

Volume Discounts

Discounts start at quantities as low as 2 licenses per training course.

Scalable Licensing Model

License your team for specific courses that meet their needs to build a custom package of TrainSignal Training.

Call 1.888.229.5055 or Email sales@trainsignal.com

Contact us for a free volume license quote or tell us how many licenses you need and we'll show you the volume license discount immediately in your cart.

Volume Discount Pricing For SQL Server 2008 Database Development

# of Users	% Discount	Cost Per User
1	0%	$397.00
2	20%	$317.60
3-4	25%	$297.75
5-9	30%	$277.90
10-19	35%	$258.05
20-49	40%	$238.20
50+	Call 1.888.229.5055