Microsoft^® SQL Server 2000 Weekend Crash Course^TM

by Alex Kriegel

• ISBN13: 9780764548406
• ISBN10: 0764548409
• Edition: CD
• Format: Paperback
• Copyright: 2001-10-01
• Publisher: Wiley

Summary

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.

Author Biography

<b>Alex Kriegel</b> is a Microsoft Certified Solution Developer who is employed by Psion Teklogix International, Inc., Integration Services Group.<br> 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.<br> ition 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.

Table of Contents

Preface	vii
Acknowledgments	xiii
FRIDAY	2	(2)
Part I---Friday Evening	4	(44)
Getting Started	5	(14)
Go Configure	19	(10)
First Look at Enterprise Manager Console	29	(8)
Second Look at Enterprise Manager Console	37	(11)
SATURDAY	48	(2)
Part II---Saturday Morning	50	(74)
Relational Database Concepts	51	(10)
SQL Server Databases	61	(12)
Creating and Using a Custom Database	73	(8)
Transact-SQL Programming Language	81	(14)
T-SQL and SQL Query Analyzer	95	(12)
Programming with T-SQL	107	(17)
Part III---Saturday Afternoon	124	(66)
Creating and Using Stored Procedures	125	(12)
Trigger Happy	137	(8)
Introducing Cursors	145	(10)
Understanding Indexes	155	(12)
Rules, Defaults, and Constraints	167	(10)
Understanding Transactions and Locks	177	(13)
Part IV---Saturday Evening	190	(48)
Data Transformation Services	191	(10)
SQL Server Back Up	201	(12)
SQL Server Replication	213	(12)
User Management	225	(13)
SUNDAY	238	(2)
Part V---Sunday Morning	240	(68)
Managing Your Databases Visually	241	(10)
Distributed Transaction Coordinator	251	(12)
Accessing SQL Server System Information	263	(10)
Automating Administration Tasks with SQL Server Agent	273	(10)
Configuring SQL Server Mail	283	(10)
Performance Tuning and Optimization	293	(15)
Part VI---Sunday Afternoon	308	(47)
Disaster Recovery	309	(10)
SQL Server Security	319	(12)
Database Connectivity	331	(10)
Advanced Features of Microsoft SQL Server 2000	341	(14)
Appendix A-Answers to Part Reviews	355	(12)
Appendix B-What's on the CD-ROM?	367	(4)
Index	371	(12)
Hungry Minds, Inc. End-User License Agreement	383	(3)
CD-ROM Installation Instructions	386