Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

This Microsoft SQL Server 2008 Development Tutorial Video covers what you need to know in order to design and build databases, run effective code as applications in the background, and create solutions that let the end user access database information in a secure and efficient manner. As a companion piece to the MS SQL Server Administration Tutorial, this training course goes beyond the basics of installation and maintenance and takes you through the unique challenges of developing functional database-driven code. Perfect for beginners as well as advanced users who have used Microsoft SQL in the past, the training video progresses gradually but includes a number of time-saving tips that more experienced users will appreciate. The video based course drives home some of the basics for users just getting started with the software, addressing initial setup issues before discussing types of databases, normalization, development diagrams, table basics, data types, functions, transactions, indexes and more. The tutorial video format allows you to learn complex procedures in simple steps, and the included video controls let you pause, fast-forward, or repeat lessons at any point. This Microsoft SQL Server Development Tutorial Video can be ordered on CD / DVD or accessed instantly online through the monthly subscriber option.

Associated Tutorials: Microsoft SQL Server 2008 Admin | Microsoft SQL Reporting Services | Microsoft Windows Server 2008 | Microsoft LINQ Training | Microsoft Server 2008 Admin 70-646 | MySQL 5 Development | Advanced Crystal Reports

Microsoft SQL Server 2008 Development Tutorial CD / DVD

When you order this Microsoft SQL Server 2008 Development Video Tutorial CD You'll Receive...
Over 6 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn Microsoft SQL Server 2008 Development from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" I've tried videos from some of the other sites out there but I have not found anything that matches the quality and consistency of your products. "Victoria Munoro, Virginia

Microsoft SQL Server 2008 Development Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 6 Hours in Duration and Covers 69 Lessons.
Welcome to SQL Preparing to Run SQL Server Understanding Database Architecture
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
Understanding Tables & Views
  • Table Fundamentals
  • Making a Table Lesson One
  • Making a Table Lesson Two
  • Making a Create a Table Lesson Three
  • Understanding Data Types
  • Understanding Unicode
  • Data Types Added in 2008
  • Understanding Character Types
  • Understanding Exact Numerics
  • Approximate Numerics
  • Working with Date & Time Types
  • Understanding Null Values
  • Understanding Primary Keys
  • Understanding Foreign Keys
  • Understanding Candidate Keys
How To Retrieve Data
  • Using Select Statements
  • Using Column Aliases
  • How to Join Tables Lesson One
  • How to Join Tables Lesson Two
  • Applying Scalar Functions
  • Understanding the User Defined Function
Data Modifications
  • How to Insert Data
  • How to Update Data
  • How to Delete Data
  • Understanding the Output Clause
  • Understanding the Merge Clause
Transaction Management
  • Basics of Transactions
  • Understanding Explicit Transactions
  • Understanding Transaction Isolation Levels
How to Program Objects
  • Basics of Views
  • Understanding Indexed Views
  • Working with Stored Procs
  • How to Create Stored Procs
  • Working with Parameters
  • Creating Temporary Tables
  • Basic Table Expressions
  • Understanding Table Variables
  • Temporary, Common Tables, & Table Expressions
  • Understanding Dynamic SQL
Overview of Indexes
  • Basics of Indexes
  • Basic Rules for Indexing
  • Clustered vs. Non-Clustered
  • How to Create Indexes
  • How to Monitor Indexes
Conclusion
  • Summary of Lesson Content
End Notes
  • Tutor Bio

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

About this Microsoft SQL Server 2008 Development Training CD

Title Microsoft SQL Server 2008 Development
Tutor Mark Long
Other tutorials by Mark Long
Videos 69 Lessons- Video run time: 6 hours
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2010
Work files Yes
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are available on this title
38 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract .
No minimum period.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn Microsoft SQL Server 2008 Development from an accredited expert in days.

Want to hear what our customers say about our products?

Related Training Videos

Microsoft SQL Server Admin Tutorials | Microsoft SQL Server Programming | Microsoft Server Tutorials| Online Microsoft SQL Server 2008 Development Training Courses

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.