Device Details
Model: SQLUSA	Media: CD-ROM	Hardware Platform: COMPUTER	Running Machine: Windows

Test All Deals

Add to wish Listing

Purchaser Critiques

Description

CD-ROM 1 – Pattern DATABASES (2 hours Forty Seven minutes)
1. Putting In SQL Server Sample Databases
2. Conceptual Diagram of AW2008 Entity Adaptation
3. Visio Diagram of AdventureWorks2008 Database
4. Main Key and International Key; RDBMS Basics
5. 1NF, 2NF & 3NF Standard Types in AdventureWorks2008
6. AdventureWorks2008; Bike Manufacturer OLTP DB
7. AW2008 Industry Situations & AW Information Dictionary
Eight. Reviewing AdventureWorks2008 New Features
9. AdventureWorksDW2008 Knowledge Warehouse Database
10. HierarchyID Based Bushes in AdventureWorks2008
11. Creating, Saving & Emailing Database Diagrams
12. pubs Guide Publishing Pattern Database Overview
Thirteen. Northwind Meals & Drink Supplier Sample DB
14. Developed Evaluation of pubs Database Diagram
15. Developed Assessment of Northwind Database Diagram
16. Accounting DB Overview: GL, AP, AR & Stock

CD-ROM 2 – DATABASE DESIGN (2 hours 54 minutes)
1. Understanding Logical Data Modelling
2. Working with Table Column Knowledge Types
Three. New; DATE, TIME, DATETIMEOFFSET & DATETIME2
Four. CREATE Table THROUGH 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 Desk and Altering Tables BY WAY OF MS
11. Designing Compressed Tables & Indexes
12. Partitioned Table, Partition Operate and Scheme
Thirteen. Create Partition & Handle Partition Wizards
14. the info Compression Wizard
15. Code, Translate and Look Up Table Design
Sixteen. Database Design and Programming Requirements

CD-ROM Three – MAKE A SELECTION Commentary (3 hours 1 minute)
1. Internal Sign Up For, Self Join, Outer Subscribe To and Go Join
2. Working Out Basic SQL MAKE A CHOICE Statements
3. Sorting MAKE A SELECTION Query Outcomes with ORDER VIA
Four. Exploring CTEs, Nested & Correlated Subqueries
5. CHOOSE with UNION, UNION ALL, ROLLUP and DICE
6. Date & Time, String and Math Machine Capabilities

Platforms

Home Windows

Product Features

• Sensible SQL Server 2008 Programming on 7 Full-Movement Video & Audio CD-ROMs VIA a database/Industry intelligence trade expert.
• Moving monitor image video with heritage narration & cursor motion/click on highlighting.
• For C#, VB, .Net, Chilly Fusion, Web, Java, C++ and database builders, systems analysts, and Tool engineers.
• Pause the video every time and apply along by yourself replica of SQL Server 2008. Many Sensible T-SQL scripts in the lesons and on the bonus CD.
• Like Training one-on-one with an skilled database professional, every unit is introduced in full-Motion monitor picture video permitting you to look the steps and hear the reasons.

More Small Print
Writer: Silico-Magnetic In..	Class: Training & Tutorials	Binding: CD-ROM

Comments