Infrastructure at your Service

SQL Server 2012 New Features workshop

dbi InSite Workshops

You have little or no experience in Microsoft SQL Server 2012 database administration and want to know what is new in this new version of SQL Server? Then you should attend our SQL Server 2012 New Features workshop training. In this three-day course, you will learn all about SQL Server 2012 new features and tools, changes, and enhancements – including ColumnStore Indexes, Contained Databases, Sequences, and AlwaysOn.

 

Training’s dates

3 days
CHF 2700.- *

Trainers

  • Stéphane Haby
    Stéphane Haby
  • David Barbarin
    David Barbarin

(*) Prices shown without VAT

SOUG (Swiss Oracle User Group) The members of the SOUG (Swiss Oracle User Group) benefit from a 5 % reduction.

Training objectives

  • Understand the new features of SQL Server 2012
  • Get acquainted with the new installation and configuration options
  • Experience the new T-SQL enhancements, e. g. Sequences, Contained Databases, FileTables, and ColumnStore Indexes
  • Learn all about the new maintenances features and tools, such as the Database Recovery Advisor or the new DMVs (Dynamic Management Views)
  • Experience the new high availability features AlwaysOn and Availability Groups

Topics

  • Installation and configuration on Windows Core, new update
  • SEQUENCES,  CONCAT, EOMONTH, TRY_PARSE, and other T-SQL enhancements
  • SQL Server Management Studio (SSMS): snippets, T-SQL debugger, task list
  • SQL Server Data Tools (SSDT) , Powershell 2.0, and SQLCMD enhancements
  • Database security: Contained Databases and user defined server roles
  • Database objects: FileTables, ColumnStore Indexes, Geospatial Support
  • Maintenance: Database Recovery Advisor, Resource Governor, Distributed Replay
  • Troubleshooting: extended events, new DMVs, online operators
  • High Availability: AlwaysOn, Multi-database failover, Multiple Secondaries, Availability Groups

Method

  • Presentation with countless practical exercises and trainings
  • Case studies, live demos, discussions
  • Networking during coffee break, lunch, and apéro on last day (included in price, except for on-site workshop courses)

Target groups

  • Database administrators (DBA) as well as network, system, and application administrators responsible for or supporting SQL Server databases

Language & documentation

  • Workshop training normally held in English; French or German possible instead as course languages
  • Documentation: content details, scripts, case study solutions as PDF file (in English)
 

dbi InSite Workshop on-site - request & information

You want dbi services to hold an "on-site" workshop inside your organisation? You have special requirements, e. g. regarding the content, the duration, the date, or the number of participants?
We have good news for you: Our dbi InSite Workshops can be flexibly adapted to your needs! Please just fill in the form below and we will come back to you as soon as possible. You may also use this form to inquire on the future dates of our dbi InSite Workshops.





Please contact me via :

 E-mail Phone

Where did you know dbi services ?


captcha

Pierre-Yves Brehier
Pierre-Yves Brehier

Region Manager







captcha