Read an Excerpt
Learn Microsoft SQL Server 2000 in Three Days is a practical guide and introduction to Microsoft's SQL Server 2000.
Following is a summary of each chapter.
Chapter 1: SQL Server 2000 Overview
This chapter introduces the basic concepts of databases. You will learn about the client/server architecture and the main components of the SQL Server 2000 database system such as tables, indexes, views, triggers, and stored procedures.
Chapter 2: Creating a Database
in this chapter you learn to create a database, both manually and with the Create Database Wizard. Defining a database maintenance plan is also discussed.
Chapter 3: Tables
Tables are the basic elements of databases. This chapter describes how to create and use tables, including changing the structure of a table and viewing properties.
Chapter 4: Indexes
indexes help speed up access to tables. In this chapter you will learn about the different types of indexes and how to create and use indexes.
Chapter 5: Views
This chapter introduces views, which are virtual tables that provide users with specific information from one or more tables. Creating, querying, editing, and deleting views are all covered in this chapter.
Chapter 6: Database Diagrams
Database diagrams are graphic representations of a database that help you manage database objects. In this chapter you learn how to create diagrams and relationships among tables.
Chapter 7: The Query Analyzer
The SQL Server Query Analyzer is used to run queries in the database. Saving and editing queries are among the topics discussed in this chapter.
Chapter 8: SQL Basics
Thischapter covers the basics of the Structured Query Language, including types of declarations, data types, operators, and functions. In addition, the SELECT command and other main commands are covered
Chapter 9: Stored Procedures
Stored procedures are routines written in Transact-SQL that automate tasks. This chapter discusses the types and structure of stored procedures, as well as creating and maintaining stored procedures. The chapter also lists the system stored procedures.
Chapter 10: Triggers
Triggers are routines written in Transact-SQL that are executed when a particular event occurs, such as inserting, deleting, or updating data. You will learn about the components of a trigger and how to create and modify a trigger.
Chapter 11: Replication
This chapter discusses the concept of database replication, which allows you to distribute data and stored procedures. The different types of replication are covered, and an example of transactional replication is given.
Chapter 12: Merge Replication
This chapter continues the discussion of replication, showing how to create a merge: type replication. Conflict resolution is also covered.
Chapter 13: Data Transformation Services
Data Transformation Services is a resource that transforms data from different sources. You will learn how to import and export data with the DTS Import/Export Wizard in this chapter.
Chapter 14: Creating a Package with the DTS Package Designer
This chapter gives a practical example of database transformation. You will learn how to create and execute a package using the DTS Package Designer.
Chapter 15: Registering Servers
To view and access remote servers you will need to register the server with the Enterprise Manager. This chapter discusses the procedure for doing so, and presents information on creating and modifying a server group.
Chapter 16: Tools
SQL Server 2000 includes a set of graphical tools that can simplify administrative tasks. Among the utilities discussed in this chapter are Client Network Utility, Profiler, and Service Manager.
Chapter 17: Backing Up and Restoring
Backing up a database is a basic security step. This chapter shows how to create and restore different types of database backups.