 |
Two day Hands-on Instructor led training that teaches you "SQL Server 2012" with an easy to set up learning environment. This is absolutely the most efficient and cost effective way to learn new complex technologies.
$750 includes lunch and course content on USB Flash Drive. Learn to develop on this technology deploying to both on-premise and Cloud infrastructures.
Register now securely |
| June 19-20 |
Learn SQL Server 2012 Development and Implementation in a two day Hands-On Seminar presented by Joe Homnick and other Microsoft Certified Trainers in Developer Technologies from Homnick Systems. We will supply you with a Virtual image and workbook. You can optionally, BYOL (bring your own laptop) to walk along with the instructor and/or take the materials with you for further lab work after the class. This is absolutely the most efficient and cost effective way to learn new complex technologies.
What is a "Hands-On Seminar? This is a seminar format, pioneered by Homnick Systems in 2004, where the Instructor mostly uses demos to teach the attendee concepts originally presented in slide format. The attendee can approach this learning solution as a pure seminar without a laptop and then work on the courseware demos on their own time. Optionally, the attendee can "walk along" with the instructor on their own systems running a supplied Virtual Machine instance. This "walk along" can be of varied involvement and should still be supplemented with lab work on their own time. Both approaches work very well in learning the concepts and the seminar attendees are usually evenly split on the approach they select.
Optional hands-on laptop system requirements to walk along with the instructor during demos and labs:
A laptop with a minimum of 2 gig of memory, USB 2.0 port and Windows XP, Vista or 7.0 with Remote Desktop Connection.
Who Should Attend: Software Developers, Architects and Managers who want to learn about developing and implementing with SQL Server 2012.
Course Outline-SQL Server 2012
Introducing SQL Server Data Tools for Visual Studio 2010
A new integration of Data tools that let you leverage the SQL Server 2012 capabilities such as Data-Tier Application Improvements (DAC Fx) including private Cloud to Azure Cloud deployments, StreamInsight, Local Database Runtime as an Embedded Database and new capabilities in .NET 4.0 and SQL Server 2012
Introducing the SQL Server 2012 BI Semantic Model
The BI Semantic Model is one model for all end user experiences – reporting, analytics, scorecards, dashboards, and custom applications. All client tools in the Microsoft BI stack – Excel, PowerPivot, SharePoint Insights and Reporting Services now operate on this model. We explore in depth the new feature of Tabular Analysis Services and the different Server Modes available.
Introducing SQL Server 2012 Power View and New Features in PowerPivot
The 2012 release of PowerPivot for Excel includes the new features of Diagram View, Hierarchies, Reporting Properties, New DAX Functions, Blob Support, Perspectives and Key Performance Indicators. PowerPivot in SharePoint 2010 now integrates a Power View Reporting Service instance in the PowerPivot Gallery. Power View is an interactive data exploration, visualization, and presentation experience. It provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers.
What's New in SQL Server 2012 Reporting Services
Looks at the radically improved SharePoint Mode and new features including Data Alerts, Report Server Projects in SQL Server Data Tools for Visual Studio 2010, Excel Renderer for Microsoft Excel 2007-2010 and Microsoft Excel 2003 and Word Renderer for Microsoft Word 2007-2010 and Microsoft Word 2003. We will also look at improvements in SQL Azure Reporting Services.
SQL Server 2012 Master Data Services, Data Quality Services and Integration Services New Features
Improvements include Master Data Services, Data Quality Services, Shared Connection Managers, Parameters, Undo/Redo in SSIS Designer, Troubleshooting Performance and Data Issues, Viewing Dependencies for Objects, Comparing and Merging Packages, Deployment and Administration Enhancements, Object Impact and Data Lineage Analysis, Usability Enhancements, Transformations and a New Data Correction Component
SQL Server 2012 Transact-SQL New Capabilities
Improvements include the commands and areas relating to Statistical Semantic Search, Full-Text Search, Metadata Discovery, EXECUTE Statement, Ad-hoc Query Paging Implementation, New Spatial Features, Sequence Objects, THROW statement, 14 New Functions and 1 Changed Function, New and Enhanced Query Optimizer Hints, Extended Event Enhancements, OVER Clause Support Enhanced and new Analytic Functions
SQL Server 2012 New Engine Features
Are explored with reviews of Table Partitioning Improvements, Columnstore Indexes, Distributed Replay, Database Engine Extended Events, Security and Auditing Improvements, Spatial Improvements, Storing and Querying Documents with SQL Server 2012
Introducing High Availability and Disaster Recovery with SQL Server 2012 AlwaysOn
A series of capabilities geared toward High Availability made up of AlwaysOn Availability Group Connectivity, AlwaysOn Readable Secondaries and AlwaysOn Failover Clustering