Super Ebook

so the Crash Course is an intense 15-hour learning period. You can complete the Crash Course over a weekend — but you can also easily adapt the Crash Course sessions to whatever schedule best suits your needs.

From the Back Cover
Get up to Speed on SQL Server 2000 — in a Weekend!
The big day is Monday. The day you get to show off what you know about SQL Server 2000. The problem is, you’re not really up to speed. Maybe it’s been a while since you worked with SQL Server. Or maybe you just like a challenge. In any event, we’ve got a solution for you — Microsoft SQL Server 2000 Weekend Crash Course. Open the book Friday evening and by Sunday afternoon, after completing 30 fast, focused sessions, you’ll be able to get right to work on a SQL Server 2000 databases. It’s as simple as that.

THE CURRICULUM
FRIDAY
Evening: 4 Sessions, 2 Hours
Microsoft SQL Server 2000: Getting Started; Go Configure: After Installation; First Look at Enterprise Manager Console; Second Look at Enterprise Manager Console

SATURDAY
Morning: 6 Sessions, 3 Hours
Relational Database Concepts; SQL Server Databases; Creating and Using a Custom Database; Transact-SQL Programming; SQL Query Analyzer; More Transact-SQL Programming
Afternoon: 6 Session, 3 Hours
Creating and Using Stored Procedures; OSQL and ISQL; Introducing Cursors; Understanding Transactions; Locking; Rules, Default, and Constraints
Evening: 4 Sessions, 2 Hours
Data Transformation; SQL Server Back Up; SQL Server Replication; User Management

SUNDAY
Morning: 6 Sessions, 3 Hours
Managing Your Databases — Visually; Microsoft Distributed Transaction Coordinator; System Functions and Stored Procedures; Automating Administration Tasks with SQL Server Agent; SQL Mail Agent; Performance Tuning and Optimization
Afternoon: 4 Sessions, 2 Hours
Disaster Recovery; SQL Server Security; Database Connectivity; Advanced Features of Microsoft SQL Server 2000

2 CD-ROMs INCLUDED:
SQL Server 2000 120-day Evaluation Edition
SQL Programmer trial version
Evaluation versions of database utilities, including Rapid SQL, DB Artisan, and ER/Studio
Web links to useful SQL Server sites
Sample code and script
Assessment software