|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 Complete Set of 8 |
 |
Training
Provided by 123-CBT Computer Based Training
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
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
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
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
1.1 What is a Database?
1.2 Goals of a Database
1.3 Relational Databases
1.4 Relational Algebra
1.5 Operators
1.6 Relational Database Management System
1.7 Terms
1.8 Codd's Twelve Rules
2.0 Database Normalization (12 min)
2.1 The Process of Normaliza
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
Implementing SQL 7 Level 1 (2 Hours 20 Minutes)
1.0 Relational Database Design (23 min)1.1 What is a Database?
1.2 Goals of a Database
1.3 Relational Databases
1.4 Relational Algebra
1.5 Operators
1.6 Relational Database Management System
1.7 Terms
1.8 Codd's Twelve Rules
2.0 Database Normalization (12 min)
2.1 The Process of Normaliza
|
|
SQL Server 7 0 Complete Set of 8
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
