Microsoft SQL Server 2000 Admin Tutorials

Details

Highly Effective Microsoft SQL Server tutorials on video CD, learn from your own desk at a pace that suits you. Low cost high quality training at an affordable price. Works on PC and Mac.

 

These Microsoft SQL Server tutorials are based around administrating the SQL server in a real life environment. This training CD is also an excellent resource for people wishing to take and pass the Microsoft 70 – 288 exam. Certified instructor Mark Long gives users an excellent insight into SQL admin, the training is presented using narrated QuickTime videos and easy to follow examples. Topics covered on this training course include: installation, file groups, data storage, using the query analyzer, enterprise manager admin tools, using the monitor and a lot more. Related titles Microsoft SQL Server
Close
Microsoft SQL Server Training CD / DVD Contents
Professionally created, comprehensive training that's easy to follow at an unbelivable price.

See the quality for yourself. Try a FREE Demo.

The blue links below are Free Microsoft SQL Server Tutorial Videos.

Try for FREE - NOW
To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Read before watching the free videos
The sound quality and frame rate of free online tutorials has been reduced to allow for faster streaming. The quality on CD / DVD is far higher.
Quicktime
*QuickTime is needed to view the videos. Some titles have been converted to play via Flash.
A Few Words About SQL Server What Is SQL Server? Demo
SQL Server Mystique Demo
Transact SQL Demo
SQL Server History Demo Overview Overview of Course Demo General Database Information Main Purpose of a Database Demo
What Makes Up a Database Demo
Two Main Types of Databases Demo
Normalization Demo
Denormalization Demo
Database Relationships Demo
Indexes Demo
Proper Design Demo
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
General Administrative Responsibilities Real World Administration
Designing/Building Databases
Data Maintenance/Transfer
Backup/Restore of Data
Security Hardware Requirements Minimum Hardware Requirements
Hardware Compatibility
Optimizing Hardware for SQL Server Installing SQL Server 2000 SQL Server 2000 Editions
Licensing
Multiple Instances
Choosing a Security Mode
Collation and Sort Selection
Network Libraries
Installation Methods
Upgrading to SQL Server 2000
Default Databases
Installation
Troubleshooting an Installation SQL Server Security Security Overview
Authentication Modes
Roles
Assigning Permissions
Application Roles System Services SQL Services
SQL Services Issues System Databases System Databases
Sample Databases Data Storage How SQL Stores Data
Fillfactor
File and Log Location/Management Administrative Tools Overview of Admin Tools
Exam Considerations Enterprise Manager Microsoft Management Console
Opening & Customizing the Enterprise Mgr
Using the Enterprise Manager Query Analyzer Opening and Exploring the QA
Issuing Queries Using the QA
Query Analyzer Features
Graphical Query Plan Transact-SQL Select Statement Using a Select Statement
Basic Syntax
Select Options
Important Select Considerations Transact-SQL Insert Statement Using an Insert Statement
Basic Syntax
Insert Options/Considerations Transact-SQL Update Statement Using the Update Statement
Basic Syntax/Options
Important Update Considerations Transact-SQL Delete Statement Using the Delete Statement
Basic Syntax/Important Considerations Creating a Database Using the Create Database Statement
Database Properties and Options
Database Creation Considerations
Managing File Growth
Shrinking Database Files
Sizing the Database
Importance of Good Design Transaction Logs How Transaction Logs Work
What Transactions Look Like
Location / Location / Location
Advantages of Using Transaction Logs
Transaction Log Options Filegroups What Are Filegroups?
Advantages of Filegroups
Disadvantages of Filegroups
Microsoft's Recommendation on Filegroups RAID & SQL RAID Basics
SQL and RAID SQL Profiler What SQL Profiler Does
Opening SQL Profiler
Using SQL Profiler Operators What are Operators?
Creating an Operator
Considerations When Using Operators Jobs Automating SQL Server
Mail Enabling SQL Server 2000
Creating a New Job
Scheduling a Job
Job Notifications
Starting/Stopping a Job
Multi Server Jobs
Viewing Job History Alerts What are Alerts
Performance Alerts
User Defined Alerts
Disabling Alerts
Considerations When Using Alerts Linked Servers Using SQL In a Distributed Environment
Referring to SQL Server Objects
Setting Up a Linked Server Relationship Database Backups Backup Strategy
Database Recovery Models
SQL Server Backup
Who When and Where
System Databases
User Databases
Performing a Backup
Using Multiple Devices
SQL Backup Statement
Tape Backup
Backup Types
Transaction Log Backups
File and Filegroup Backups
Full Backup Strategy
Differential Backup Strategy
Backup Review Restoring Data SQL Server Recovery Process
Preparing to Restore a Database
The SQL Restore Statement
Restore Options
Restoring Transaction Logs
Restoring System Databases
Bottom Line on Restoring Data Maintaining High Availability Determining Requirements
Clustering
Standby Servers
Log Shipping Data Transformation Services Importing and Exporting Data
SQL Data Transport Tools
DTS Overview
Creating a DTS Package
More DTS Package Functionality
Defining Transformation Tasks Creating
Using DTS in Various Ways Monitoring SQL Server 2000 Performance Issues
Monitoring and Tuning Basics
Improving Performance
Common Monitoring Tasks and Tools
What To Monitor
Locks Replication Basics Dealing With Distributed Data
SQL Server Replication
SQL Server Replication Types
SQL Server Replication Models
Replication Agents
Web Based Data Applications
SQL Server Replication Notes Course Wrap-Up Value of SQL Server knowledge
Microsoft's MCDBA Certification

Microsoft SQL Server Training CD Information

Title : Microsoft SQL Server
Tutor : Mark Long
Other tutorials and training by this author
Movies : 154 Lessons- Video run time: 10 Hours
Availability : Immediate Dispatch
Compatibility: Vista, 98, 2000, NT, XP, Mac OS, OSX
Released 2002-07-31
Price US / Canadian Sales $99.95

176 In Stock

Add to Cart

Why use this method of video training ?
  • Learn Microsoft SQL Server from an accredited expert in days.
  • Ideal for beginners, easy to follow videos that offer visual clarity.
  • Master a full application for a fraction of the cost of classroom based training.
  • Unique teaching method that offers accelerated learning and high retention.
  • Used by many large companies, schools, universities,
  • Learn from your own desk at a speed that suits you
  • Cost effective tuition from leading experts
  • You control the pace, training can be stopped, rewound or fast forwarded as required.

Associated Titles:

Free Certificate. Prove your credentials
online people


We now offer all customers a free certificate to verify they have undertaken a Microsoft SQL Server course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your Microsoft SQL Server certificate without delay.

Online University Access all our Training for only $30.00

Not sure which training CD titles to purchase ? Why not join our Online University and have unlimited access to all our titles for one low price ?

online people

over 4000 hours of high quality online training for only $30.00. Unlimited access

learn from your own desk -expert tutorials - affordable tuition.
No minimum sign up period.
Want to see how good our online university is? - Why not try a free Demo

For low monthly fee you have unlimited access to all the 300+ training titles in our range, that's over 35,000 tutorials covering 4000 hours+! Watch when ever you like, from any computer - NO LIMITS.

Join Today and learn quicker and cheaper than you ever thought possible.

Become a expert without having to read a book or attend expensive training courses.

Where else can you find step-by-step training for over 300 software applications delivered to your own desk, from a leading expert, for less then a Dollar a day ?

Want to see how good our online university is? - Why not try a free Demo, and if all that's not enough, we add new video tutorials each month for no extra charge!

Free Newsletter

If you would like to be notified as we release new video tutorials, run special offers, or promotions.
Sign up now. Your details are kept secure and never sold rented or used by any other 3rd parties.

Microsoft SQL Server Related Product Groups:

FileMaker Pro | Excel Tutorials | MySQL Access Tutorials | Oracle PL/SQL | Microsoft SQL Server 2000 Admin Microsoft SQL Server 2000 Programming | Online Microsoft SQL Server Training Courses