SQL Server 7 Administration Level 1 (2 Hours 9 Minutes)
1.0 Overview of the Features of SQL Server (21 Minutes)1.1 Why you want to use SQL Server
1.2 Features and capacities of SQL Server
2.0 Installation of SQL Server (54 Minutes)
2.1 Walk through of the installation options
2.2 Which options are critical to a successful installation
2.3 Performing the Installation
2.4 Upgrading from a previous version of SQL Server
3.0 Database Setup and Maintenance (51 Minutes)
3.1 Database Objects
3.2 Looking at Schema Views
3.3 System Stored Procedures
3.4 Database Creation
3.5 Files and FileGroups
3.6 Transaction log management
3.7 Database growth
3.8 Expanding and Shrinking
3.9 Performance Considerations
SQL Server 7 Administration Level 2 (2 Hours 3 Minutes)
1.0 Security in SQL Server (1 Hour 6 Minutes)1.1 Introduction to Security
1.2 Special ID's and Authentication
1.3 Logins
1.4 Roles & Users
1.5 Permissions
1.6 Planning for Security
1.7 Views and Stored Procedures
1.8 Application Role
2.0 Operators, Jobs, Alerts and Mail (1 Hour 8 Minutes)
2.1 Definitions
2.2 SQL Server Agent
2.3 Operators
2.4 Jobs
2.5 Alerts
2.6 SQL Mail
SQL Server 7 Administration Level 3 (2 Hours 3 Minutes)
1.0 The Database Consistency Checker (28 Minutes)1.1 Definition and Statements
1.2 How to run DBCC Statements
2.0 Backup and Restore (55 Minutes)
2.1 Planning and Maintenance issues
2.2 Performing a backup
2.3 Restoring a database
3.0 Database Maintenance Plan Wizard (12 Minutes)
3.1 What is the DMPW
3.2 Setting up a database maintenance plan & Running the wizard
4.0 Using the Web Assistant (27 Minutes)
4.1 What is the Web Assistant & How to use it
4.2 Viewing the output
SQL Server 7 Administration Level 4 (2 Hours 20 Minutes)
1.0 SQL Server Configuration Options (15 Minutes)1.1 The different Server Configuration Options
2.0 Data Transfer (ring & Scripting Objects)(54 Minutes)
2.1 Transferring Data
2.2 Bulk Copy Procedure
2.3 Bulk Insert
2.4 Data Transformation Server
2.5 Transferring Objects with DTS Designer
2.6 Other Object Transferal Methods
3.0 Monitoring the Server (29 Minutes)
3.1 Why Monitor & Monitoring for Performance
3.2 Monitoring Tools
3.3 Using Performance Monitor
3.4 Monitoring activity with the SQL Server Profiler
3.5 System Procedures & Functions & Transaction SQL Statements
4.0 Error Logs (8 Minutes)
4.1 Why Monitor Error Logs
4.2 Types of Error Logs
4.3 Where the error logs are stored
5.0 Replication (33 Minutes)
5.1 Why Replicate
5.2 Two Methods
5.3 Terms
5.4 Replication Scenarios
5.5 Implementing Replication
5.6 Characteristics of Replication Types
5.7 Planning Replication
5.8 Configuring SQL Server for Replication
5.9 Publication, Subscription and Distribution
Regular price: $359.95
Sale
price: $339.95
Click here for Secure
Yahoo Order: SQL
7.0 Server Administration Set of Four Training CD Roms
Get Train in SQL
SQL
Software Training
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.