Binding: CD-ROM
Brand: SQLUSA
EAN: 0850171001050
Format: CD
Label: Silico-Magnetic Intelligence Corp.
Manufacturer: Silico-Magnetic Intelligence Corp.
Model: 1.2
Publisher: Silico-Magnetic Intelligence Corp.
Sales Rank: 18755
Studio: Silico-Magnetic Intelligence Corp.
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 Review:
Product DescriptionCD-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
Average Rating: 
Rating: - Great Course
Complex topics were explained at a slow pace and in a way that was easy for me to understand..
|
