|
|
|
|
|
|
|
|
Microsoft SQL Server 2000 Admin CD Training Course (Prices exclude VAT)
|
|
|
[to previous page]
[other products in "Databases"]
|
|
|
| Product: |
Microsoft SQL Server 2000 Admin CD Training Course
10 hrs / 154 lessons. For Win Vista, XP, 2000, Mac OS X, OS 9, Linux
|
| Price: |
|
|
|
| Details: |
A Few Words About SQL Server
What Is SQL Server? (04:13)
SQL Server Mystique (04:02)
Transact SQL (05:07)
SQL Server History (01:55)
Overview
Overview of Course (05:45)
General Database Information
Main Purpose of a Database (03:26)
What Makes Up a Database (05:34)
Two Main Types of Databases (06:12)
Normalization (03:53)
Denormalization (02:42)
Database Relationships (05:09)
Indexes (05:40)
Proper Design (03:25)
General Administrative Responsibilities
Real World Administration (06:27)
Designing/Building Databases (06:00)
Data Maintenance/Transfer (03:02)
Backup/Restore of Data (03:26)
Security (05:55)
Hardware Requirements
Minimum Hardware Requirements (01:39)
Hardware Compatibility (02:52)
Optimizing Hardware for SQL Server (03:24)
Installing SQL Server 2000
SQL Server 2000 Editions (03:17)
Licensing (03:21)
Multiple Instances (03:26)
Choosing a Security Mode (03:52)
Collation and Sort Selection (04:56)
Network Libraries (03:34)
Installation Methods (03:05)
Upgrading to SQL Server 2000 (03:34)
Default Databases (04:40)
Installation (05:33)
Troubleshooting an Installation (03:43)
SQL Server Security
Security Overview (03:02)
Authentication Modes (04:10)
Roles (04:27)
Assigning Permissions (04:44)
Application Roles (04:16)
System Services
SQL Services (02:48)
SQL Services Issues (04:48)
System Databases
System Databases (03:38)
Sample Databases (02:17)
Data Storage
How SQL Stores Data (05:16)
Fillfactor (02:50)
File and Log Location/Management (03:01)
Administrative Tools
Overview of Admin Tools (04:01)
Exam Considerations (03:36)
Enterprise Manager
Microsoft Management Console (03:08)
Opening & Customizing the Enterprise Mgr (04:46)
Using the Enterprise Manager (04:17)
Query Analyzer
Opening and Exploring the QA (04:42)
Issuing Queries Using the QA (03:22)
Query Analyzer Features (03:59)
Graphical Query Plan (04:35)
Transact-SQL Select Statement
Using a Select Statement (02:04)
Basic Syntax (02:15)
Select Options (03:53)
Important Select Considerations (02:22)
Transact-SQL Insert Statement
Using an Insert Statement (02:34)
Basic Syntax (02:16)
Insert Options/Considerations (03:13)
Transact-SQL Update Statement
Using the Update Statement (02:47)
Basic Syntax/Options (03:47)
Important Update Considerations (02:30)
Transact-SQL Delete Statement
Using the Delete Statement (04:21)
Basic Syntax/Important Considerations (02:53)
Creating a Database
Using the Create Database Statement (07:04)
Database Properties and Options (02:55)
Database Creation Considerations (03:34)
Managing File Growth (03:45)
Shrinking Database Files (04:31)
Sizing the Database (05:01)
Importance of Good Design (03:17)
Transaction Logs
How Transaction Logs Work (03:32)
What Transactions Look Like (03:26)
Location / Location / Location (02:59)
Advantages of Using Transaction Logs (02:43)
Transaction Log Options (04:47)
Filegroups
What Are Filegroups? (02:31)
Advantages of Filegroups (02:23)
Disadvantages of Filegroups (02:29)
Microsofts Recommendation on Filegroups (02:24)
RAID & SQL
RAID Basics (06:41)
SQL and RAID (03:54)
SQL Profiler
What SQL Profiler Does (02:18)
Opening SQL Profiler (04:56)
Using SQL Profiler (03:29)
Operators
What are Operators? (02:51)
Creating an Operator (04:01)
Considerations When Using Operators (02:18)
Jobs
Automating SQL Server (03:11)
Mail Enabling SQL Server 2000 (04:33)
Creating a New Job (03:38)
Scheduling a Job (04:33)
Job Notifications (02:52)
Starting/Stopping a Job (03:36)
Multi Server Jobs (04:06)
Viewing Job History (04:13)
Alerts
What are Alerts (02:53)
Performance Alerts (03:23)
User Defined Alerts (05:20)
Disabling Alerts (02:57)
Considerations When Using Alerts (02:25)
Linked Servers
Using SQL In a Distributed Environment (02:32)
Referring to SQL Server Objects (02:02)
Setting Up a Linked Server Relationship (02:13)
Database Backups
Backup Strategy (02:17)
Database Recovery Models (03:57)
SQL Server Backup (02:36)
Who When and Where (02:16)
System Databases (02:34)
User Databases (05:19)
Performing a Backup (04:34)
Using Multiple Devices (01:50)
SQL Backup Statement (03:42)
Tape Backup (03:47)
Backup Types (02:15)
Transaction Log Backups (02:38)
File and Filegroup Backups (02:54)
Full Backup Strategy (02:56)
Differential Backup Strategy (01:39)
Backup Review (01:30)
Restoring Data
SQL Server Recovery Process (02:07)
Preparing to Restore a Database (03:14)
The SQL Restore Statement (05:50)
Restore Options (02:24)
Restoring Transaction Logs (03:10)
Restoring System Databases (03:10)
Bottom Line on Restoring Data (03:19)
Maintaining High Availability
Determining Requirements (03:55)
Clustering (03:00)
Standby Servers (03:32)
Log Shipping (02:38)
Data Transformation Services
Importing and Exporting Data (02:10)
SQL Data Transport Tools (02:55)
DTS Overview (04:12)
Creating a DTS Package (05:44)
More DTS Package Functionality (03:20)
Defining Transformation Tasks Creating (05:01)
Using DTS in Various Ways (02:22)
Monitoring SQL Server 2000
Performance Issues (02:45)
Monitoring and Tuning Basics (06:24)
Improving Performance (01:50)
Common Monitoring Tasks and Tools (03:42)
What To Monitor (02:49)
Locks (05:10)
Replication Basics
Dealing With Distributed Data (02:10)
SQL Server Replication (03:19)
SQL Server Replication Types (03:32)
SQL Server Replication Models (02:12)
Replication Agents (02:53)
Web Based Data Applications (02:26)
SQL Server Replication Notes (03:03)
Course Wrap-Up
Value of SQL Server knowledge (03:10)
Microsofts MCDBA Certification (05:21) |
|
|
 |
|
From the Best Seller List : CompTIA Network+ 2005 CBT : CompTIA Network+ 2005 Certification means the individual possesses the knowledge needed to configure and install Network components.
CBT Training | Distance Learning | LMS (Enterprise) | Online Learning
Best Sellers | Classroom Courses | Special Offers | MCSE Courses
Copyright 2002-2010 RCS Limited. All rights reserved. More
... |
