Start with 7 free days of training.

Gain instant access to our entire IT training library, free for your first week.
Train anytime on your desktop, tablet, or mobile devices.

Designing, Optimizing, and Maintaining a Database Administrative Solution

This course will be retired in 292 days. If you have questions, please contact us.

This video training with Don Jones covers SQL server 2008, including creating and using a database, backing up SQL server, and more....
This video training with Don Jones covers SQL server 2008, including creating and using a database, backing up SQL server, and more.

Recommended skills:
  • Familiarity with SQL Server 2008
  • 3 years experience administering databases in an enterprise-level organization

Recommended equipment:
  • SQL Server 2008

Related certifications:
  • Microsoft Certified IT Professional: Database Administrator 2008

Related job functions:
  • Database administrators

Are you a database administrator who wants to add design and development skills to your toolkit? Then this CBT Nuggets SQL Server 2008 Exam-Pack 70-450 training course is for you.

SQL Server 2008 brings you lots of terrific features. Shared server-wide management capability allows you to automate processes, schedule tasks and set performance alerts. Plus you can edit and insert code and run reports.

Trainer Don Jones begins his video course with the basics: SQL terminology, how relational databases work, how they store and retrieve data and the fundamentals of the T-SQL language. Then he teaches you how to install, migrate, upgrade and consolidate your data from previous SQL versions to 2008 SQL Server. Plus, he shows you how some of the "handy" tips and tricks you may have used in earlier versions of SQL can trip you up in SQL Server 2008.

All trademarks and copyrights are the property of their respective holders.
 show less
1. Introduction and Overview (4 min)
2. SQL Server 2008 Functional Concepts and Architecture (32 min)
3. SQL Server 2008 Physical Concepts and Architecture (25 min)
4. Planning a SQL Server 2008 Installation (28 min)
5. Installing SQL Server 2008 (18 min)
6. Creating and Using a Database (25 min)
7. Migrating, Consolidating, and Upgrading (27 min)
8. SQL Server Instance Security (15 min)
9. SQL Server Database Security (30 min)
10. High Availability Overview (24 min)
11. Backing up SQL Server (17 min)
12. Restoring SQL Server (38 min)
13. Database Mirroring and Clustering (33 min)
14. Monitoring SQL Server (22 min)
15. SQL Server Performance Optimization (18 min)
16. Maintaining SQL Server (29 min)
17. Managing SQL Server (22 min)
18. Using SQL Server Agent (16 min)
19. Distributing Data with SQL Server Integration Services (17 min)
20. Linked Servers and Replication (28 min)

Please help us improve by sharing your feedback on training courses and videos. For customer service questions, please contact our support team. The views expressed in comments reflect those of the author and not of CBT Nuggets. We reserve the right to remove comments that do not adhere to our community standards.

comments powered by Disqus
8 hrs 20 videos


Training Features

Practice Exams
These practice tests help you review your knowledge and prepare you for exams.

Virtual Lab
Use a virtual environment to reinforce what you are learning and get hands-on experience.

Offline Training
Our iOS and Android mobile apps offer the ability to download videos and train anytime, anywhere offline.

Accountability Coaching
Develop and maintain a study plan with one-to-one assistance from coaches.

Supplemental Files
Files/materials that supplement the video training.

Speed Control
Play videos at a faster or slower pace.

Included in this course
Pick up where you left off watching a video.

Included in this course
Jot down information to refer back to at a later time.

Closed Captions
Follow what the trainers are saying with ease.