Self Study, Tutorial Video on CD - DVD. Tutor Mark Long guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. It works on both PC and Mac, this course is ideal for Beginners and Advanced users
This Microsoft SQL Server 2008 Administration Tutorial Video - Training CD / DVD offers a comprehensive overview of what users need to know to manage their database solutions. As Microsoft's flagship database product, SQL Server 2008 is seeing increasing use in both small and large-scale environments due to its robust controls and functional efficiency. In these 70 video tutorials led by Microsoft Certified expert Mark Long, users will learn how to manage, maintain, and master their databases within SQL Server by learning how the technology works. Combining hands-on walkthroughs of menus and techniques with helpful discussions of the underlying architecture that make SQL possible, this interactive video series empowers users by showing them exactly what they need to know. By focusing primarily on the administration functionality of the software suite, Long is able to give a detailed introduction that covers key concepts one step at a time. Subjects covered in the training include Installing SQL Server, Database File Types, Creating a Maintenance Plan, Database Backup, Partitions Planning, Database Mirroring, and more.The video based tutorial course can now be bought on CD / DVD or viewed totally online through the internet subscriber option. All videos are Mac and Windows compatible, allowing you to learn Microsoft SQL Server 2008 at your own pace.. Watch our free Microsoft SQL Server 2008 Tutorial Videos by clicking the blue lesson links below.

Microsoft SQL Server 2008 Tutorial CD / DVD
Create the best self-paced learning environmentright on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.
Learn 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.

- Professional Tuition from an Expert
- Free Certificate with Each Tutorial
- Works on PC or Mac

Introduction
- Welcome

- Course Overview

- SQL Server Basics

- Getting Hands On

- Microsoft SQL Certifications

- SQL Server Editions

Installing SQL Server 2008
- Hardware Requirements

- SQL Server Instances

- SQL Server Components

- Collation Choices

- Service Accounts

- Creating Service Accounts

- Installing SQL Server 2008 pt. 1

- Installing SQL Server 2008 pt. 2

- Installing SQL Server 2008 pt. 3

- Upgrading SQL Server 2008

- SQL Server Configuration Manager

- SQL Server Authentication Modes

- Changing Authentication Modes

- SQL Server Management Studio

SQL Server 2008 Databases
- File Types

- Transaction Log

- System Databases

- File Placement

- Creating a Database

- Autogrowth

- Database Options

- Sizing the Transaction Log

- Schemas

- Default Schema

- Creating a Schema

- Moving Data Files

- Installing Sample Databases pt. 1

- Installing Sample Databases pt. 2

Maintaining SQL Server
- Hiding System Objects
- SQL Server Agent
- Creating a Maintenance Plan
- Understanding Operators
- Understanding Jobs
- Understanding Alerts
Server Management
- SQL Server Options
- Registering Servers
- Server Configuration
- Activity Monitor
- Database Mail pt. 1
- Database Mail pt. 2
- Database Mail pt. 3
Maintaining The Database
- Maintaining the Database
- Database Backup pt. 1
- Database Backup pt. 2
- Backup Compression
- Backup Devices
- Managing the Transaction Log
- Restoring the Database
Monitoring & Troubleshooting
- Dedicated Administrator Connection
- SQL Profiler pt. 1
- SQL Profiler pt. 2
- Log File Viewer
- Event Forwarding
Optimizing Performance
- Using Filegroups
- Partitions
- Partition Planning
- Database Tuning Advisor pt. 1
- Database Tuning Advisor pt. 2
High Availability
- High Availability Options
- Failover Clustering
- Database Mirroring
- Log Shipping
Conclusion
- Course Wrap Up
Credits
- About the Author
About this Microsoft SQL Server 2008 Training CD
| Title : | Microsoft SQL Server 2008 |
|---|---|
| Tutor : | Mark Long
Other tutorials by Mark Long |
| Videos : | 70 Lessons- Video run time: 6 Hours |
| Delivery time: | Only 3 working days |
| Compatibility: | Vista, 2000, XP, Windows 7, Mac OS, OSX |
| Released | 2010 |
| Work files | Yes |
| Price Australia / New Zealand & Asia | AUD $149.95 (+ $10.00 Shipping ) |
203 In Stock

- Learn Microsoft SQL Server 2008 from an accredited expert in days.
- Ideal for beginners, these easy to follow videos offer visual clarity.
- Master a full application from basics to advanced for a fraction of the cost of classroom based training, and faster than with a manual.
- Unique teaching method that offers accelerated learning and high retention.
- Used by many large companies, schools, universities,
click to see some of our customers. - Learn from your own desk at a speed that suits you.
- It's cost effective tuition from leading expert tutors.
- Learn at your own pace; training can be stopped, rewound or fast forwarded as required.
- These High Quality Tutorial Videos are on CD / DVD or Online and PC / Mac Compatible. It's Simply the best tuition at an affordable price
- This title also has Closed Captions, which add clarity and help with retention. It also benefits users who are deaf / hearing impaired.
Want to hear what our customers say about our products?
Microsoft SQL Reporting Services | MCTS Exam 70-642 | FileMaker 11 | Microsoft SQL Server 2005 Admin | Microsoft SQL Server 2008 Dev | Microsoft LINQ Training | Server 2008 Admin 70-646
Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
You can have access to every title we list on this site for just $30 per month. When you sign up, you get instant access with absolutely no restrictions or limits. Log on from any location and learn as much as you like.



