Crash Course in Microsoft SQL Server 2000 on 3 CD-ROMs: Software: Online shopping for Computers, Programming, Internet Books, Software, Dowbloads, PDF, ebooks, and more. Get selection of Books, and Software by Subjects, Programming, Home & Office, Computer Science, Software, Web Development, Networking & more at everyday low prices. Technical and computer books. Computer books, some available at half of the cover price. Online computer bookstore featuring books and training. Offers the latest publications on computers and computing, such as information on hardware, software applications, and all other areas of information technology. Offering computer science, computer engineering, computer programming and computer software books. nline shopping for Databases Computers & Internet from a great selection of Books; Subjects, Data Storage & Management, Specific Databases, Oracle & more at everyday low prices. Online shopping for Graphic Design from a great selection of Books; Computers & Internet, Subjects, Desktop Publishing, Web & Multimedia, CAD, Applications, Printing, System Architecture, Microprocessors & System Design, PCs, Macs, Peripherals, Operating Systems, Applications, Development, Certifications, Microsoft, Unix, Linux, Theory, MacOS, OS-2, DOS, Design & Development, Business, Word Processors & Editors, Spreadsheets, File Systems, Internet Commerce, HTML, Graphics, & Design, Security & Encryption & more at everyday low prices. All major publishers like O'Reilly, Microsoft Press Technical Solutions Center, Sybex, Cisco Press & more at everyday low prices.: Online shopping for Computers & Internet from a great selection of Books; Subjects, Programming, Home & Office, Computer Science, Software, Web Development, Networking & more at everyday low prices.

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: 21322

Format: Cd
Media: CD-ROM
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

Technology Focus