Editorial Reviews:
|
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
|
|
