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.
FREE Two-Day Shipping for students on millions of items. Learn more |
| ||||||||||||
Book Description
Editorial Reviews
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
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.
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.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
15 of 15 people found the following review helpful:
5.0 out of 5 stars
I am not afraid anymore :),
By Dave Rutherford (Chaska, MN USA) - See all my reviews
This review is from: Microsoft SQL Server 2000 Weekend Crash Course (Paperback)
Two thumbs up. My SQL Server is up and running; now I have time to explore things I really need (yes, I had to buy more books)I've read many books that'd done a good job to scare me away from the subject ; this one hides the complexity until one's ready for it.
17 of 18 people found the following review helpful:
5.0 out of 5 stars
Great SQL Server 2000 Overview,
By
This review is from: Microsoft SQL Server 2000 Weekend Crash Course (Paperback)
If you are looking for a book that will provide overview of SQL Server 2000 without diving into too many details - This is the book for you!This book glances through all the main features of SQL Server 2000, providing a very good introduction to all of them. SQL Server 2000 is a very complex, feature rich product. This book does a wonderful job of explaining the various features with out going to too many details that 99% of the users will not need anyway. I especially liked the sections about performance tuning, optimizations and automating administration tasks that provide easy to understand information about those advanced SQL Server features. If you are a full time job SQL Server DBA, you will probably want a more in depth book. All other SQL Server users - Go get this book!
13 of 13 people found the following review helpful:
5.0 out of 5 stars
'Tis Worth The Buck!,
By A Customer
This review is from: Microsoft SQL Server 2000 Weekend Crash Course (Paperback)
A good book. Definitely took me longer than 3 days to get through it,but I was off to a good start from the beginning. The chapter on Transact-SQL could be better and I am not sure why would I need Replication - for now; but again this is "jack-of-all-trades" kind of a book Worth its money, in short.
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
This session will introduce you to SQL Server and guide you through the installation process step-by-step. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
collation order, information schema views, estimated execution plan, standby server, temporary stored procedure, extended stored procedures, nested triggers, linked servers, database roles, clustered index, snapshot replication, master database, authentication mode, system stored procedures, using stored procedures, implicit transactions, transaction coordinator, primary server, custom database, heterogeneous data sources, sufficient privileges, server roles, log backup, database backup, transaction log Key Phrases - Capitalized Phrases (CAPs): (learn more)
Enterprise Manager, Server Agent, Books Online, Session Checklist, English Query, Data Transformation Services, Index Tuning Wizard, Sunday Morning, Distributed Transaction Coordinator, Help Figure, Saturday Morning, Server Service Manager, Cancel Figure, Saturday Evening, Saturday Afternoon, Web Assistant Wizard, All Tasks, Backup Wizard, Friday Evening, Microsoft Access, Analytical Services, Create Database Wizard, Export Wizard, Internet Information Server, Object Browser New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
This session will introduce you to SQL Server and guide you through the installation process step-by-step. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
collation order, information schema views, estimated execution plan, standby server, temporary stored procedure, extended stored procedures, nested triggers, linked servers, database roles, clustered index, snapshot replication, master database, authentication mode, system stored procedures, using stored procedures, implicit transactions, transaction coordinator, primary server, custom database, heterogeneous data sources, sufficient privileges, server roles, log backup, database backup, transaction log Key Phrases - Capitalized Phrases (CAPs): (learn more)
Enterprise Manager, Server Agent, Books Online, Session Checklist, English Query, Data Transformation Services, Index Tuning Wizard, Sunday Morning, Distributed Transaction Coordinator, Help Figure, Saturday Morning, Server Service Manager, Cancel Figure, Saturday Evening, Saturday Afternoon, Web Assistant Wizard, All Tasks, Backup Wizard, Friday Evening, Microsoft Access, Analytical Services, Create Database Wizard, Export Wizard, Internet Information Server, Object Browser New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Citations (learn more)
Books on Related Topics
(learn more)
|
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
Listmania!
So You'd Like to...
Look for Similar Items by Category
- Books > Computers & Technology > Databases > Relational Databases
- Books > Computers & Technology > Databases > SQL
- Books > Computers & Technology > Microsoft > Development > SQL Server
- Books > Computers & Technology > Programming > Languages & Tools
- Books > Computers & Technology > Software
- Books > Computers & Technology > Web Development > Web Design
- Books > New & Used Textbooks > Computer Science > Database Storage & Design
- Books > New & Used Textbooks > Computer Science > Programming Languages
