New Functions of SQL 2012 from a Programmer’s Perspective


The course aims to prepare database programmers to be able to use SQL Server 2012 to its full capacity. It covers a range of topics, starting with choosing most appropriate tools, writing and optimizing T-SQL code, programming the access to non-relational types of data and writing SQLCLR code, and finishing with using tried and tested design patterns. We have designed this course building on our many years’ experience, best programming practices and tried and tested methods of their use in database projects. All this has resulted in a course which will enable you to use fully the extended capabilities of SQL 2012 for database applications.


  • Course level: 400
  • Start date: as required
  • Duration time: 2 days

Price: 2800 zł

  • Open training
  • On-site (costumer's premises)
  • Customer’s computer


The course has been designed with database programmers in mind, but also anyone with experience in working with previous SQL Server versions, wanting to learn about the new functions of SQL Server 2008. The participants will acquire the practical skills necessary for creating database applications using various SQL Server 2012 editions.


The basic training is comprised of 8 modules. Just like all the other courses on our offer, it has been designed by our experts, therefore we can freely customize it to suit the individual needs of the participants.  We would like to encourage you not only to choose modules which you find relevant for your needs, but also to feel free to contact us with your suggestions and questions you would like to hear answered throughout the course.
Our trainings are unique also because we limit the time set aside for laboratory type classes customarily conducted after the completion of each module, to the benefit of exercises done with the assistance of the trainer and demonstrations. We believe in this manner we can equip you with substantially more practical information and tips, and focus on dealing with the issues directly within your scope of interest. However, each day of the training is finished with a laboratory class of approximately 1hr, so that you can do self-practice and do exercises of your choice.


Duration: Level:
Module 1

Developer’s Tools
  • SQL Server Management Studio and SQL Server Data Tools
  • Visual Studio 2010 Database Projects (SQLCLR)
  • Online Development
  • Database Projects
  • Source Code Versioning
  • Debugging Stored Procedures and Functions
  • Code Versioning and Synchronizing Changes
  • Refactoring T-SQL Code
  • Unit Tests
  • Deploying and Publishing Database Projects
  • Data-Tier Applications

120 minutes 300
Module 2

T-SQL Improvements
  • New System Functions
  • Ad-Hoc Query Paging
  • Over Clause (Ranging, Grouping and Analytic Functions, Grouping, Ordering and Selecting Rows)
  • Sequence Objects
  • Metadata Discovery
  • THROW Statement

180 minutes 400
Module 3

Non-Relational Data
  • New and Enhanced Spatial Features
  • Spatial Index Improvements
  • Full-Text Search Improvements
  • Full-Text Search Service and Multilanguage Documents
  • FileTable
  • Property-Scoped Searching
  • Statistical Semantic Search

120 minutes 400
Module 4

CLR Integrations
  • SQL Server as a .Net Runtime Host
  • SQLCLR Reliability, Scalability, and Security
  • Assemblies and User-Defined Objects (Functions, Procedures, DML And DDL Triggers, User-Defined Types and Aggregates)
  • SQLCLR Best Practices
  • SSDT and SQL Server Database Project
  • Entity Framework Enhancements (Support for SQL Data Types, New Diagrams, Support for New Database Objects)
  • Code First Approach

120 minutes 400
Module 5

  • Unit Tests with Visual Studio 2010
  • Distributed Replay Utility (Components, Compatibility and Performance Tests Versus Scalability Tests)

60 minutes 400
Module 6

Occasionally Connected Systems
  • SQL Express Local Database Runtime versus SQL Compact and SQL Server Express
  • SQL Express Local Database Runtime (Installation and Configuration, Creating and Connecting Databases, Managing Local Databases)

60 minutes 400
Module 7

DAC improvements
  • Data-tier Application Component (DAC) Framework
  • Deploy and Upgrade Enhancements
  • Support for New Data Types
  • Import and Export Data
  • SQL Azure Integration

30 minutes 400
Module 8

SQL Server StreamInsight 1.2
  • CEP (Complex Event Processing) Architecture
  • Overwiew of Streaminsight Platform
  • New Features in Streaminsight 1.2
  • IEnumerable and Observable Collection

30 minutes 400


Ask Question