What's New in SQL Server 2012 - Courses

What's New in SQL Server 2012

Next date

23 February - 24 February 2012 Australia, Melbourne

Length: 2 days
Language: English
Mentor: Greg Low
List price: A$ 1400 (AUD)

Following dates

06 March - 07 March 2012 Australia, Melbourne Mentor: Greg Low
List price: A$ 1400 (AUD)
Promotional Price: A$ 900.00 (AUD) by 28 February 2012 register
08 March - 09 March 2012 Australia, Sydney Mentor: Greg Low
List price: A$ 1400 (AUD)
Promotional Price: A$ 900.00 (AUD) by 01 March 2012 register
19 March - 20 March 2012 Australia, Brisbane Mentor: Greg Low
List price: A$ 1400 (AUD)
Promotional Price: A$ 900.00 (AUD) by 12 March 2012 register
22 March - 23 March 2012 Australia, Perth Mentor: Greg Low
List price: A$ 1400 (AUD)
Promotional Price: A$ 900.00 (AUD) by 15 March 2012 register

INFORMATION COURSE OUTLINE

2-Day (COURSE-DB-SQLSERVER2012)

Description

The release of SQL Server 2012 is an exciting time for all involved with the product. In this two day session, complete with hands-on labs, we cover the core changes to the product that affect Database administrators, Database developers and Business Intelligence developers.

Note: This course includes the content from both of our single day courses:

For details on booking courses, please send an e-mail.
Target AudienceThis course is intended for existing SQL Server Database Administrators, Database developers, Business Intelligence developers, including those who are part of Independent Software Vendors (ISVs). The course is also useful to IT management who need to understand and plan for Microsoft's upcoming product release.

PrerequisitesExisting experience with SQL Server in a Database Administrator, Database developer, Business Intelligence developer or IT management role.

Day 1

Module 1: T-SQL Enhancements in SQL Server 2012Query Pagination and Sequences Function and Collation Enhancements Error Handling Enhancements Using THROW Metadata Discovery Enhancements Window Function Enhancements Lab 1: Working with T-SQL in SQL Server 2012

Module 2: FileTable, FullText, Spatial, and Semantic Search in SQL Server 2012Review of FullText Indexing FullText Enhancements FileTable Statistical Semantic Search Spatial Enhancements Lab 2: Implementing Statistical Semantic Search over FileTable Documents

Module 3: High Availability Enhancements in SQL Server 2012Review of High Availability Options AlwaysOn and Availability Groups Readable Secondaries and Backup from Secondaries Lab 3: Implementing AvailabilityGroups

Module 4: Security and Monitoring Enhancements in SQL Server 2012Extended Events Profiler Distributed Replay Audit Enhancements Default Schemas for Groups User-Defined Server Roles Contained Databases and Contained Users Lab 4: Implementing Contained Databases

Day 2

Module 5: Analysis Services and PowerPivot Enhancements in SQL Server 2012PowerPivot Enhancements Designing and Deploying Tabular Data Models Using Data Analysis Expressions (DAX) as a Query Language Lab 5: Designing a Tabular Data Model and Deploying it to Analysis Services

Module 6: Reporting Services Enhancements in SQL Server 2012SharePoint Integrated Mode Enhancements for Reporting Services 2012 Implementing Data Alerts in Reporting Services 2012 SQL Azure Reporting Power View Lab 6: Working with Power View

Module 7: Integration Services Enhancements in SQL Server 2012Designer and Component Enhancements Project System Enhancements and Project Deployment Project and Package Parameters, Project Connections, and Environments Master Data Services Enhancements in SQL Server 2012 Data Quality Services Lab 7: Designing an SSIS Package Using Data Quality Services

Module 8: Improving Data Warehouse Performance with ColumnStore Indexes in SQL Server 2012ColumnStore Indexes Review of Table Partitioning Combining ColumnStore Indexes and Table Partitioning to Enhance Data Warehouse Load and Query Performance Lab 8: Implementing ColumnStore Indexes