Post Description

Microsoft 70-451: SQL Server 2008, Designing Database Solutions:   

SQL Server Components        
                                                                                                                                             
    Relational Database Basics                                           
                                                                         
    Designing a Database Model                                           
                                                                         
    Using the Entity Framework (free video!)                             
                                                                         
    Designing Application Security                                       
                                                                         
    Designing a Full-Text Search Strategy                                
                                                                         
    Selecting Data Types for Tables                                      
                                                                         
    Designing Tables                                                     
                                                                         
    Designing Programming Constructs                                     
                                                                         
    Designing T-SQL Construts                                            
                                                                         
    Designing Views               

 Special Programming Concerns                                         
                                                                         
    Designing a Transaction and Concurrency Strategy                
                                                                         
    Designing an XML Strategy                                            
                                                                         
    Understanding Query Optimization                                     
                                                                         
    Designing Optimized Queries                                          
                                                                         
    Designing Optimized Index Strategies                                 
                                                                         
    Designing Scalable Database Solutions                              

    Designing Database Performance Strategies