• Introduction SQL Server 2012.
• SQL-Architecture.
• GAM, SGAM, Pages, Extents.
• Database engine,
• Multiple instances,
• Sql server2012 editions,
• SQL Server 2012 databases and Objects,
• Sql Server Physical Structure.
• MSBI studio.
• What is new for MSBI  in SQL Server 2012?

• Plan data transfer and staging solutions for an ETL operation
• Plan an SSIS Solution
• Design and implement data flows
• Incorporate logging, error handling and reliability into a package
• Optimize an SSIS Solution
• Deploy an SSIS Solution

►Contents: Planning for ETL

• Identifying Data Sources and Destinations
• Evaluating Source Data
• Identifying Staging Requirements

►Planning an SSIS Solution

• Planning Packages
• Planning Package Development
• Designing Package Control Flow

►Designing Data Flow

• Understanding Data Flow
• Designing Data Flow Operations
• Handling Data Changes

►Logging, Error Handling and Reliability

• Logging ETL Operations
• Handling Errors in SSIS
• Implementing Reliable ETL Processes with SSIS

►Optimizing an SSIS Solution

• Monitoring SSIS Performance
• Optimizing SSIS Packages
• Scaling Out SSIS Packages

►Deploying and Operating an SSIS Solution

• Deploying SSIS Packages
• Operating an SSIS Solution

►SSAS Objectives:

• Describe how SQL Server Analysis Services can be used to implement Analytical solutions
• Create multidimensional analysis solutions with SQL Server Analysis Services
• Implement dimensions in an Analysis Services solution
• Implement measures and measure groups in an Analysis Services solution
• Query a multidimensional Analysis Services solution
• Customize an Analysis Services cube
• Deploy and secure an Analysis Services database
• Maintain a multidimensional Analysis Services solution
• Implement Data Mining solution

►Contents: Introduction to Microsoft SQL Server 2012 Analysis

►Services

• Overview of Data Analysis Solutions
• Over of SQL Server 2012 Analysis Services
• Installing SQL Server 2012 Analysis Services

►Creating Multidimensional Analysis Solution

• Developing Analysis Services Solutions
• Data Sources and Data Source Views
• Creating a Cube

►Working with Dimensions

• Configuring Dimensions
• Defining Hierarchies
• Sorting and Grouping Attributes

►Working with Measures and Measure Groups

• Working with Measures
• Working with Measure Groups

►Querying Multidimensional Analysis Solutions

• MDX Fundamentals
• Adding Calculations to a Cube

►Customizing Cube Functionality

• Implementing Key Performance Indicators
• Implementing Actions
• Implementing Perspectives
• Implementing Translations

►Deploying and Securing an Analysis Services Database

• Deploying an Analysis Services Database
• Securing an Analysis Services Database

►Maintaining a Multidimensional Solution

• Configuring Processing Settings
• Logging, Monitoring and Optimizing an Analysis Services Solution     
• Backing Up and Restoring an Analysis Services Database

►Introduction to Data Mining

• Overview of Data Mining
• Creating a Data Mining Solution