United States 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 | |
Email this Page 
Send us FeedbackCourse 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.