Publisher's Synopsis
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
