Quantcast

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.

Database training for Microsoft's SQL Server 2008

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

Every database administrator dreams about zero downtime. With SQL Server 2008 that dream can be yours. SQL's self-management features eliminate much of your database busy work, giving you the time you need to keep your databases secure and running smoothly.

Get the most from SQL Server 2008 while you're becoming a database star. You'll be ready to handle your on-the-job database tasks -- while you gain the database skills and solid exam prep you need to advance your career.

This training maps to Microsoft MCTS certification exam 70-433.

All trademarks and copyrights are the property of their respective holders....
Every database administrator dreams about zero downtime. With SQL Server 2008 that dream can be yours. SQL's self-management features eliminate much of your database busy work, giving you the time you need to keep your databases secure and running smoothly.

Get the most from SQL Server 2008 while you're becoming a database star. You'll be ready to handle your on-the-job database tasks -- while you gain the database skills and solid exam prep you need to advance your career.

This training maps to Microsoft MCTS certification exam 70-433.

All trademarks and copyrights are the property of their respective holders.
 show less
1. SQL Server tables, SQL Server data types, SQL Server computed and persisted columns (38 min)
2. SQL Server 2008 views, SQL Server WITH CHECK OPTION, SQL Server view encryption, SQL Server schema bin... (26 min)
3. SQL Server 2008 Selecting data, inserting, updating, transactions (25 min)
4. SQL Server 2008 indexes, index hints, index types (29 min)
5. SQL Server 2008 partitioned tables, partitioned indexes, managing partitions (35 min)
6. SQL Server 2008 procedures, functions, managing procedures, managing functions, executing functions, e... (21 min)
7. SQL Server 2008 subqueries, common table expressions, merge statement, aggregate queries, combining da... (32 min)
8. SQL Server 2008 triggers, instead of triggers, DML triggers, DDL triggers, nested and recursive triggers (24 min)
9. SQL Server 2008 XML syntax, XML data type, FOR XML clause, XPATH, XQuery functions (33 min)
10. SQL Server 2008 advanced XML, parsing XML (30 min)
11. SQL Server 2008 database mail. email architecture, profiles, sending email, email logs (21 min)
12. SQL Server 2008 execution plan, profiler, Database Engine Tuning Advisor, query hints, catalog views (24 min)
13. SQL Server 2008 service broker, asynchronous messaging, transactional messaging, implementing service ... (32 min)
14. SQL Server 2008 CLR, CLR vs. T-SQL, implementing CLR, Windows Power Shell (31 min)
15. SQL Server 2008 international considerations, full text search, tracking data changes (35 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
7 hrs 15 videos

COURSE RATING

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.

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.