|
| List Price: | $695.00 |
| Average Rating: |  |
| Lowest New Price: | $675.00 |
|
 |
|
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
Average Customer Review:
2 of 3 people found the following review helpful:
Great Course, 2006-03-15
Complex topics were explained at a slow pace and in a way that was easy for me to understand..
Price is accurate as of the date/time indicated. Prices and product availability are subject to change. Any price displayed on the Amazon website at the time of purchase will govern the sale of this product.
|
|