SQL Server 2000 Training
1. Introduction to Microsoft SQL Server 2000
Overview of SQL Server 2000 | Components of SQL Server 2000 | Overview of SQL Server 2000 Architecture
2. Installing SQL Server 2000
Planning to Install SQL Server 2000 | Deciding SQL Server 2000 Setup Configuration Options | Running the SQL Server 2000 Setup Program | Using Default, Named, & Multiple Instances of SQL Server 2000 | Performing Unattended & Remote Installations of SQL Server 2000 | Troubleshooting a SQL Server 2000 Installation
3. Preparing to Use SQL Server 2000
§ Reviewing the Results of Installation
§ Starting, Stopping, Pausing, & Modifying SQL Server 2000 Services
§ Working with Osql, SQL Query Analyzer, & SQL Server Enterprise Manager
4. Understanding System and User Databases
Understanding the Database Architecture | Understanding the Transaction Log Architecture | Understanding & Querying System & Database Catalogs
5. Creating & Configuring User Databases
Creating a User Database | Setting Database Options | Managing User Database Size Using Automatic File Growth Appropriately | Placing Database Files on Multiple Disks
6. Populating a Database
Transferring & Transforming Data | Introducing Microsoft Data Transformation Services (DTS) | Transferring & Transforming Data with DTS Graphical Tools | Working with DTS Packages | Using the Bulk Copy Program (Bcp) & the BULK INSERT Transact-SQL Statement
7. Developing a Data Restoration
Understanding Data Restoration Issues | Understanding the Types of Database | Understanding the Restoration Process
8. Backing Up and Restoring SQL Server
Understanding Backup Terms, Media, & Devices | Backing Up Databases, Files, Filegroups, & Transaction Logs | Restoring a User
9. Managing Access to SQL Server 2000
Understanding the Authentication Process | Understanding the Authorization Process | Creating & Managing Logins
10. Managing SQL Server Permissions
Granting Database-Specific Permissions | Using Application Roles | Designing an Access and Permissions Strategy
11. Performing Administrative Tasks
Performing Configuration Tasks | Setting Up Additional Features | Performing Maintenance
12. Automating Administrative Tasks
Defining Operators | Creating Jobs | Configuring Alerts | Creating a Database Maintenance Plan | Creating Multiserver Jobs
13. Monitoring SQL Server Performance & Activity
Developing a Performance Monitoring Methodology | Choosing Among Monitoring Tools | Performing Monitoring Tasks
14. Using SQL Server Replication
Introducing Replication | Planning for Replication | Implementing Replication | Monitoring & Administering Replication
15. Maintaining High Availability
Using Standby Servers | Using Failover Clustering
16. Using Transact-SQL on a SQL Server Database
SQL Server Programming Tools | Introduction to Transact-SQL | Transact-SQL Syntax Elements | Executing Transact-SQL Statements
17. Designing a SQL Server Database
Introduction to Database Design | Planning a SQL Server Database | Identifying: System Requirements | Developing a Logical Data Model
18. Implementing SQL Server Databases & Tables
Creating and Managing a SQL Server Database| Identifying Data | Creating and Managing Tables
19. Implementing Data Integrity
Introduction to Data | Implementing Integrity
20. Accessing and Modifying Data
Accessing Data in a SQL Server Database | Using SELECT Statements to Access Data | Modifying Data in a SQL Server Database Exercise
21. Managing and Manipulating Data
Importing and Exporting Data | Using Distributed Queries to Access External Data | Using Cursors to Retrieve Data | Retrieving XML Data
22. Implementing Stored Procedures
Introduction to Stored Procedures | Creating, Modifying, & Deleting Stored Procedures | Programming Stored Procedures
23. Implementing Triggers
Introduction to Triggers | Creating and Managing Triggers | Programming Triggers
24. Implementing Views
Introduction to Views | Creating, Modifying, and Deleting Views | Accessing Data through Views
25. Implementing Indexes
Index Architecture | Index Creation & Administration
26. Managing SQL Server Transactions & Locks
Transaction & Locking Architecture | Managing SQL Server | Managing SQL Server Locking
27. Designing & Administering SQL Server 2000 Security
Overview of SQL Server 2000 Security | Designing a Database Security Plan | Database Security Implementation & Administration
28. SQL Server Monitoring & Tuning
Monitoring Databases with SQL Profiler | Index Tuning & Database Partitioning
