SQL 2012 Class

March 19-22, 2012 I am offering a great class to bring the established Database Professional up to speed on SQL Server 2012 so that they are ready to deploy SQL Server 2012 as soon as possible.

During this 4 day class a wide variety of topics will be covered with the goal of getting database professionals up to speed on the new version of the platform so that they can influence their upper management into deploying SQL Server 2012 sooner rather than later. All four days of this class are being taught by Microsoft Certified Master, and Microsoft MVP (Most Valuable Professional) Denny Cherry.

The course outline is included below. To sign up fill out the form below. Seating in the class is limited as I don’t want anyone to get left behind. The cost for all this great training is only $1,200. The class is being held at the Microsoft Office in Los Angeles, CA which is located at 333 South Grand Ave, Suite 3300 Los Angeles, CA 90071. Attendees will be provided with course materials, demo code and lab materials which can be used at home as you prepare for the launch of SQL Server 2012.

The class includes breakfast, snacks, and lunch.

Why Training With Denny

Why should I choose training with Denny as opposed to some of the other great trainers out there? Denny has presented sessions at several major conferences such as Tech Ed, SQL PASS, and Dev Connections as o well as many smaller local and regional events both within the United States and through out the world. Denny is also one of the presenters for the most recent MCM training being offered by Microsoft, handling both the Security and Manageability sessions. Denny is both a Microsoft Certified Master for SQL Server 2008 and a Microsoft MVP for SQL Server. There are currently less than a dozen people world wide who hold both the Microsoft MVP award and the Microsoft Certified Master certification.

Course Outline

DAY 1: Planning and Installation

Welcome and Introductions
Module 1: Installing and Configuring SQL Server 2012 on Windows Server Core
Module 2: Installing and Configuring SQL Server 2012 in a Cluster
Module 3: Performing unattended installations of SQL Server 2012
Module 4: Deploying SQL Server 2012 using sysprep
Module 5: Automating SQL Server 2012 installations under VMware’s vSphere and Microsoft Hyper-V
Module 6: SQL Server 2012 Storage Design Considerations
Module 7: Installing SQL Server 2012 in a virtual environment
Module 8: Securing a SQL Server 2012 installation

DAY 2: Mission Critical

Module 1: SQL Server 2012 AlwaysOn Overview
Module 2: Configuring SQL Server 2012 AlwaysOn
Module 3: SQL Server 2012 AlwaysOn Availability Groups Drilldown
Module 4: What’s new in SQL Server 2012 Manageability
Module 5: What’s new in Transact-SQL
Module 6: Migrating from SQL Server 2000/2005/2008 to SQL Server 2012

DAY 3: Breakthrough Insights

Module 1: Installing and configuring a SQL Server 2012 based Business Intelligence Environment
Module 2: Configuring SQL Server 2012 Business Intelligence
Module 3: Introduction to PowerPivot
Module 4: Introduction to PowerView
Module 5: Introduction to Dashboards and ScoreCards
Module 6: Optimizing your datawarehouse performance using ColumnStore index
Module 7: Introduction to Data Quality Services

DAY 4: Manageability and Security

Module 1: Table Partitioning for performance and saving money
Module 2: Transaction Logs from the inside out
Module 3: Certificates aren’t just for web browsing any more
Module 4: Data Encryption will keep your data safe if it escapes
Module 5: SQL Injection is a bigger problem then you want to think it is
Module 6: Permissions, Rights and Authorizations will keep your data safe