Class Info

Online Course: Real World Database Configuration and Tuning for SQL Server
Class Info

Online Course: Real World Database Configuration and Tuning for SQL Server

  This online training event combines a thorough overview of key concepts followed by hands-on demos to reinforce each conceptual lesson. Since most technologists learn by doing, this training is designed to maximize the time attendees spend working with SQL Server. With ample demos, we’ll cover the spectrum of best practices as they relate to server and database design & […]

Online Course: SSIS Advanced Techniques Workshop
Class Info

Online Course: SSIS Advanced Techniques Workshop

  In 2005 Microsoft introduced SQL Server Integration Services, SSIS, as their primary ETL (Extract, Transform, and Load) tool. SSIS fully integrates with the Common Language Runtime, CLR, and provides a platform for building enterprise-level data integration and data transformations solutions. Integration Services includes a number of built-in tasks and transformations as well as tools for constructing packages and the […]

Online Course: SQL Server Architectures and Development for Reporting Services
Class Info

Online Course: SQL Server Architectures and Development for Reporting Services

  This course is designed for software developers, architects and their managers who specify, design, code, assemble, test, deploy, support, update and live with business applications that manage SQL Server data or develop Business Intelligence solutions targeting Reporting Services Session 1 – SQL Foundations –  1. Understanding the SQL Server service 2. Understanding the Query Optimizer 3. Understanding the support tools 4. Managing Users and […]

Online Course:  New Features of SQL Server 2014
Class Info

Online Course: New Features of SQL Server 2014

  Kalen Delaney, course instructor and celebrated author of SQL Server 2012 Internals, will introduce you to the new features of SQL Server 2014 that every DBA should know about. The target of this class is administrators, developers or IT professionals who have experience with a recent version of SQL Server. Session Descriptions In this course you will learn about: […]

Online Course:  SQL Server 2014 In-Memory OLTP
Class Info

Online Course: SQL Server 2014 In-Memory OLTP

  Kalen Delaney, course instructor and celebrated author of SQL Server 2012 Internals, will tell you all about how SQL Server 2014’s In-Memory OLTP works. In-Memory OLTP (Codename “Hekaton”) is a completely new way of managing your SQL Server data, allowing incredible performance improvements. You can choose some or all of your critical tables to be stored completely in memory, […]

Online Course: Databases, SQL and Reporting Services: Foundations
Class Info

Online Course: Databases, SQL and Reporting Services: Foundations

  This series of courses is designed to provide the foundations for developers or para-developers in SQL Server, SQL and Reporting technologies. Session 1 – Database Foundations –  1. Understanding Databases and DBMSs 2. Understanding Relational Databases, Objects and Constraints 3. Understanding Normalization, Relationships and Indexes 4. Using the Database Explorer and SSMS to Create a Database 5. Understanding Login IDs and Rights Session 2 – Structured […]