United States Microsoft SQL Server 2008 Administration Tutorials
Online Contents For This Course
We have made some of the video tutorials for
Microsoft SQL Server 2008 Administration
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course Description
In SQL Server 2008 Administration, Microsoft Certified Trainer Mark Long helps you understand the installation and administrative functions of Microsoft's SQL Server 2008. SQL Server 2008 delivers on Microsoft's Data Platform vision by helping your organization manage any data, any place, any time. SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, synchronize, report, and analyze. It is the third largest market share data base product in the world. SQL Server 2008 reduces time and cost of management and development of application while providing a comprehensive platform that delivers intelligence where your users want it. To begin learning today, simply click on the movie links.
Choose your media type:
|
Introduction
|
|||
| Welcome | (01:46) | T | |
| Course Overview | (03:25) | T | |
| SQL Server Basics | (07:06) | T | |
| Getting Hands On | (04:23) | T | |
| Microsoft SQL Certifications | (05:40) | T | |
| SQL Server Editions | (06:07) | T | |
|
Installing SQL Server 2008
|
|||
| Hardware Requirements | (04:05) | T | |
| SQL Server Instances | (04:46) | T | |
| SQL Server Components | (04:21) | T | |
| Collation Choices | (03:38) | T | |
| Service Accounts | (05:41) | T | |
| Creating Service Accounts | (02:39) | T | |
| Installing SQL Server 2008 pt. 1 | (06:13) | T | |
| Installing SQL Server 2008 pt. 2 | (05:00) | T | |
| Installing SQL Server 2008 pt. 3 | (04:59) | T | |
| Upgrading SQL Server 2008 | (03:16) | T | |
| SQL Server Configuration Manager | (04:00) | T | |
| SQL Server Authentication Modes | (05:00) | T | |
| Changing Authentication Modes | (04:02) | T | |
| SQL Server Management Studio | (06:04) | T | |
|
SQL Server 2008 Databases
|
|||
| File Types | (03:40) | T | |
| Transaction Log | (05:55) | T | |
| System Databases | (06:18) | T | |
| File Placement | (04:39) | T | |
| Creating a Database | (06:16) | T | |
| Autogrowth | (05:53) | T | |
| Database Options | (05:25) | T | |
| Sizing the Transaction Log | (03:53) | T | |
| Schemas | (06:21) | T | |
| Default Schema | (05:46) | T | |
| Creating a Schema | (06:11) | T | |
| Moving Data Files | (05:50) | T | |
| Installing Sample Databases pt. 1 | (06:17) | T | |
| Installing Sample Databases pt. 2 | (03:48) | T | |
|
Maintaining SQL Server
|
|||
| Hiding System Objects | (04:20) | T | |
| SQL Server Agent | (05:50) | T | |
| Creating a Maintenance Plan | (06:35) | T | |
| Understanding Operators | (02:10) | T | |
| Understanding Jobs | (05:33) | T | |
| Understanding Alerts | (05:57) | T | |
|
Server Management
|
|||
| SQL Server Options | (06:26) | T | |
| Registering Servers | (03:59) | T | |
| Server Configuration | (05:04) | T | |
| Activity Monitor | (03:31) | T | |
| Database Mail pt. 1 | (03:53) | T | |
| Database Mail pt. 2 | (06:39) | T | |
| Database Mail pt. 3 | (05:08) | T | |
|
Maintaining The Database
|
|||
| Maintaining the Database | (04:13) | T | |
| Database Backup pt. 1 | (05:34) | T | |
| Database Backup pt. 2 | (06:02) | T | |
| Backup Compression | (05:52) | T | |
| Backup Devices | (05:58) | T | |
| Managing the Transaction Log | (06:32) | T | |
| Restoring the Database | (06:42) | T | |
|
Monitoring & Troubleshooting
|
|||
| Dedicated Administrator Connection | (04:59) | T | |
| SQL Profiler pt. 1 | (05:04) | T | |
| SQL Profiler pt. 2 | (05:38) | T | |
| Log File Viewer | (04:13) | T | |
| Event Forwarding | (02:29) | T | |
|
Optimizing Performance
|
|||
| Using Filegroups | (04:36) | T | |
| Partitions | (06:19) | T | |
| Partition Planning | (05:01) | T | |
| Database Tuning Advisor pt. 1 | (06:03) | T | |
| Database Tuning Advisor pt. 2 | (04:23) | T | |
|
High Availability
|
|||
| High Availability Options | (06:20) | T | |
| Failover Clustering | (02:38) | T | |
| Database Mirroring | (05:30) | T | |
| Log Shipping | (04:57) | T | |
|
Conclusion
|
|||
| Course Wrap Up | (04:40) | T | |
|
Credits
|
|||
| About the Author | (02:50) | T | |
Email this Page 
Send us FeedbackCourse Information
| Course: | Microsoft SQL Server 2008 Administration |
| Author: | Mark Long |
| SKU: | 34097 |
| ISBN: | 1-936334-07-0 |
| Release Date: | 2010-03-24 |
| Duration: | 6 hrs / 70 tutorials |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
Search within Captions
Subscription / Purchase Information
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Sign up for a Free Trial
Full Access Members have full access to VTC.com's entire library of video tutorials.
If you are already a member, please login here.