SQL Server 2008 Books

All SQL Server 2008 Books

Integration Services (SSIS)

Reporting Services

Analysis Services

Location: Home » SQL Server Software » Practical SQL Server 2008 Programming on 7 CD-ROMs

List by Topic

•	All SQL Server 2008 Books
•	Integration Services (SSIS)
•	Reporting Services
•	Analysis Services
•	Data Warehouse
•	Spatial Data
•	SQL Server Software

Related Categories

•	Training & Tutorials

Programming

Practical SQL Server 2008 Programming on 7 CD-ROMs

enlarge

From: Silico-Magnetic Intelligence Corp.
Category: Software

Buy New: $675.00
as of 7/30/2010 03:43 CDT details

New (2) from $675.00

Seller: eMediaGrand
Sales Rank: 26075

Format: CD-ROM
Platform: Windows
Media: CD-ROM
Operating System: Windows

UPC: 850171001128
EAN: 0850171001128
ASIN: B001OHWV4G

Availability: Usually ships in 1-2 business days

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.

Editorial Reviews:

Product 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

CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.