Try our training for free.

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

Microsoft has retired the 70-228 exam. However, the information in this course remains relevant to the needs of those administering Server 2000 and Server 2008 technologies.

Before you can fully understand and learn the intricacies of SQL administration, you need a foundation in basic SQL concepts. We've put together a short course entitled SQL Fundamentals and are including it with the SQL Admin videos so that the training in the SQL Admin series can assume basic SQL knowledge....
Microsoft has retired the 70-228 exam. However, the information in this course remains relevant to the needs of those administering Server 2000 and Server 2008 technologies.

Before you can fully understand and learn the intricacies of SQL administration, you need a foundation in basic SQL concepts. We've put together a short course entitled SQL Fundamentals and are including it with the SQL Admin videos so that the training in the SQL Admin series can assume basic SQL knowledge.
1. Basic Database Concepts (34 min)
2. An Introduction to Transact SQL (45 min)
3. Beginning Transact SQL (27 min)
4. Intermediate Transact SQL (47 min)
5. An Introduction to SQL Server (34 min)
6. SQL Server Installation (27 min)
7. SQL Server Tools (33 min)
8. Configuring SQL Server (30 min)
9. Database Connectivity (28 min)
10. Planning and Managing Databases (36 min)
11. SQL Server Security (35 min)
12. Transferring Data (32 min)
13. Data Transformation Services (47 min)
14. Database Backups (42 min)
15. Database Recovery (48 min)
16. Automating Administrative Tasks (41 min)
17. Monitoring SQL Server (26 min)
18. Managing SQL Server Availability (32 min)
19. Replication (31 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
11 hrs 19 videos

COURSE RATING

Basic Plan Features


Speed Control
Included in this course
Play videos at a faster or slower pace.

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

Notes
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.

NuggetLab
Files/materials that supplement the video training

Premium Plan 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
Included in this course
Our mobile apps offer the ability to download videos and train anytime, anywhere offline.

Accountability Coaching
Included in this course
Develop and maintain a study plan with assistance from coaches.