Guidance Business Help Education Computers Help Teaching PC Tutoring Tutorials Laptop DVDs Support Programming Support Instruction Business Instruction Help Business Instruction
Office Software - Excel Software - Microsoft Software - QuickBooks Software - Visual Software - Comptuer Software - Web Software - Sharepoint Software - Photoshop Software - Mac Software - QuarkXPress Software - management Software - Project Software - Learn Software - email Software - Network Software - Linux Software - Unix Software - Work Software - Net Software - ASP Software - PHP Software - HTML Software - CMS Software - XML Software - Mobile Software -
Online Design Lessons Online Laptop DVDs Training Word Instruction DVDs Business Tutoring Tutorials Programming Instruction Learning Workstation Instruction Lessons Certification Guidance

Microsoft SQL Server 2008 Development Training

More Microsoft SQL Server 2008 Development Categories
Microsoft SQL Server 2008 Development Tutorials Online
Product Microsoft SQL Server 2008 DevelopmentDetails
Total Time : 6 hrs
Number of Movies : 69
Number of Discs : 1
Catalogue Number :34119
Language : english
Author : Mark Long

Purchase Below

Description Microsoft SQL Server 2008 Development
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.
Sample - Preview the First 3 chapters of Microsoft SQL Server 2008 Development video free. Free learning Microsoft SQL Server 2008 Development online.
01 Introduction
0101 Welcome
0102 Course Overview
0103 SQL Server Basics
0104 Getting Hands On
0105 Microsoft SQL Certifications
0106 SQL Server Editions
0107 SQL Server Developer
02 Getting Set Up
0201 Hardware Requirements
0202 SQL Server Instances
0203 SQL Server Components
0204 Service Accounts
0205 Installing SQL Server 2008 pt. 1
0206 Installing SQL Server 2008 pt. 2
0207 Installing SQL Server 2008 pt. 3
0208 SQL Authentication Modes
0209 Installing Sample Databases pt. 1
0210 Installing Sample Databases pt. 2
03 Database Design
0301 Database Types
0302 Normalization
0303 Normalization Benefits
0304 Database Diagrams
0305 Systematic Database Design
0306 Designing Database Objects
04 Tables & Views
0401 Table Basics
0402 Creating a Table pt. 1
0403 Creating a Table pt. 2
0404 Creating a Table pt. 3
0405 Data Types
0406 Unicode Basics
0407 New Data Types In 2008
0408 Character Types
0409 Exact Numerics
0410 Approximate Numeric Types
0411 Date & Time
0412 Null or Not Null
0413 Primary Key
0414 Foreign Key
0415 Candidate Key
05 Retrieving Data
0501 The Select Statement
0502 Column Aliases
0503 Joining Tables pt. 1
0504 Joining Tables pt. 2
0505 Scalar Functions
0506 UDF
06 Modifying Data
0601 Inserting Data
0602 Updating Data
0603 Deleting Data
0604 Output Clause
0605 Merge Clause
07 Managing Transactions
0701 Understanding Transactions
0702 Explicit Transactions
0703 Transaction Isolation Levels
08 Programming Objects
0801 Understanding Views
0802 Indexed Views
0803 Understanding Stored Procs
0804 Creating Stored Procs
0805 Using Parameters
0806 Temporary Tables
0807 Common Table Expressions
0808 Table Variables
0809 Temp Common or Table
0810 Dynamic SQL
09 Indexes
0901 Understanding Indexes
0902 Indexing Guidelines
0903 Clustered or Non-Clustered
0904 Creating Indexes
0905 Monitoring Indexes
10 Course Wrap-Up
1001 Course Wrap-Up
11 Credits
1101 About The Author
sku