This course teaches you to administer and troubleshoot information systems that incorporate the SQL Server™ 2000 Enterprise Edition. Learn how to install and configure a SQL 2000 Server, create SQL 2000 databases, manage, monitor and troubleshoot SQL 2000 databases, extract and transform data and manage and monitor SQL 2000 security. Covers exams 70-228 and 70-229.
Instructor
Paul D. Sheriff is the owner of PDSA Inc., a Microsoft Solutions Provider for Visual Basic and SQL Server. Paul has 10 years experience and is Visual Basic certified. He is one of the top instructors on Visual Basic and speaks at Advisor Developer Conferences and Microsoft TechEd every year. He is also the author of over 25 articles in major publications.
Administering SQL Server 2000 Level 1 (2 hrs 2 mins)
1.0 An Overview of SQL Server (32 mins)1.1 Why use SQL Server?
1.2 Graphical Tools
1.3 Transact SQL
1.4 Database Objects
1.5 Security
1.6 Services
1.7 Capacities
1.8 Connectivity
1.9 Other Features
2.0 Installing SQL Server 2000 (36 mins)
2.1 Operating Systems
2.2 Versions & Configurations
2.3 Multiple Instances
2.4 Licensing
2.5 File Locations
2.6 Sort Orders
2.7 Types of Installations
2.8 Installation Checklist
2.9 Performing an Installation
2.10 Upgrading
2.11 Troubleshooting an Upgrade
2.12 Unattended Installations
3.0 Database Setup and Maintenance (54 mins)
3.1 Database Objects
3.2 System Stored Procedures & Functions
3.3 Database Layout
3.4 Database Files & File Groups
3.5 Transaction Log
3.6 Database Growth
3.7 Creating Databases using Enterprise Manager
3.8 Creating Databases using T-SQL
3.9 Sp-helpdb
3.10 Expanding a Database
3.11 Shrinking a Database
3.12 Database Options
3.13 Recovery Models
3.14 Database Space Planning
3.15 Multiple Disk Usage
Administering SQL Server 2000 Level 2 (2 hrs 11 mins)
1.0 Security (56 mins)1.1 Introduction to Security
1.2 Authentication
1.3 Creating Logins
1.4 Server Roles
1.5 Assigning Server Roles
1.6 Database Roles
1.7 Managing Database Roles
1.8 Permissions
1.9 Managing Permissions
1.10 Views and Security
1.11 Stored Procedures and Security
1.12 Application Roles
2.0 Operators, Jobs, Alerts & Mail (1 hr 15 mins)
2.1 Definitions
2.2 SQL Server Agent Configuration
2.3 Operators
2.4 Jobs
2.5 Alerts
2.6 SQL Mail
2.7 Troubleshooting
Administering SQL Server 2000 Level 3 (2 hrs 4 mins)
1.0 DBCC (23 mins)1.1 Maintenance Statements
1.2 Pin Statements
1.3 Trace Flags
1.4 Informational Statements
1.5 Check Statements
1.6 Old Statements
2.0 Backup and Restore (42 mins)
2.1 Why do a Backup?
2.2 Considerations of the Backup Process
2.3 Managing the Backup Devices
2.4 System Database Backup
2.5 Multiple Backup Devices
2.6 Backup Planning
2.7 Media Choices
2.8 Backup Types
2.9 Backup Scenarios
2.10 Copying/Moving
2.11 Stand-by Servers & Clustering
2.12 Performing a Backup
2.13 Restore a Backup
3.0 Database Maintenance Plan Wizard (14 mins)
3.1 What is the DMPW?
3.2 Running the Wizard
3.3 Jobs Created by the Wizard
4.0 Web Assistant (19 mins)
4.1 What is the Web Assistant?
4.2 Running the Web Assistant
4.3 Using a Template File
4.4 Triggers generated by Web Assistant
5.0 SQL Server Configuration Options (26 mins)
5.1 SQL Server Registration Properties
5.2 SQL Server Properties Dialog
Administering SQL Server 2000 Level 4 (1 hr 42 mins)
1.0 Transferring Objects & Scripting (32 mins)1.1 Methods of Data Transfer
1.2 DTS Designer
1.3 Copy Database Wizard
1.4 sp_attach_db and sp_detach_db
1.5 Scripting Objects
2.0 Error Logs (13 mins)
2.1 Windows Event Logs
2.2 SQL Server Error Logs
2.3 Demo of Windows Logs
2.4 Demo of SQL Server Logs
3.0 Distributed Management Objects (20 mins)
3.1 DMO Object Hierarchy
3.2 Logging into SQL Server
3.3 Loading a list of Databases
3.4 Loading Tables
3.5 Users & Table Scripts
3.6 Indexes & Columns
4.0 Tips & Tricks (37 mins)
4.1 General Tips & Tricks
SQL SERVER 2000 Administration Level 5
1.0 Replication Concepts1.1 What is replication?
1.2 The publisher / subscriber metaphor
1.3 Replication Types
2.0 Planning a Replication Strategy
2.1 Basic Requirements
2.2 Autonomy vs. Integrity
2.3 Evaluating Business Objectives
2.4 Physical Replication Models
2.5 2.5 Network Considerations
2.6 Security Issues
2.7 Capacity Planning
2.8 Triggers and Constraints
2.9 Planning Updating Subscribers
3.0 Implementing Snapshot Replication
3.1 How Snapshot Replication Works
3.2 Configuring Snapshot Replication
4.0 Implementing Transactional Replication
4.1 How Transactional Replication Works
4.2 Configuring Transactional Replication
5.0 Merge Replication
5.1 How Merge Replication Works
5.2 Configuring Merge Replication
5.3 Conflict Detection and Resolution
SQL SERVER 2000 Administration Level 6
1.0 Monitoring and Tuning Replication1.1 Introduction to the Replication Monitor
1.2 Overview of replication agents
1.3 Viewing Agent History
1.4 Replication Alerts
1.5 Performance issues
2.0 Replication with non-SQL Server Data Sources
2.1 Heterogeneous Subscribers
2.2 Heterogeneous Publishers
3.0 Replication and Database Maintenance
3.1 Backup issues
3.2 Transactional replication and log-shipping
4.0 Overview of Programmatic Replication
4.1 Using ActiveX Controls
4.2 Using the SQL DMO
4.3 The Replication Distributor Interface
4.4 Using Transact SQL Stored Procedures
SQL SERVER 2000 What’s New?
1.0 New Features1.1 Interface Changes
1.2 Multiple Instances
1.3 Index Enhancements
1.4 New Data Types
1.5 Text in Row
1.6 Triggers
1.7 Cascade Delete and Update
1.8 User-Defined Functions
1.9 Misc. Enhancements
1.10 New Functions
2.0 Using XML Extensions
2.1 Creating a Virtual Root
2.2 Using a Virtual Root
2.3 Returning Element Based XML
2.4 Passing Parameters
2.5 Multiple Result Sets
2.6 Using Stored Procedures
2.7 Inserting Data using XML
2.8 Joining Tables
2.9 Retrieving Data from VB
Regular price: $549.95
Sale
price: $529.95
Click here for Secure
Yahoo Order: SQL
Server 2000 Administration Training Series
Get Train in SQL
SQL
Training CD
Best Regards,
Oracle Database,
SQL, Application, Programming Tips
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies.
The site www.erpgreat.com is not affiliated with or endorsed
by any company listed at this site.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.erpgreat.com or the content authors.