Microsoft SQL server 2000 weekend crash course

Microsoft SQL Server 2000 Weekend Crash Course includes 30 sessions on the key aspects of Microsoft SQL Server 2000. Each session is designed to take 30 minutes to complete, 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.

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

This text includes 30 sessions on key aspects of Microsoft SQL Server 2000. It is accompanied by two CD-ROMs; one includes all example files, software to evaluate progress, and useful tools, and the other includes a trial of Microsoft SQL Server 2000. Users can learn the fundamentals of Microsoft SQL Server in only 15 hours and gain hands-on experience using a trial version of Microsoft SQL Server 2000 included on the two CD-ROMs. This session will introduce you to SQL Server and guide you through the installation process step-by-step.