|
Microsoft SQL Server 2005 Programming on 7 CD-ROMs | 
 enlarge | From: Silico-Magnetic Intelligence Corp.
Category: Software
List Price: $695.00
Buy New: $675.00
You Save: $20.00 (3%)
New (2) from $675.00
Rating:  1 reviews
Sales Rank: 18551
Format: Cd
Media: CD-ROM
Operating System: Windows
Shipping Weight (lbs): 4
Dimensions (in): 12 x 10 x 2
Model: 1.2
UPC: 850171001050
EAN: 0850171001050
ASIN: B00094CTMY
Availability: Usually ships in 1-2 business days
| |
| Features:
| • | SQL Server 2005 programming in Transact-SQL | | • | Guru-level industry expert trainer with practical experience | | • | Comprehensive database programming course on 7 video/audio cd-roms | | • | Excellent training with lots of practical programming examples | | • | Full-motion screen shots with enhanced audio narration |
|
| Editorial Reviews:
Product Description
CD-ROM 1 - SAMPLE DATABASES (1 hour 36 minutes) 1. Diagram of AdventureWorks Database 2. RDBMS Basics 3. AdventureWorks 4. Pubs DB 5. Northwind DB 6. More on Pubs 7. More on Northwind 8. Advanced Pubs 9. Advanced Northwind CD-ROM 2 - DATABASE DESIGN (3 hours 5 minutes) 1. Logical Data Modelling 2. Data Types 3. Creating Tables by Statements 4. Advanced Create 5. Copy Tables 6. Table Behaviour 7. Creating by Management Studio 8. Primary Key and Foreign Key Constraints 9. ALTER TABLE 10. Partitioned Table, Partition Function and Scheme 11. Normalization 12. Database Design and Programming Standards CD-ROM 3 - THE SELECT STATEMENT (2 hours 41 minutes) 1. Inner, Self, Outer and Cross 2. SELECT Queries 3. ORDER BY 4. Subqueries 5. COMPUTE 6. String, Date and Math Functions 7. Statistical Functions 8. Dynamic SQL 9. GROUP BY 10. PIVOT and UNPIVOT 11. Recursive Queries 12. ROW_NUMBER, RANK, DENSE_RANK and NTILE 13. TOP, TABLESAMPLE, SOME and ANY CD-ROM 4 - MODIFY DATA (2 hours 18 minutes) 1. INSERT Statement 2. INSERT-SELECT 3. INSERT-EXEC 4. DELETE 5. UPDATE 6. Cursors 7. Logged and Nonlogged Operations 8. Common Table Expression - CTE 9. The OUTPUT Clause CD-ROM 5 - DATA INTEGRITY (1 hour 40 minutes) 1. Entity, Domain and Referential Database Integrity 2. Entity Integrity 3. Scripting Tables 4. Domain Integrity 5. Referential Integrity 6. User Defined 7. Business Rules Enforcement with Triggers 8. Visio 9.Design with Visio CD-ROM 6 - PROGRAMMABILITY (2 hours 30 minutes) 1. Stored Procedures 2. OUTPUT Parameters 3. Sprocs in AdventureWorks 4. TRIGGER 5. DELETED and INSERTED 6. INSTEAD OF and AFTER 7. DDL Triggers 8. Views 9. FUNCTION 10. Assembly 11. tempdb 12. EXECUTE AS CD-ROM 7 - TRANSACT-SQL (2 hours 55 minutes) 1. TRANSACT-SQL, Batch, and Scripts 2. BEGIN, COMMIT, ROLLBACK TRANSACTION 3. TRY, CATCH 4. Locks 5. PROGRAMMING 6. User Defined 7. Linked Servers 8. CROSS and OUTER APPLY 9. DBA Script Generator 10. Undocumented T-SQL Features
|
| Customer Reviews:
Great Course March 15, 2006
2 out of 3 found this review helpful
Complex topics were explained at a slow pace and in a way that was easy for me to understand..
|
|
|
| |
