Microsoft SQL Server 2008 Database Development Training Course

Our SQL Server 2008 Database Development Training Teaches You:
T–SQL, .NET/CLR Development, Data Partitioning,
Advanced Query Techniques and much more,
plus complete MCTS 70-433 Exam Coverage!

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. Whether you’re a beginner or experienced in SQL or database development, this course covers SQL Server 2008 in depth as you design, develop, and maintain your own enterprise database solution!

Database Administration 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 database and lay the foundation towards becoming a DBA.

• Over 10 Hours of SQL Server 2008 Training Videos on 2 Jam Packed DVDs!
• All Instructor-Led!
• Get certified! Exam Coverage for MCTS 70-433
• Scenario-based training - learn to do the tasks you do in your job
• Multiple File Formats Make It Convenient for You To Learn Anywhere You Go! iPod Video, Mp3 Audio, .WMV & high quality .AVI video
• FREE FULL VERSION of Transcender's MCTS 70-432 Practice Exam! We've partnered with Transcender®, the leading exam simulation provider in the world! Purchased separately, you would pay $159. But you get it FREE as the perfect training companion to our SQL 2008 course!
• Learn at your own pace and at a fraction of the price compared to classroom training!

Free with this course Windows Server 2008 R2

 

Watch a Demo Now!

Microsoft SQL Server 2008 Database Development Training Demo

SQL Server 2008 Database Development
Training Course FAQs

"Am I qualified to take the training courses in this package?"

YES! If you are a complete beginner to SQL Server, have used previous versions of the software, or have some experience with SQL Server 2008, you'll benefit from this in-depth course!

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

Microsoft 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_NUMBGER 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
• 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 Cdreating 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 need to know to create an 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 13
Database Mail
In this video you will learn the steps you need to know to create an 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)

Here is what you get....

19 videos will be provided in High-Quality AVI & WMV format. In other words, you get perfect quality and replication of your instructor's 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). 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 Files to listen to Train Signal on the go. Some of our students have requested this option. People would like to be able to listen in their car or while working out. Can be burnt to a CD or copied to portable device. Great supplemental training to the videos.

Instructor Notes – These PDF documents can be printed out and contain the slides used by the instructor throughout the videos. These allow the user a quick easy reference to notes on the slides and make any additional notes for their own learning process.

Free full version of Transcender's SQL Server 2008 Practice Exam! (SAVE $159!) 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!
 

The Complete Train Signal FastTrack Video
CBT Training Library
Buy "Microsoft SQL Server 2008 Database Development" as Part of our Complete FastTrack Video CBT Training Library...
Every Course we Have on a USB Hard Drive
Check it Out Now!

Microsoft SQL Server 2008 Database Development Training Course

Only £220 (ex 15% vat & del) 

Multi user pricing available - call sales now

Official Purchase orders accepted from Government, Education, Health & Charity, Times 1000 plc's,  Professional Partnerships and other pre-approved accounts. Want to order more than one course ? Contact sales for a custom quote.