Product Description

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.

Product Details

• Amazon Sales Rank: #525471 in Books
• Published on: 2001-10-01
• Original language: English
• Number of items: 2
• Binding: Paperback
• 408 pages

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

About the Author
Alex Kriegel is a Microsoft Certified Solution Developer who is employed by Psion Teklogix International, Inc., Integration Services Group.
Psion Teklogix International Inc, Integration Services′s main product is TekRF Integration Components for SAP R/3, which serve as middleware that interfaces terminals into a SAP R/3 System. Alex′s company also supplies custom transaction sets to perform all kinds of warehouse operations like picking, put away, and inventory count. Among other technologies, Psion′s application uses Microsoft SQL Server 6.
In addition to his programming job, Alex has been responsible for troubleshooting SQL Server installations for customers around the world, optimizing performance and devising SQL stored procedures. He has also conducted an internal, hands–on training course on SQL Server for Psion′s SAP analysts. It consists of three 2–hour sessions and targets a beginning to intermediate audience.

Customer Reviews

Good book for learning the basics of SQL Server
I'm a certified Oracle DBA and picked up this book with no prior knowledge of SQL Server. After reading it twice and playing with the evaluation version of SQL Server 2000 that comes on the accompanying CD I have gained a good understanding of the product and have grown quite competent in administering SQL Server 2000 databases. Whilst this book doesnt attempt to tell the reader everything possible about SQL Server, (There are other books on the market that attempt to do this but they assume a prior knowledge of the product) it achieves what it sets out to do by giving the reader a solid grounding in the technology. After reading this book I am now able to navigate, use and administer SQL Server 2000 databases at one of my client's sites and although my no means have I become a SQL Server guru I would feel confident to state to prospective clients that I had relevant and current SQL Server skills.

Install and run MS SQL server in 1..2..3..
Impressed with this introductory book on MS SQL and it delivered what the author says in preface "no-nonsense, hands-on introduction to SQL Server". It doesn't make you a SQL database administrator with in a weekend but it surely let you Know how to up and running SQL server in a weekend. It's easy to understand and first step to more advanced level.