United States Microsoft SQL Server 2005 Administration Training
CD Contents For This Title
All the chapters and lesson contents of Microsoft SQL Server 2005 Administration are listed below.
To help you evaluate our training, we have made some of the tutorials for Microsoft SQL Server 2005 Administration freely available. Click on any of the linked lesson listings below to preview FREE!
SQL Server 2005 is the latest release from Microsoft of their enterprise database solution product. SQL Server 2005 is the result of five years of research, development and collection of suggestions and wish lists from database administrators and developers. Microsoft continues to drive the enterprise database market with the added features and capabilities of this new product. Microsoft Certified Database Administrator and Certified Trainer Mark Long covers the basics of SQL Server 2005 administration in this course. To begin learning simply click the links.
Choose your media type:
To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
Hide This|
Welcome/Introduction
|
||
| Introduction | (02:08) | |
| SQL Server Overview | (03:24) | |
| SQL Server History | (04:46) | |
| Course Objeectives | (01:56) | |
| Transact SQL | (03:58) | |
| Course Overview | (03:52) | |
| SQL Server Mystique | (02:51) | |
|
Installing SQL Server 2005
|
||
| SQL Server 2005 Editions | (04:27) | |
| Preparing To Install SQL Server 2005 | (03:25) | |
| Hardware Requirements | (04:27) | |
| Working With Previous Versions | (04:10) | |
| SQL Server 2005 Installation | (02:19) | |
| Installing SQL Server 2005 Pt.1 | (05:09) | |
| Installing SQL Server 2005 Pt.2 | (03:40) | |
| Changing & Deleting SQL Server | (02:52) | |
| Default & Named Instances | (05:13) | |
| Getting Assistance | (05:20) | |
|
Administrative Tools
|
||
| Management Studio Overview | (04:41) | |
| Registering Servers | (03:46) | |
| Object Explorer | (03:21) | |
| Executing TSQL Queries | (03:00) | |
| Management Studio Solutions | (04:12) | |
| Server Configuration Manager | (02:59) | |
| SQLCMD | (02:35) | |
| SQLCMD Variables | (04:03) | |
| Dedicated Administrator Connection | (03:25) | |
|
SQL Server Security
|
||
| Securing SQL Server 2005 | (03:05) | |
| Authentication Modes Pt.1 | (04:30) | |
| Authentication Modes Pt.2 | (04:43) | |
| Principles | (03:10) | |
| Permissions | (03:31) | |
| Securables | (02:45) | |
| Managing Logins | (05:05) | |
| Managing Users | (03:24) | |
| Schemas | (03:33) | |
| Managing Schemas | (04:07) | |
| Managing Permissions | (04:15) | |
| Managing Server Permissions | (02:37) | |
| Managing Database Permissions | (02:23) | |
| TSQL Permissions | (01:28) | |
|
System Databases
|
||
| System Databases | (06:00) | |
| System Database Concerns | (02:29) | |
| Sample Database | (04:05) | |
|
Databases
|
||
| Creating A Database Pt.1 | (04:41) | |
| Creating A Database Pt.2 | (03:05) | |
| Database Properties & Options | (05:27) | |
| Generating Scripts | (05:06) | |
| Shrinking Database Files | (04:31) | |
| Creating Tables Pt.1 | (05:48) | |
| Creating Tables Pt.2 | (03:03) | |
| Datatypes Pt.1 | (05:20) | |
| Datatypes Pt.2 | (05:51) | |
| Primary & Foreign Keys | (04:10) | |
| Diagrams | (05:44) | |
|
Transaction Logs
|
||
| How Transaction Logs Work | (03:45) | |
| Transactions Explained | (05:14) | |
| Explicit & Implicit Transactions | (05:28) | |
| Location, Location, Location | (03:27) | |
| Advantages Of Using Transactions Logs | (03:40) | |
| Transaction Log Options | (04:45) | |
|
Data Storage
|
||
| How SQL Server Stores Data | (05:03) | |
| Fillfactor | (05:12) | |
| DBCC Showcontig | (06:05) | |
|
SQL Profiler
|
||
| Profiler | (04:06) | |
| Using SQL Profiler Part1 | (04:24) | |
| Using SQL Profiler Part2 | (05:08) | |
|
Automating SQL Server
|
||
| Automation Overview | (04:34) | |
| SQL Server Agent Service | (02:57) | |
| Creating Operators | (03:22) | |
| Creating Jobs Pt.1 | (05:33) | |
| Creating Jobs Pt.2 | (05:45) | |
| Creating Alerts | (06:05) | |
| Alert Considerations | (03:57) | |
|
Database Backups
|
||
| Backup Strategy | (03:35) | |
| Database Recovery Models | (05:48) | |
| Which Files and When | (02:41) | |
| Performing A Backup | (03:47) | |
| SQL Backup Statement | (03:36) | |
| Transaction Log Backups | (02:45) | |
| Backup Types | (05:39) | |
|
Restoring Data
|
||
| SQL Server Recovery Process | (04:46) | |
| Restoring A Database | (03:13) | |
| The Restore Statement | (03:29) | |
|
High Availability
|
||
| SQL Server High Availability | (02:53) | |
| Clustering | (02:21) | |
| Standby Servers | (05:13) | |
| Log Shipping | (05:58) | |
| Database Mirroring | (03:08) | |
|
Database Maintenance
|
||
| Memory Management Basics | (04:37) | |
| Maintenance Plan Creation | (06:14) | |
|
Course Wrap-Up
|
||
| Course Wrap-Up | (02:41) | |
|
Credits
|
||
| About The Author | (01:48) | |
Email this Page
Send us FeedbackTitle Information / Pricing
| Title: | Microsoft SQL Server 2005 Administration |
| Author: | Mark Long |
| SKU: | 33682 |
| ISBN: | 1-933736-11-9 |
| Release Date: | 2006-03-16 |
| Price: | |
| Duration: | 7 hrs / 92 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7 |
Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP NOW
LEARN MORE » Select Bandwidth
Now Shipping
Client Testimonials
VTC is the best place for those people who would like to learn at their own time and pace. Photoshop tutorials by Dwayne Ferugson are so...
Sivaharsha Mogili