[tabby title=”Course Overview”] 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 […]

  [tabby title=”Course Overview”] 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 [tabby title=”Sessions”] Session 1 – SQL Foundations –  1. Understanding the SQL Server service 2. Understanding the Query Optimizer 3. Understanding the […]

  [tabby title=”Course Overview”] This series of courses is designed to provide the foundations for developers or para-developers in SQL Server, SQL and Reporting technologies. [tabby title=”Sessions”] 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 […]

  [tabby title=”Course Overview”] In a partnership agreement with Pragmatic Works, SSWUG.ORG’s virtual class is designed to help you understand all aspects of SQL Server 2008 Reporting Services (SSRS), the reporting tool of choice for SQL Server developers. Sherri McDonald, course instructor and support manager for Pragmatic Works, will use a variety of lab exercises and small projects to ensure […]

  [tabby title=”Course Overview”] In a partnership agreement with Pragmatic Works, SSWUG.ORG’s virtual class will provide you with the skills to properly use SQL Server Analysis Services (SSAS) 2008 in your enterprise. Brian Knight, course instructor and SQL Server MVP, will take you from the ground-up, teaching you the fundamental skills you need to develop and deploy SSAS solutions and […]

  [tabby title=”Course Overview”] In a partnership agreement with Pragmatic Works, SSWUG.ORG’s virtual class is designed to help you use SharePoint 2010 to bring Business Intelligence to the forefront for your users and customers. Mark Stacey, course instructor and founder of Pragmatic Works’ South Africa office, will start by showing how to configure SharePoint 2010 and explaining the parts all […]

  [tabby title=”Course Overview”] In a partnership agreement with Pragmatic Works, SSWUG.ORG’s virtual class will provide you with the skills to use MDX with SQL Server Analysis Services in your enterprise. Stacia Misner, course instructor and SQL Server MVP, will start by explaining the basic concepts related to multidimensional expressions and how they are used to enhance cubes with calculations, […]

  [tabby title=”Course Overview”] In a partnership agreement with Pragmatic Works, SSWUG.ORG’s virtual class will provide you with the skills to properly use SQL Server Analysis Services (SSAS) 2008 in your enterprise. Master Analysis Services Developers must hold unique traits to set themselves and their work apart from others.  This class is designed to take you to the next level […]

  [tabby title=”Course Overview”] In a partnership agreement with Pragmatic Works, SSWUG.ORG’s virtual class will provide you with the skills to properly use SQL Server Reporting Services (SSRS). Master Report Developers must hold unique traits to set themselves and their work apart from others.  This class is designed to take you to the next level in your understanding of SQL Server […]

  [tabby title=”Course Overview”] In a partnership agreement with Pragmatic Works, SSWUG.ORG’s virtual class is designed to introduce SQL Server DBA’s to the new and exciting features available in SQL Server 2012 . We use a variety of lab exercises to ensure lecture sessions are backed up by hands-on experience.  With the hands-on labs, you will experience how the new […]