Home
Username:
Password:

Microsoft SQL Server 2008 Development Tutorials

Online Contents For This Course

We have made some of the video tutorials for

Microsoft SQL Server 2008 Development

freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
   Course Description
Microsoft SQL Server 2008 relational database management server is the heart of a comprehensive data platform that provides access and managment of the business critcal data that powers business. In this course, Microsoft Certified Trainer Mark Long introduces you to the basics of SQL Server 2008 Database Development. Work files are included. To begin learning today, simply click on the movie links.

Choose your media type:

Introduction
  Welcome (01:58) T
  Course Overview (04:48) T
  SQL Server Basics (06:36) T
  Getting Hands On (04:04) T
  Microsoft SQL Certifications (05:24) T
  SQL Server Editions (05:48) T
  SQL Server Developer (03:39) T
Getting Set Up
  Hardware Requirements (03:48) T
  SQL Server Instances (04:27) T
  SQL Server Components (04:11) T
  Service Accounts (05:24) T
  Installing SQL Server 2008 pt. 1 (05:37) T
  Installing SQL Server 2008 pt. 2 (03:56) T
  Installing SQL Server 2008 pt. 3 (04:06) T
  SQL Authentication Modes (04:49) T
  Installing Sample Databases pt. 1 (05:46) T
  Installing Sample Databases pt. 2 (03:35) T
Database Design
  Database Types (05:56) T
  Normalization (06:25) T
  Normalization Benefits (05:15) T
  Database Diagrams (05:43) T
  Systematic Database Design (06:14) T
  Designing Database Objects (05:21) T
Tables & Views
  Table Basics (04:40) T
  Creating a Table pt. 1 (03:41) T
  Creating a Table pt. 2 (06:53) T
  Creating a Table pt. 3 (05:06) T
  Data Types (05:11) T
  Unicode Basics (05:27) T
  New Data Types In 2008 (04:16) T
  Character Types (05:46) T
  Exact Numerics (05:28) T
  Approximate Numeric Types (02:50) T
  Date & Time (05:08) T
  Null or Not Null (05:15) T
  Primary Key (04:32) T
  Foreign Key (04:35) T
  Candidate Key (03:22) T
Retrieving Data
  The Select Statement (05:16) T
  Column Aliases (03:00) T
  Joining Tables pt. 1 (04:47) T
  Joining Tables pt. 2 (03:50) T
  Scalar Functions (04:29) T
  UDF (06:00) T
Modifying Data
  Inserting Data (05:36) T
  Updating Data (02:44) T
  Deleting Data (02:26) T
  Output Clause (05:17) T
  Merge Clause (02:38) T
Managing Transactions
  Understanding Transactions (05:33) T
  Explicit Transactions (04:00) T
  Transaction Isolation Levels (06:20) T
Programming Objects
  Understanding Views (05:25) T
  Indexed Views (04:46) T
  Understanding Stored Procs (05:53) T
  Creating Stored Procs (05:04) T
  Using Parameters (05:51) T
  Temporary Tables (05:41) T
  Common Table Expressions (05:34) T
  Table Variables (05:32) T
  Temp Common or Table (05:52) T
  Dynamic SQL (04:53) T
Indexes
  Understanding Indexes (05:38) T
  Indexing Guidelines (04:56) T
  Clustered or Non-Clustered (04:57) T
  Creating Indexes (05:16) T
  Monitoring Indexes (06:19) T
Course Wrap-Up
  Course Wrap-Up (05:11) T
Credits
  About The Author (02:42) T

Course Information

Course:

Microsoft SQL Server 2008 Development

Author: Mark Long
SKU: 34119
ISBN: 1-936334-26-7
Release Date: 2010-05-20
Duration: 6 hrs / 69 tutorials
Work Files: Yes
Captions: Available on CD and Online University

Search within Captions

 

Subscription / Purchase Information

Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course. Sign up for a Free Trial
Full Access Members have full access to VTC.com's entire library of video tutorials. If you are already a member, please login here.

Learn More

Also Available in CD format

Single User: US$ 99.95Add to Cart