Class Info

Online Course: SQL Server Integration Services End to End
Class Info

Online Course: SQL Server Integration Services End to End

  In SQL Server 2005 Microsoft introduced SQL Server Integration Services, SSIS, as the replacement to Data Transformation Services, DTS and the primary ETL tool for developers. Over the past 9 years SSIS has evolved and now includes tasks and transformations for Change Data Capture as well as Data Quality Services. This workshop is meant to serve as a tool […]

Online Course: Leadership Skills for the IT Professional
Class Info

Online Course: Leadership Skills for the IT Professional

  There comes a point in the career of most IT Professionals that advancement means taking on at least some degree of leadership in their organization. The only problem is that most IT pros built their career and earned all of their accolades on a set of technology skills that aren’t transferable into leading people and managing resources. What IT […]

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:  SQL Server Locking, Blocking and Row Versions
Class Info

Online Course: SQL Server Locking, Blocking and Row Versions

  In SSWUG.ORG’s virtual class, you will learn about locking, blocking and row versions, which are some of the most important topics to understanding SQL Server’s internal behavior. By the end of the five sessions, you will know how these technologies are used to manage SQL Server concurrency – the ability of multiple users to access data at the same […]

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 […]