1209581
9780764548406
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 softwareKriegel, Alex is the author of 'Microsoft SQL Server 2000 Weekend Crash Course' with ISBN 9780764548406 and ISBN 0764548409.
[read more]