Microsoft SQL Server 2000 Weekend Crash Course

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. Front Matter......Page 4 Who Should Read this Book......Page 8 Layout and Features......Page 9 Reach Out......Page 12 Part I Friday Evening......Page 27 Understanding Microsoft SQL Server......Page 28 Installing SQL Server 2000......Page 29 How Does SQL Server 2000 Compare to the Other Guys?......Page 39 Go Configure......Page 42 Running SQL Server Service Manager......Page 43 Managing Configuration Tasks......Page 45 Locating SQL Server Files......Page 46 Uninstalling SQL Server......Page 48 Starting the Enterprise Manager......Page 52 Creating Server Groups and Registering Servers......Page 54 Down Under: Inspecting Registered SQL Server Nodes......Page 56 Considering Your Options......Page 57 Accessing SQL Server Books Online......Page 59 Meeting the Wizards......Page 60 Running Command-Line Utilities......Page 65 Accessing SQL Server Agent......Page 67 Friday Evening Questions......Page 70 Part II Saturday Morning......Page 73 Identifying the Limitations of Spreadsheet Programs......Page 74 Understanding Legacy Database Models......Page 75 Introducing the Relational Database Model......Page 77 Exploring Relational-Database Management-System Implementations......Page 79 Learning Relational-Database Terminology......Page 81 Understanding the SQL Server System Databases......Page 84 Exploring the SQL Server Sample Databases......Page 87 Learning the Basics of Relational Database Design......Page 88 Creating a New Database in SQL Server 2000......Page 96 Modifying Database and Transaction Log Properties......Page 100 Deleting a Database......Page 102 Learning about Transact SQL......Page 104 Using the SELECT Keyword......Page 105 Working with the JOIN and UNION Keywords......Page 110 Using the INSERT, UPDATE, and DELETE Keywords......Page 113 Knowing about Additional T-SQL Keywords and Functions......Page 116 T-SQL and SQL Query Analyzer......Page 118 Creating, Altering, and Dropping Databases with T-SQL......Page 121 Creating, Altering, and Dropping Tables with T-SQL......Page 123 Getting Information about Your SQL Server......Page 125 Working with the Query Analyzer Templates and the Object Browser......Page 126 Declaring and Using T-SQL Variables......Page 130 Using Control-of-Flow Statements......Page 134 Exploring T-SQL Operators......Page 136 Running Subqueries......Page 141 Using the CASE Function......Page 142 Saturday Morning Questions......Page 144 Part III Saturday Afternoon......Page 147 Creating Stored Procedures......Page 148 Commenting Transact-SQL Code......Page 151 Error Handling......Page 152 Using Different Types of Stored Procedures......Page 155 Renaming and Dropping a Stored Procedure......Page 157 Using Stored Procedures......Page 158 Trigger Happy......Page 160 Managing Triggers......Page 166 Understanding Cursors......Page 168 Using Different Types of Cursors......Page 171 Understanding the Scope of the Cursors......Page 173 Setting Cursor Concurrency Options......Page 174 Choosing the Right Cursor......Page 175 Using Indexes......Page 178 Designing an Index......Page 180 Creating and Deleting an Index......Page 181 Managing an Index......Page 187 Enforcing Data Integrity......Page 190 Understanding NULL Values......Page 198 Understanding Transactions......Page 200 Setting Isolation Levels......Page 205 Introducing SQL Server Locks......Page 206 Exploring Lock Types......Page 207 Dealing with Deadlocks......Page 208 Saturday Afternoon Questions......Page 211 Part IV Saturday Evening......Page 213 Introducing Data Transformation Services......Page 214 Importing and Exporting Data through DTS......Page 215 Maintaining DTS Packages......Page 220 Using the Bulk Copy Command-Line Utility......Page 221 Implementing Backup and Recovery Planning......Page 224 Using Different Backup Strategies......Page 225 Selecting a Recovery Mode......Page 230 Restoring a Database......Page 231 Managing Backups......Page 234 Reviewing SQL Server Replication......Page 236 Preparing for Replication......Page 239 Setting up Replication......Page 240 Setting up a User Account......Page 248 Managing User Permissions......Page 253 Managing a Multiuser Environment......Page 256 Saturday Evening Questions......Page 258 Part V Sunday Morning......Page 263 Devising a Database-Maintenance Plan......Page 264 Scripting and Documenting Your Database......Page 270 Moving and Copying Database Files......Page 271 Using Remote Servers and Linked Servers......Page 274 Accessing External Data Sources......Page 281 Using Microsoft Distributed Transaction Coordinator (MSDTC)......Page 282 Obtaining SQL Server System Information......Page 286 Using Information Schema Views......Page 287 Using System Stored Procedures......Page 289 Configuring and Using SQL Server Agent......Page 296 Scheduling Jobs......Page 299 Creating Alerts......Page 301 Managing Operators......Page 303 Administering Multiple Servers......Page 304 Setting up Your Mail Profile......Page 306 Configuring SQL Mail and SQL Server Agent Mail......Page 309 Sending Mail through Extended Stored Procedures......Page 311 Troubleshooting......Page 312 Monitoring and Profiling......Page 316 Tuning SQL Queries......Page 319 Using the Index Tuning Wizard......Page 322 Optimizing TempDB and the Transaction Log......Page 324 Using Database Consistency Check (DBCC)......Page 325 Service Packs......Page 326 Sunday Morning Questions......Page 328 Part VI Sunday Afternoon......Page 331 Planning for Disaster......Page 332 Identifying Basic Disaster Scenarios......Page 333 Back Up and Restore!......Page 335 Managing the Disaster......Page 336 Planning for Security......Page 342 Introducing SQL Server Authentication Modes......Page 343 Configuring SQL Server Roles......Page 344 Using Views as a Security Mechanism......Page 350 Auditing SQL Server......Page 351 Introducing DBLIB, ODBC, and OLE DB......Page 354 Configuring ODBC Data Sources......Page 356 Presenting DAO, RDO, and ADO......Page 360 Interoperability with Non-Windows Machines and the Internet......Page 362 Using English Query......Page 364 Performing Full-Text Searches......Page 366 Using SQL Server 2000 Analytical Services......Page 368 Linking OLAP and Business Logic......Page 369 Running the Web Assistant Wizard......Page 370 Getting SQL Server XML Support......Page 372 Sunday Afternoon Questions......Page 375 Friday Evening Review Answers......Page 378 Saturday Morning Review Answers......Page 380 Saturday Afternoon Review Answers......Page 382 Saturday Evening Review Answers......Page 384 Sunday Morning Review Answers......Page 385 Sunday Afternoon Review Answers......Page 387 Appendix B: What's on the CD-ROM......Page 390 Hungry Minds, Inc. End- User License Agreement......Page 406 CD-ROM Installation Instructions......Page 409

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

This text includes 30 sessions on key aspects of Microsoft SQL Server 2000. It is accompanied by two CD-ROMs; one includes all example files, software to evaluate progress, and useful tools, and the other includes a trial of Microsoft SQL Server 2000.