|
Microsoft SQL Server 2000 Programming on 7 CD-ROMs | 
 enlarge | From: Silico-Magnetic Intelligence Corp.
Category: Software
List Price: $495.00
Buy New: $325.00
You Save: $170.00 (34%)
Sales Rank: 22723
Format: Cd
Media: CD-ROM
Operating System: Windows
Shipping Weight (lbs): 6
Dimensions (in): 12 x 10 x 2
Model: 0008
UPC: 850171001043
EAN: 0850171001043
ASIN: B0008394U6
Availability: Usually ships in 1-2 business days
| |
| Features:
| • | SQL Server 2000 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
SAMPLE DATABASES (92 min) 1. Primary Key and Foreign Key 2. Pubs Database 3. Northwind Database 4. More on Pubs 5. More on Northwind 6. Advanced Pubs 7. Advanced Northwind DATABASE DESIGN (142 min) 1. Logical Data Modelling 2. Data Types for Table Columns 3. Creating Tables by Statements 4. Additional Create Table Examples 5. Create Special Tables and Copy Tables 6. Observing Table Behaviour 7. Creating Tables 8. Primary Key and Foreign Key Constraints 9. ALTER TABLE 10. Normalization and Debated Design Issues 11. Database Design and Programming Standards THE SELECT STATEMENT (122 min) 1. Inner Join, Outer Join and Cross Join 2. The SELECT Statement 3. SELECT Featuring ORDER BY 4. SELECT with Subqueries 5. SELECT Featuring COMPUTE 6. SELECT with String, Date and Math Functions 7. SELECT with Statistical Functions 8. Dynamic SQL 9. SELECT with GROUP BY Clause MODIFY DATA (80 min) 1. Table INSERT 2. INSERT Statement with VALUES 3. INSERT.....SELECT 4. DELETE Statement 5. UPDATE Statement 6. Cursors and Subqueries 7. Nonlogged Operations DATA INTEGRITY (80 min) 1. Entity, Domain, and Referential Integrity 2. Entity Integrity Definition 3. Scripting Tables and Related Objects 4. Domain Integrity Constraints 5. Referential Integrity 6. User Defined Data Integrity Objects 7. Business Rules PROGRAMMING OBJECTS (100 min) 1. Simple Stored Procedures 2. Stored Procedures with the OUTPUT Parameters 3. Stored Procedures in the Northwind 4. CREATE TRIGGER 5. Trigger with DELETED and INSERTED Tables 6. INSTEAD OF and AFTER Triggers 7. Views Definition 8. CREATE FUNCTION 9. Temporary Tables TRANSACT-SQL (98 min) 1. TRANSACT-SQL, Batch, and Scripts 2. BEGIN, COMMIT, ROLLBACK TRANSACTION 3. Locks, Isolation Levels and Deadlocks 4. PROGRAMMING STATEMENTS 5. User Defined and System Stored Procedures 6. Linked Servers and 4-part Addressing 7. DBA Script Generator 8. Undocumented T-SQL Features
|
|
|
| |
