|
Crash Course in Microsoft SQL Server 2000 on 3 CD-ROMs | 
 enlarge | From: Silico-Magnetic Intelligence Corp.
Category: Software
List Price: $295.00
Buy New: $165.00
You Save: $130.00 (44%)
New (2) from $165.00
Sales Rank: 21451
Format: Cd
Media: CD-ROM
Operating System: Windows
Shipping Weight (lbs): 4
Dimensions (in): 12 x 10 x 2
Model: 1.1
UPC: 850171001012
EAN: 0850171001012
ASIN: B0008378P4
Availability: Usually ships in 1-2 business days
| |
| Features:
| • | SQL Server 2000 administration, design & programming | | • | Guru-level expert trainer with practical experience | | • | Overview course on 3 full-motion video/audio cd-roms | | • | Excellent training with lots of introductory examples | | • | Full-motion screen shots with audio narration |
|
| Editorial Reviews:
Product Description
CD-ROM 1 (145 min) 1. Introduction and Welcome Notes 2. Relational Database Systems 3. Relational Database Design 4. The SQL Language 5. Entity-Relationship Modeling 6. Microsoft SQL Server 2000 7. SQL Server 2000 Program Group 8. The Query Analyzer 9. The Enterprise Manager 10. The pubs and Northwind Sample Databases 11. Writing simple SQL Queries 12. Managing Simple Database Objects 13. Transact-SQL Identifiers and Comments 14. Transact-SQL Keywords and Data Types 15. Numeric, Date and String Functions 16. DDL - Data Definition Language CD-ROM 2 (148 min) 1. SELECT Statement with the WHERE Clause 2. SELECT with Subqueries 3. GROUP BY Clause and Aggregate Functions 4. Joining Tables with Primary and Foreign Keys 5. Correlated Subqueries and Temporary Tables 6. Populating Tables with INSERT, UPDATE and DELETE 7. Transact-SQL IF and WHILE Statements 8. Stored Procedures and User-Defined Functions 9. Creating Views 10. Table Indexing and Query Optimization 11. Permissioning GRANT, REVOKE and DENY 12. AFTER Triggers and INSTEAD OF Triggers 13. Transactions, Blocking and Deadlocks 14. bcp, osql, isql and odbcping Utilities 15. Database Backup and Restore 16. DTS, Data Transformation Services CD-ROM 3 (143 min) 1. SQL Server Agent, Setting up Jobs 2. Defining Alerts for Application Errors 3. Troubleshooting, sp_who, sp_monitor 4. SQL Server 2000 and Windows Logs 5. DBCC Utility for Database Maintenance 6. Performance Tuning SQL Server 2000 7. Application Performance Tuning 8. SQL Server 2000 Profiler 9. Data Replication Across Servers 10. XML Support in SQL Server 2000 11. Datawarehousing, Datamarts 12. OLAP, MOLAP, ROLAP and HOLAP 13. Microsoft Analysis Services 14. Designing OLAP CUBEs 15. SQL Server 2000 FullText Search 16. Success Secrets to SQL Server 2000
|
|
|
| |
