SQL Server 2008
Database Development Training

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

A Letter from Mel Haynes
(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.

SQL Server 2008 Database Development Training
Course FAQs

"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.

SQL Server 2008 Database Development Training
Course Outline

Video 1

Introduction

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

Video 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

Video 3

Transact-Structured Query Language (T-SQL)

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

Video 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

Video 5

User Defined Functions (UDFs)

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

Video 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

Video 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

Video 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

Video 9

.NET/CLR (Common Language Runtime) 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

Video 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

Video 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

Video 12

Working with XML (eXtensible Markup Language) 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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)

SQL Server 2008 Database Development Training Course

Here’s What You Get When You Order SQL Server 2008 Database Development Training Today!

19 videos will be provided in high-quality .AVI and .WMV format. In other words, you get perfect quality and replication of your instructors' screens. An easy-to-use table of contents allows you to navigate to key areas you wish to focus on.
19 iPod video files to watch Train Signal on the go! A popular request amongst our students who wish to study while they commute (i.e. train, plane, bus). These 320x240 M4V files are compressed versions of the original course, and play on any iPod that supports video. Also great for reviewing and refreshing your mind "on the job."
19 MP3 audio files to listen to Train Signal anytime, anywhere. Some of our students have requested this option. Now, you can listen in the car or while working out. Our MP3 files can be burnt to a CD or copied to a portable device.
Instructor Notes – These PDF documents, which can be printed out, contain the slides used by the instructors throughout the videos. These documents allow the user a quick easy reference to the instructors’ notes on the slides, and provides a place to make additional notes.

FREE FULL VERSION of Transcender’s SQL Server 2008 Database Development Practice Exam! (SAVE $99!)

We’ve partnered with Transcender®, the world’s leading exam simulation provider! Their award-winning simulations look and feel so much like the actual exam, you’ll feel confident on exam day!

These Practice Questions are the Perfect Training Companion to Our SQL Server 2008 Database Development Course! Best of All, They’re FREE!

Save time by focusing your studying efforts on topics that will actually be on the exam!
Comprehensive references explain the reasoning behind the correct answers!
Detailed reports and custom exam features help identify and strengthen your weak areas!
Transcender Live Update ensures your study materials are always up-to-date!

Even if you’re not studying for an exam, this comprehensive exam simulator is a great tool for testing and reinforcing your SQL Server 2008 skills & knowledge!

A Tremendous Value for Your Modest Investment... Fully Backed by Our 90-Day "Total Experience" Guarantee!

A classroom course can cost as much as $1595.00 USD and does not offer the flexibility to train anytime, anywhere. Plus, our Computer Based Training allows you to replay any topic or video as many times as necessary until you are comfortable with the concepts.

Receive this high-level professional training via Train Signal for Only ~~$799~~!
Limited-Time Offer Only $397!

Order Our SQL Server 2008 Database Development Training Today, and Receive:

PROFESSIONAL TRAINING

Over 10 Hours of SQL Server 2008 Database Development Training Videos on 2 Jam Packed 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.

70-433 EXAM PREPARATION

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

Total Package Value ~~$799~~!

Limited-Time Offer Only $397

(Risk-Free 90-Day Total Experience ™ Guarantee!)

Watch a demo now!
watch demo

SQL Server 2008 Database Development Training

Meet Your Certified SQL Instructor, Mel Haynes

(MSCS, MCTS, MCP)

Mel Haynes (MS) 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.

Similar Products

SQL Server 2008 Administration
SKU: 01-061-C
Price: $397.00

"Train Signal 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.

Train Signal 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
"...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 Practices www.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
"Train Signal Rocks!": Keep kicking butt! I have purchased CBT nuggets before. They are good on theory and very little application. Yours is both. Please keep up the great work Scott. You are very gifted.

What I love about your stuff is you have the theory and then you apply it and then you test it! You go full circle. CBT nuggets leaves too many things open ended. People don’t realize from the home CBT user. You need to go full circle theory, application how to use it, and then prove it. Mistakes and proving things help us see why and help us handle the unexpected better. I also am a teacher at my work, and this is what I do with effectiveness.

I also bought all of your courses all 21... I am studying for MCSE 2003 and your course rocks better than classroom. Way better.

Keep up the great work. Train Signal rocks!

Robert W. Van Dyke
IS Assistant
Bulls Eye Credit Union
"I’m sure I will be buying a lot more videos from you. :)": I bought the entire Windows training package and I am probably about half way through it. I am definitely happy with the product. So far I’ve watched videos from both Scott Skinger and Obaid Chhatriwala…both do a very good job.

Again, I am really happy with the product and I think the instruction quality of both Scott and Obaid is great! I’m only commenting on this because I’m sure I will be buying a lot more videos from you. :)

David Copenhaver
IT Manager / Network Administrator
HESSTECH, LLC
"Just wanted to take this opportunity to say how effective your training DVDs are.": Few weeks back, I had no idea what Active Directory, DNS, WINS, DHCP etc. are all about, but after watching your training videos all are as clear as crystal.

Thank You,
Abid Malik
Raleigh, North Carolina
"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
"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, Train Signal.

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.

Sincerely,
John Archer
"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+)