Tutorials and Online Training Videos
Home
Contact Us
Client Login
Employee Login
Online Training Videos
All Videos in English
All Videos in French
All Videos in Spanish
All Training Videos
Articles
Resources
Humor
Site Search
Home
>
Tutorials and Online Training Videos
>
Microsoft SQL Server 2008 Development Tutorial
Microsoft SQL Server 2008 Development Tutorial
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.
Introduction
Welcome
Course Overview
SQL Server Basics
Getting Hands On
Microsoft SQL Certifications
SQL Server Editions
SQL Server Developer
Getting Set Up
Hardware Requirements
SQL Server Instances
SQL Server Components
Service Accounts
Installing SQL Server 2008 pt. 1
Installing SQL Server 2008 pt. 2
Installing SQL Server 2008 pt. 3
SQL Authentication Modes
Installing Sample Databases pt. 1
Installing Sample Databases pt. 2
Database Design
Database Types
Normalization
Normalization Benefits
Database Diagrams
Systematic Database Design
Designing Database Objects
Get access to the full library of online tutorials
US$30/month or US$250/year
Microsoft SQL Server 2008 Development Tutorials on CD
US$99.95
Tables & Views
Table Basics
Creating a Table pt. 1
Creating a Table pt. 2
Creating a Table pt. 3
Data Types
Unicode Basics
New Data Types In 2008
Character Types
Exact Numerics
Approximate Numeric Types
Date & Time
Null or Not Null
Primary Key
Foreign Key
Candidate Key
Retrieving Data
The Select Statement
Column Aliases
Joining Tables pt. 1
Joining Tables pt. 2
Scalar Functions
UDF
Modifying Data
Inserting Data
Updating Data
Deleting Data
Output Clause
Merge Clause
Managing Transactions
Understanding Transactions
Explicit Transactions
Transaction Isolation Levels
Programming Objects
Understanding Views
Indexed Views
Understanding Stored Procs
Creating Stored Procs
Using Parameters
Temporary Tables
Common Table Expressions
Table Variables
Temp Common or Table
Dynamic SQL
Indexes
Understanding Indexes
Indexing Guidelines
Clustered or Non-Clustered
Creating Indexes
Monitoring Indexes
Course Wrap-Up
Course Wrap-Up
Credits
About The Author
Get access to the full library of online tutorials
US$30/month or US$250/year
Microsoft SQL Server 2008 Development Tutorials on CD
US$99.95
Related Books on Microsoft SQL Server 2008 Development
All Videos in English
All Videos in French
All Videos in Spanish
All Videos
Popular Video Tutorials
FL Studio 10
Adobe Audition CS5.5
CorelDRAW Graphics Suite 11 (Español)
ASP Scripting
Introduction to Microsoft C# 2008
Corel Painter 12
Cakewalk SONAR X1 Producer Edition
Game Development for iPhone/iPad Using Unity iPhone
Adobe PageMaker 7
Microsoft Visual Studio 2010
Real-World Programming With PHP 5
Cisco CCNA/ICND (Español)
MasterClass! - Adobe LiveCycle Designer
Adobe Encore CS5
Oracle Database Administration Fundamentals I (Español)
Microsoft Visual C# .NET
Programming with Alice
Microsoft Publisher 2003 (Español)
Adobe Audition 1.5
Google SketchUp Pro 8
Adobe Captivate 5
Maxwell Render 2
Microsoft ASP.NET 3.5
QuickStart! - Adobe Dreamweaver CS5.5
Autodesk 3ds max 8
MySQL 5 Development (Part 1)
Microsoft Transact SQL (Español)
Adobe Photoshop CS5
Macromedia RoboHelp X5
Adobe After Effects 5/5.5 Essentials
Save $80
on the
DROID BIONIC
by Motorola with Verizon Wireless service for less than from Verizon Wireless directly.
More Cell Phone Discounts