In this training, database expert Don Jones takes you on a tour of SQL Server 2008 that ultimately prepares you for prestigious Microsoft MCITP: SQL Server 2008 Database Developer certification.

Don shows you all the latest techniques, tips, technologies, and tools as you learn to design database solutions for Microsoft SQL Server 2008

He starts by covering the basics, including relational database concepts and table design, and moves you all the way through to advanced topics, like query optimization and index tuning.

Throughout, you’ll get plenty of in-the-product experience and demonstrations, clear explanations of core concepts, and guidance for implementing best practices in your own database application designs.

By the time you’re done watching this series you’ll have learned how to:

* Reduce redundancy by normalizing tables
* Access strong security features, such as Application Roles and Schema Ownership
* Use powerful full-text search tools
* Design a database model
* Analyze and perform database application performance and scalability
* Use advanced features like XML, the Entity Framework, CLR programming constructs, and much more

Related posts

• VTC - Database Optimization
• Oracle 10G Database 2 CD’s (Database and Self Study)
• Lynda.com - Microsoft Office 2010 Beta Preview
• DbVisualizer 7.0
• CBT Nuggets The SQL Language On the Job Training