RSS
Select Language


Course Upgrading your Developer skills to SQL 2008


Duration (days): 3
Price (CZK): 12000

Upgrading your Developer skills to SQL 2008 topics:


T-SQL Enhancments

  • New Date and Time Data Types
  • Table-Valued Parameters
  • Row Constructors
  • Grouping Sets
  • MERGE statement
  • Performance Enhancements

New SQLCLR Data Types and Sparse

  • Spatial Data
  • Filestream Data Storage
  • XML Data and Query
  • Hierarchies and HierarchyID
  • Sparse Data Designs

Service Broker as new fresh fish

  • Service Broker and Application Design Patterns
  • Service Broker Application Construction
  • Service Broker Programming

SQL CLR - Old dog in the new habbit

  • SQLCLR Reliability, Scalability, and Security
  • Assemblies
  • Functions, Procedures, and Triggers
  • User-Defined Types and Aggregates
  • T-SQL to SQLCLR Mapping
  • SQLCLR Best Practices

Visual Studio for Database Developers

  • Visual Studio Team System 2008 Database Edition
  • Visual Studio Database (SQLCLR) Projects
  • Debugging SQL Server with Visual Studio

Client Programmability

  • Native Client Programming
  • ODBC and OLE DB
  • ADO.NET Programming with SqlClient
  • JDBC Programming
  • LINQ to SQL

Extended Events - advanced troubleshooting

  • Exteded Events
  • ETW (Event Tracing for Windows) correlation

Entity Framework - new apporoaches to data tier

  • Entity Data Modeling
  • Mapping SQL Server to Objects
  • ADO.NET and EntityClient
  • The Entity SQL Language
  • Object Context
  • LINQ to Entities

Other new beasts

  • HTTP Programming And SQL Server
  • PowerShell SQL Server programming
  • SMO Enhancements

Occasionally Connected Systems - clouds everywhere

  • Occasionally Connected System Designs
  • SQL Server Compact Edition 3.5
  • Programming - SqlResultSet and DataSet
  • LINQ and future EDM Support
  • Server-Directed Synchronization
  • Sync Services
  • Using Sync Services with SQL Server 2008

Nevyhovuje Vám osnova ?All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs