Practical SQL Server 2008 Programming on 7 CD-ROMs by SQLUSA

Description

CD-ROM 1 – SAMPLE DATABASES (2 hours 47 minutes)
1. Installing SQL Server Sample Databases
2. Conceptual Diagram of AW2008 Entity Model
3. Visio Diagram of AdventureWorks2008 Database
4. Primary Key and Foreign Key; RDBMS Basics
5. 1NF, 2NF & 3NF Normal Forms in AdventureWorks2008
6. AdventureWorks2008; Bike Manufacturer OLTP DB
7. AW2008 Business Scenarios & AW Data Dictionary
8. Reviewing AdventureWorks2008 New Features
9. AdventureWorksDW2008 Data Warehouse Database
10. HierarchyID Based Trees in AdventureWorks2008
11. Creating, Saving & Emailing Database Diagrams
12. pubs Book Publishing Sample Database Overview
13. Northwind Food & Drink Supplier Sample DB
14. Advanced Review of pubs Database Diagram
15. Advanced Review of Northwind Database Diagram
16. Accounting DB Review: GL, AP, AR & Inventory

CD-ROM 2 – DATABASE DESIGN (2 hours 54 minutes)
1. Understanding Logical Data Modelling
2. Working with Table Column Data Types
3. New; DATE, TIME, DATETIMEOFFSET & DATETIME2
4. CREATE TABLE by Script & Using Object Explorer
5. Primary Key and Foreign Key Constraints
6. Database Diagram Design in Object Explorer
7. Logical Database Modelling with Visio
8. Relational Database Design with Visio
9. Reverse Engineering a Database with Visio
10. ALTER TABLE and Changing Tables by MS
11. Designing Compressed Tables & Indexes
12. Partitioned Table, Partition Function and Scheme
13. Create Partition & Manage Partition Wizards
14. The Data Compression Wizard
15. Code, Translate and Lookup Table Design
16. Database Design and Programming Standards

CD-ROM 3 – SELECT STATEMENT (3 hours 1 minute)
1. Inner Join, Self Join, Outer Join and Cross Join
2. Understanding Basic SQL SELECT Statements
3. Sorting SELECT Query Results with ORDER BY
4. Exploring CTEs, Nested & Correlated Subqueries
5. SELECT with UNION, UNION ALL, ROLLUP and CUBE
6. Date & Time, String and Math System Functions

Platforms

Windows

Product Features

• Practical SQL Server 2008 Programming on 7 Full-Motion Video & Audio CD-ROMs by a database/business intelligence industry expert.
• Moving screen image video with background narration & cursor movement/click highlighting.
• For C#, VB, .Net, Cold Fusion, Web, Java, C++ and database developers, systems analysts, and software engineers.
• Pause the video anytime and practice along on your own copy of SQL Server 2008. Many practical T-SQL scripts in the lesons and on the bonus CD.
• Like training one-on-one with an experienced database professional, each unit is presented in full-motion screen image video allowing you to see the steps and hear the explanations.