|
|
|
|
|
|
|
|
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 : CCNA Training (640-802) - The CCNA 640-802 exam will test materials from the new Interconnection Cisco Network Devices (ICND) course as well as the new Introduction to Cisco Networking Technologies (INTRO) course, both included in the courseware module.
CBT Training | Distance Learning | LMS (Enterprise) | Online Learning
Best Sellers | Classroom Courses | Special Offers | MCSE Courses
Copyright 2002-2011 RCS Limited. All rights reserved. More
... |
