Search SSWUG.ORG:

LEARNING EVENTS AND COURSES

Stephen Wynkoop 
TSQL for the Rest of Us
By Stephen Wynkoop
(Show Details)  

       

Time to Get Started with TSQL!


This workshop, conducted by Microsoft SQL Server MVP Stephen Wynkoop, will help you get started and understanding TSQL. He will provide information on how tools work, what you need to know about SELECT statements, DELETE, UPDATE and much more. This workshop will explore what you need to know about this core element to working with TSQL - the core language of SQL.

If you're working with SQL Server and looking to move beyond the graphical tools to create queries, views, stored procedures and the like, and you want to understand options and techniques, this is the workshop for you. With multiple live demonstrations and specific examples and how-to information, you'll learn what you really need to know for working with TSQL.

What you will learn

Here's a quick look at what you can expect from the vWorkshop:

  • The basics of databases - normalization, layout and design elements

  • Working with SELECT and the core elements of building your SQL statements

  • DELETE, UPDATE and INSERT - how do they work, what do you need to know

  • What ARE Stored Procedures, how do you create them, what are they used for, how do you build and work with them?

  • Automation options - tasks and more

  • The course will be available on-demand for 30 calendar days after the live date.


 

This is not a simple webcast in these areas. We'll explain the options, show what you can watch for, see what you need to really pay attention to. Find out what's really important in this comprehensive Workshop.


Course Structure and Cost

 

Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the classes, as well as a link that will remain active for the 30 day on-demand period.

The course cost is $169 for full SSWUG.ORG members, $199 for non-members and Free to Pro Members. The cost of the DVD with purchase of the workshop is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads and the ability to email questions to the instructor are included with course purchase only.

Once you have completed the workshop, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link.

   Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form


David Dye 
SSIS Advanced Techniques Workshop
By David Dye
(Show Details)  

       

5 Sessions Brought to you by SSWUG.ORG

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 packages and the service for running and managing packages. You can use SQL Server Data Tools, SSDT, to create solutions without writing a single line of code; or you can write managed code using the Integration Services object model to create packages programmatically or code custom tasks and other package objects.

This workshop focuses on some of the more advanced topics within Integration Services including:
1. SSIS – Creating dynamic packages
2. SSIS – Error handling and troubleshooting
3. SSIS – Deployment models
4. SSIS – Replacing dynamic SQL with variables and expressions in SSIS
5. SSIS – Leveraging the Execute SQL task in SSIS

Each separate session provides in depth discussion and demonstrations on each of outlined topics to provide a better understanding of the subject matter and the tools necessary to be able to apply these techniques in your environment.

Watch Video

Course Structure/Cost

Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the sessions, as well as a link that will remain active for the 30 day on-demand period.

The course cost is $169 for full SSWUG.ORG members, $199 for non-members and free for PRO members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, office hours and the ability to email questions to the instructor are included with course purchase only.

 

Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form

Kalen Delaney 
SQL Server 2014 In-Memory OLTP
By Kalen Delaney
(Show Details)  

       

Hekaton

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, all the time, so there is no cost for physical IO’s. In addition, these memory-optimized tables are completely lock-free and latch-free, providing additional performance benefits. Finally, you can choose to contain your application code in natively compiled procedures to avoid any query interpretation during execution, which adds additional cost savings. Current In-Memory OLTP users are seeing up to a 30-fold performance increase for their OLTP workloads.

The target audience for this class is administrators, developers or IT professionals who have experience with a recent version of SQL Server.


Watch Video
 

Course Description

In this course you will learn about:

• How to create a database for storing memory-optimized tables
• Restrictions on memory-optimized table features
• How data rows are stored
• How indexes on memory-optimized tables are different than index on disk-based tables
• Hash indexes considerations
• Managing range indexes
• Accessing data stored in memory-optimized tables
• How data is modified using completely lock-free and latch-free operations
• Concurrency management and isolation levels for In-Memory OLTP
• What checkpoint does for your completely memory-resident tables
• How recovery can restore your memory-optimized tables
• Why natively compiled procedures are so much faster than interpreted procedures

Course Structure/Cost

Once registered, you'll have instant access to all 6 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

 

Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form

Kalen Delaney 
New Features of SQL Server 2014
By Kalen Delaney
(Show Details)  

       

What a DBA needs to know!


Course Overview

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.

Start by examining how SQL Server manages the transaction log internally and looking at some undocumented commands for examining log usage and low growth. Then, Kalen will discuss what happens as the log grows and shrinks, exploring best practices for physical placement of your log file(s). She will also review various SQL Server operations to explore what gets written to the log when various operations are performed. Finally, Kalen will demonstrate how the log is processed during BACKUP and RESTORE commands, and how that processing changes in different recovery models.

The target of this class is administrators, developers or IT professionals who have experience with a recent version of SQL Server.


Watch Video
 

Session Descriptions

In this course you will learn about:

• SQL Server 2014 discontinued and deprecated features
• Licensing changes
• What’s available for SQL Server in a hybrid cloud environment
• Adjusting the lock priority for certain online operations
• New permissions to make assigning rights with a database easier
• How you can extend SQL Server’s buffer pool to a solid-state device
• AlwaysOn enhancements
• How the new updatable columnstore indexes work
• Why In-Memory OLTP is a real game changer
• How In-Memory OLTP can provide up to 30-fold performance improvement for your OLTP queries

Course Structure/Cost

Once registered, you'll have instant access to all 5 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

Once you have completed the course, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link.
 

  Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form

  
 

Kalen Delaney 
9/5/2014
New Features of SQL Server 2014
By Kalen Delaney
(Show Details)  

       

What a DBA needs to know!

Opens September 5th, 2014 and Closes After October 4th, 2014

Course Overview

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.


Watch Video
 

Session Descriptions

In this course you will learn about:

• SQL Server 2014 discontinued and deprecated features
• Licensing changes
• What’s available for SQL Server in a hybrid cloud environment
• Adjusting the lock priority for certain online operations
• New permissions to make assigning rights with a database easier
• How you can extend SQL Server’s buffer pool to a solid-state device
• AlwaysOn enhancements
• How the new updatable columnstore indexes work
• Why In-Memory OLTP is a real game changer
• How In-Memory OLTP can provide up to 30-fold performance improvement for your OLTP queries

Course Structure/Cost

Once registered, you'll have instant access to all 5 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

 

Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form

  
 

Kevin Kline 
Leadership Skills for the IT Professional
By Kevin Kline
(Show Details)  

       

Hitting the Career IT Ceiling

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 transferrable into leading people and managing resources.

Watch Video

What IT Pros Need to Be Effective Leaders

Most IT leaders earned their promotions on the basis of their technical competency, not their leadership skills. Technical leaders rarely step into leadership in possession of the complex mix of skills that engenders their success and the success of their teams. And while the results of this career transition aren’t always a disaster, we’re often left feeling that we could be doing a much better job.

This full day training seminar imparts years of hard won wisdom and the industry’s best research about how to successfully manage and lead a team of IT professionals, from all areas of information technology. Successful IT leaders require a combination of:

  • Cultivating the respect and trust of your team;
  • Behavioral knowledge to understand technology professionals; and
  • A variety of specific skills to competently lead IT professionals in the broad categories of:
    • coaching
    • facilitating change
    • promoting communication
    • growing a culture of effectiveness
    • leading teams

 

Develop Critical IT Leadership Skills in a Class Written by IT Leaders for IT Leaders

I have to be honest, my custom-written training coursework won’t train IT pros in every aspect of every leadership category. (Heck, an MBA takes at least two years of intense study and even that doesn’t guarantee a strong leader). However, my coursework will equip you with a strong foundation to confidently take on your leadership duties, handle the most common leadership issues, and avoid the most frequent and costly leadership mistakes. This coursework will enable you to further develop your leadership potential and achieve excellent results, both for yourself and for your team.

By taking this course, you will:

  1. Learn about motivating IT professionals and how to cultivate an atmosphere for effectiveness.

  2. Develop skills to envision, plan, and execute your goals at an interpersonal and organization level

  3. Review more than a dozen specific scenarios that frequently foil the new leader of IT teams and the best way to handle them, such as
    Exposing and correcting performance problems
    Managing remote employees
    Gaining support of the organizational executives
    Delegation
    Conducting impactful meetings
    Facilitating effective and productive teamwork


Course Structure and Cost

Once registered, you'll have instant access to all 14 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the allotted time, we can offer you a 30 day course extension for only $79.00.
 

   Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form

Stephen Wynkoop 
The Accidental DBA: Understanding the Core Necessities with SQL Server
By Stephen Wynkoop
(Show Details)  

       

13 Sessions Brought to you by SSWUG.ORG


Course Overview

Have you found yourself in a situation where you’re managing SQL Server systems, but need some help determining what’s important and what you need to know?

Watch Video

In SSWUG.ORG’s virtual class, conducted by Microsoft SQL Server MVP Stephen Wynkoop, you will be able to receive the information need in the real world for working with SQL Server. For the non-formally trained “Accidental DBA”, Stephen will center on learning experiences, how-to information and specific demonstrations and labs that will let you explore the topics covered. By the end of the course, you will be ready to support and manage production databases when they are working well and when they are misbehaving.

This is the perfect workshop for many types of IT professionals, including SharePoint administrators, departmental database managers or simply those who have been asked to watch over systems while performing other duties.

 

Session Descriptions

  • Performance – Stephen will focus on management, tuning and optimization for your servers. Learn about counters to monitor, common pitfalls and native tools you can use to manage and monitor your performance, as well as view what’s happening on your server.
  • Management – Find out more about ongoing management of your systems and how to determine what you to be monitoring, what types of things you can do to troubleshoot and what are best practices for your systems.
  • Best Practices – Get answers to questions like, “What are your native options for monitoring and auditing your SQL Server?”, “What options best fit in your own implementations?” and “What is the impact or overhead of the various approaches?”
  • Security – Stephen will help you with planning and implementing an access control model as well as better understanding the threats to your system, all while providing insightful tips for managing your footprint and installation vulnerabilities.
  • Disaster Recovery – Learn about the key fundamental planning points for building a disaster recovery plan by finding out how disaster recovery works, seeing what options are available and exploring the steps to properly handle backups and restores.
  • T-SQL – Get started with understanding T-SQL by moving beyond the graphical tools to create queries, views, stored procedures. Stephen will provide information on how tools work, what you need to know about SELECT statements, DELETE, UPDATE and much more.

 

Course Structure/Cost

Once registered, you'll have instant access to all 13 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

Once you have completed the course, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link.
 

   Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form




 

Scott Klein 
Introduction to Windows Azure
By Scott Klein
(Show Details)  

       

10 Sessions brought to you by SSWUG.ORG
 

Course Overview

SSWUG.ORG's virtual class will provide you with the knowledge of Window Azure's components and aspects to run applications without the expense needed to maintain the hardware and save money on licensing costs.

Watch Video

Scott Klein, who is a Microsoft SQL Azure MVP and the co-founder of Blue Syntax Consulting, will showcase the different types of services that can be hosted in Windows Azure such as web and worker roles, and then move on to the basics of Azure's durable storage solution, which include Azure queues, blobs and tables.

He will also provide a introduction on SQL Azure - Microsoft's cloud-based relational database, and how you can use SQL Azure to store your relational data on the cloud. This will be followed up by sessions dealing with Azure AppFabric, cloud computing patterns and practices, as well as diagnostics and service management.


Target Audiences and Prerequisites

The "Introduction to Windows Azure" course is intended for IT professionals, such as database administrators and application designers, who are interested in learn more about Microsoft's cloud computing offering and utilizing it in their future programs. It is helpful if students have a familiarity with SQL Server, .NET and Visual Studio.

Course Structure and Costs

Once registered, you'll have instant access to all 10 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, office hours and the ability to email questions to the instructor are included with course purchase only.

 

  Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form


 

 
 
Gareth Swanepoel 
SQL Server 2012 Delta for the DBA
By Gareth Swanepoel
(Show Details)  

       

17 Sessions Brought to you by SSWUG.org


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 features can be utilized in your everyday DBA work. This course will cover topics such as AlwaysOn, ColumnStore indexes, SQL Server Data Tools, the FileTable feature, Azure and administering the BI platform within the context of SQL Server 2012.

Watch Video

Prerequisites

 The target of this class is SQL Server DBA’s, developers, architects or IT professionals who have average to good T-SQL skills already. This class assumes that you have a good understanding of SQL Server fundamentals. For example, you should know and use the SQL Server Management Studio (SSMS) interface and associated toolbox items before attending this class. It is not mandatory but some experience using the Business Intelligence Design Studio (BIDS) interface will be an advantage to you.
 

 

Section Descriptions

Throughout the 30-day course, you will learn:

  • Administration and Performance
  • AlwaysOn and Disaster Recovery
  • Programmability
  • Administering the BI platform

 

Course Structure and Cost

Once registered, you'll have instant access to all 17 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

Once you have completed the course, you will have the opportunity to take a course quiz and receive a course certificate. After passing the quiz, please allow up to five business days after the course is finalized to receive your certificate (.PDF via e-mail).
 

   Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form




 
Devin  Knight 
Advanced SQL Server Reporting Services
By Devin Knight
(Show Details)  

       

16 Sessions 


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 2008 R2 Reporting Services (SSRS).  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 learn how to create complex reports that using Analysis Services as a data source and custom code assemblies.  This course will cover all the advanced topics of Reporting Services like scaled-out deployment, .Net integration and monitoring Reporting Services usage.

Watch Video

Target Audiences and Prerequisites

The target of this class is at developers, architects or IT professionals who have above average T-SQL skills already and a basic understanding of MDX and VB. This class assumes that you have a strong understanding of SSRS fundamentals. For example, you should already know and use the majority of the toolbox items before attending this class.  It is not mandatory but ideally you should have an instance of SharePoint to follow some sections of the class.



Course Structure and Cost

Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the classes, as well as a link that will remain active for the 30 day on-demand period.

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads and the ability to email questions to the instructor are included with course purchase only.

Once you have completed the course, you will have the opportunity to take a course quiz and receive a course certificate. After passing the quiz, please allow up to five business days after the course is finalized to receive your certificate (Download link via e-mail).

 

  Group discounts are also available to companies and organizations. To start the group registration process,
 
Download group registration/discount form
 

 

 
 
 
 
 
Adam Jorgensen 
Advanced SQL Server Analysis Services
By Adam Jorgensen
(Show Details)  

       

10 Sessions Brought to you by SSWUG.org
 

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.

Watch Video

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 in your understanding of SQL Server 2008 R2 Analysis Services (SSAS).  We use a variety of lab exercises and exclusive internals lectures to ensure lecture are backed up by hands on experience and real world knowledge.  With the hands-on labs, you will learn how to build tier 1 Analysis Services solutions that will scale, while understanding all the internals to help you back up these best practices you will be implementing.  This class will focus on the architecture, design, scaling and internals that make Analysis Services the powerful analytics platform of choice.

Target Audiences and Prerequisites

The target of this class is at developers, architects or IT professionals who have above average Analysis Services skills already and a basic understanding of MDX and cube building. This class assumes that you have a strong understanding of SSAS fundamentals. For example, you should already know and use the majority of the functions in basic cube development before attending this class.  It is not mandatory but ideally you should have an instance of Analysis Services to follow some sections of the class. 
 

Session Descriptions

Throughout the 30-day course, you will learn:

  • Analysis Services Architecture
  • Analysis Services Design Best Practices & Optimization
  • Formula and Storage Engine Query Processing
  • Managing and Scaling Analysis Services



Course Structure and Costs
 

Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the classes, as well as a link that will remain active for the 30 day on-demand period.

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, office hours and the ability to email questions to the instructor are included with course purchase only.
 

  Group discounts are also available to companies and organizations. To start the group registration process,
 
Download group registration/discount form
 

 
 
Stacia Misner 
Introduction to MDX
By Stacia Misner
(Show Details)  

       

Eight Sessions Brought to you by SSWUG.ORG


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.

Watch Video

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, as well as to query cubes to retrieve data for reports. Then, she will continue by explaining how to write MDX queries to retrieve data from an Analysis Services cube.

Stacia will also cover the following topics:

  • Common functions for creating sets and performing set-based operations
  • Development of calculations that can be used as measures or as dimension members
  • Addition of calculations and named sets to a cube for reusability
  • Script assignments for complex calculations
  • MDX and cube security
  • Optimization techniques for queries


The target audiences for this class are developers, architects or IT professionals who have some experience with Analysis Services and have a basic understanding of relational database technology. No prior programming or SQL query development experience is required.

 

Session Descriptions

Throughout the 30-day course, you will learn how to:

  • Build MDX queries
  • Create sets with functions and use functions for set operations
  • Work with hierarchical sets
  • Build calculated members and add calculations to a query
  • Debug a MDX script
  • Implement dynamic security and configure cell-level security
  • Use SQL Server Profiler to analyze queries
  • Optimize queries for the Formula Engine and the Storage Engine
     

Course Structure/Cost

Once registered, you'll have instant access to all 8 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

Once you have completed the course, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link.

 

  Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form


 

 

Mark Stacey 
SharePoint 2010 for Business Intelligence
By Mark Stacey
(Show Details)  

       

11 Sessions Brought to you by SSWUG.ORG


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.

Watch Video

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 interconnect. Then, Mark will dive into PerformancePoint, explaining how to deliver actionable scorecards for your executives and management team. He will also describe how Reporting Services can deliver beautiful reports and dashboards for your users in a SharePoint environment. Finally, Mark will demonstrate how to use PowerPivot to give your users self-service BI for their departments and how to use Excel Services for visualization.

The target of this class is developers, architects or IT professionals who have basic experience with Reporting Services and SSAS cube-browsing already. Very little time is spent in the class on the basics of Reporting Services and general cube concepts. No previous knowledge of SharePoint is required for this class.

 

Session Descriptions

Throughout the 30-day course, you will learn how to:

  • Setup and configure SharePoint 2010 for Business Intelligence
  • Create and deploy reports in Reporting Services in SharePoint
  • Develop dashboards and scorecards in PerformancePoint
  • Use Office 2010 and SharePoint 2010 for self-service Business Intelligence

     

Course Structure/Cost

Once registered, you'll have instant access to all 11 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

Once you have completed the course, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link.
 

  Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form



 

 
 
Brian Knight 
Introduction to SQL Server Analysis Services
By Brian Knight
(Show Details)  

       

12 Sessions Brought to you by SSWUG.ORG

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.

Watch Video

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 present this new data to your end users. This class is presented in SQL Server 2008, but is appropriate for those using SQL 2005 as well.

The target audiences for this class are developers, architects or IT professionals who have basic SQL skills already. This class assumes that you have no previous knowledge of OLAP or Analysis Services. Technical knowledge of basic database design concepts is assumed. It is required that you already know how to navigate around SQL Server 2005/2008 and how to query a SQL Server.

Session Descriptions

Throughout the 30-day course, you will learn how to:

  • Develop a data warehouse and a repeatable methodology for a successful SSAS project
  • Create and configure a cube and dimensions
  • Write MDX (the querying language for cubes)
  • Define calculations, Key Performance Indicators (KPIs) and perspectives
  • Implement dynamic security
  • Administer and deploy SSAS
  • Build office-based BI applications and dashboards

     

Course Structure/Cost

Once registered, you'll have instant access to all 12 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

Once you have completed the course, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link.

 

  Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form



 

Sherri McDonald 
SQL Server Reporting Services (SSRS) Made Simple
By Sherri McDonald
(Show Details)  

       

11 Sessions Brought to you by SSWUG.ORG

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.

Watch Video

Sherri McDonald, course instructor and support manager for Pragmatic Works, will use a variety of lab exercises and small projects to ensure familiarity in how the design and execution environments work and to help build real-world applications using this SQL Server subsystem. By the end of the course, you will have a firm understanding of all the key concepts of Reporting Services, including basic reporting, parameters, deploying and scheduling.

The target audience of this class is developers, architects or IT professionals who have basic SQL skills already, such as being able to run a query inside of SQL Server 2008. This class assumes that you have no previous knowledge of SSRS. In some of the coding modules, it is useful to have some basic Visual Basic experience.

 

Session Descriptions

Throughout the 30-day course, you will learn how to:

  • Develop reports with graphical representation of your data
  • Make your reports dynamic
  • Understand the concepts of dashboard design for your reports
  • Report off your Cubes, deploy and manage your reports and set-up subscriptions

     

Course Structure/Cost

Once registered, you'll have instant access to all 11 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

 Once you have completed the course, you will have the opportunity to take a course quiz and receive a course certificate. After passing the quiz, please allow up to five business days after the course is finalized to receive your certificate (.PDF via e-mail).

  Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form



 

Kalen Delaney 
Care and Feeding of the SQL Server Transaction Log
By Kalen Delaney
(Show Details)  

       

6 Sessions Brought to you by SSWUG.ORG


Course Overview

In SSWUG.ORG’s virtual class, you will learn how to manage and maintain your SQL Server transaction log, as the log is critical to optimizing operability and functionality. By the end of the six sessions, you will know why the transaction log is considered to be one of the most important components of a database, as it records all changes to your database, to allow recovery of transactions in the event of a crash.

Watch Video

Kalen Delaney, course instructor and celebrated author of SQL Server 2008 Internals, will start by examining how SQL Server manages the transaction log internally and looking at some undocumented commands for examining log usage and low growth. Then, Kalen will discuss what happens as the log grows and shrinks, exploring best practices for physical placement of your log file(s). She will also review various SQL Server operations to explore what gets written to the log when various operations are performed. Finally, Kalen will demonstrate how the log is processed during BACKUP and RESTORE commands, and how that processing changes in different recovery models.

The target of this class for administrators, developers or IT professionals who have basic experience with database administration tasks, such as backups and recovery processes. This is not a “DBA 101” course for the non-formally trained, “accidental” DBA.

 

Session Descriptions

Throughout the 30-day course, you will learn how to:

  • Keep your SQL Server transaction log healthy through proper management
  • Recover information up to the point of failure
  • Utilize the transaction log’s capabilities
  • Properly protect your data
  • Determine the best recovery model for a database

     

Course Structure/Cost

Once registered, you'll have instant access to all 6 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

Once you have completed the course, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link.
 

 Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form


 

Kalen Delaney 
SQL Server Locking, Blocking and Row Versions
By Kalen Delaney
(Show Details)  

       

Five Sessions Brought to you by SSWUG.org

 

Course Overview

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 time.

Watch Video

Kalen Delaney, course instructor and celebrated author of SQL Server 2008 Internals, will start by discussing what consistency might mean to one’s applications, and describe the details of how each of the concurrency models works internally. She will examine the costs and trade-offs between the two concurrency models that SQL Server 2008 supports through different transaction isolation levels.

The target audience of this class is administrators, developers or IT professionals who have some experience with SQL Server Management Studio and TSQL queries, as well as an understanding of basic transactional work processing. Most importantly, students should want to learn more about the way SQL Server works internally and how to take advantage of the inner working to create the best performing system and applications possible.

Session Descriptions

Throughout the 30-day course, you will learn how to:

  • Design an application with concurrency in mind
  • Understand the ways SQL Server manages concurrent user access
  • Spot causes of poor application performance
  • Troubleshoot concurrency problems
  • Recognize the details of both concurrency models – optimistic and pessimistic

     

Course Structure and Cost

Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the sessions, as well as a link that will remain active for the 30 day on-demand period.

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

Once you have completed the course, you will have the opportunity to take a course quiz and receive a course certificate. After passing the quiz, please allow up to five business days after the course is finalized to receive your certificate (.PDF via e-mail).


  Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form


 
 
Kalen Delaney 
Introduction to SQL Server Query Processing and Optimization
By Kalen Delaney
(Show Details)  

       

10 Sessions brought to you by SSWUG.ORG


Course Overview

In SSWUG.ORG’s virtual class, conducted by Microsoft SQL Server MVP Kalen Delaney, you will be able to explore needed information about query plans, basic index structures and plan cache management.

As Kalen is a foremost authority on SQL Server query processing and optimization, this comprehensive class offering will bring you key information to apply to any work with SQL Server.


Watch Video
 

Session Descriptions

Query Plans and Processing
Kalen will explain how to use the information provided in the query plan and become ready to start the query tuning process.

  • Learn the difference between estimated and actual plans, and when each is appropriate
  • Determine the difference between index seeks and scan operation actions
  • Understand when and why SQL Server performs index seeks or scan operations
  • Discover ways to get more details than the graphical plan provides
  • See different types of JOIN and aggregation algorithms
  • Comprehend different processes concerning data modification operations
  • Know certain guidelines for running the best performing modifications


Indexes
Kalen will provide an in-depth look at how to use specific tools for exploring basic index structures, as well as index design considerations and best practice guidelines.

  • Learn about key design considerations
  • Understand which types of indexes and their placements will best support certain queries
  • Determine the value of unique indexes and included columns
  • Discover composite indexes
  • See how to determine the best indexes for queries involving ANDs, ORs and JOINs
  • Know best practice guidelines involving index structures


Query Plan Caching and Recompiling
Kalen will describe how to use specific tools for exploring the plans in cache and detecting when they are reused, as well as query design considerations to provide the optimal caching behavior and best practice guidelines.

  • Learn about different types of compiled plans that can be cached and reused
  • Understand the options for controlling what plans get cached
  • Determine when plan reuse can occur and when it is beneficial
  • Discover the negative impact of parameter sniffing and seeing how it can be prevented
  • Review metadata for exploring the plan cache's contents
  • Know the resource cost of cached plans

 

Course Structure/Cost

Once registered, you'll have instant access to all 10 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

Once you have completed the course, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link.
 

  Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form

  
 

Eric Johnson 
Introduction to SQL Server Replication
By Eric Johnson
(Show Details)  

       

12 Sessions Brought to you by SSWUG.ORG


Course Overview

When working with SQL Server, as with any relational database, data is king. But data becomes less useful if you can’t gain access to it in a timely fashion. With so much data, being able to spread information across multiple servers allows for backup and quicker access. Replication is a technology available in SQL Server that facilitates the copying of data from one database to another in order to spread out load or provide redundant copies of data for high availability solutions.

Watch Video

This Virtual Class, delivered by Microsoft SQL Server MVP Eric Johnson, will guide you into the world of SQL Server Replication. The class will start at the very basics of what replication is and the different types and topologies of replication that are common in today’s environments. It will then progress to more advanced topics such as Merge Replication and using Transactional Replication as a High Availability solution. The goal of the course is to take you from never having used Replication to being competent with the technology, and provide you with a solid base of knowledge on which to implement these solutions.

You'll learn what Replication is and how Replication can be used to create reporting and highly available environments. We will cover all types of replication and ensure that you know when each type is appropriate to implement.

The class will also explore more advanced aspects of Replication such as peer-to-peer and updating subscriber replications. We will also look at troubleshooting and optimizing replication. By the end of the class you should be able to select, build, and maintain a replication environment and have a solid foundation of knowledge to draw on when things don’t go as planned.

Eric has worked with all types of Replication since SQL Server 6.5. He is bringing his experiences and frustrations to you so that you can learn Replication quickly and correctly.


 

Course Structure/Cost

Once registered, you'll have instant access to all 12 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

Once you have completed the course, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link. 
 

  Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form

 

Eric Johnson 
Advanced SQL Server Integration Services
By Eric Johnson
(Show Details)  

       

Nine Sessions Brought to you by SSWUG.ORG


Course Overview

As we build larger and more powerful data centric applications, the need to bring all this information together will become more and more important. Building efficient and intelligent ETL processes will be both a requirement and a skill that will be found to be in high demand. SQL Server Integration Services (SSIS) is one such ETL tool, and because it comes with Microsoft SQL Server, it will also continue to rise in popularity.

Watch Video

This Virtual Class, delivered by Eric Johnson, will guide you to the next level of SQL Server Integration Services development. The class will follow the development of a single project from start to finish. Along the way we will re-visit some of the basics and look at new and advanced features of SSIS. The goal of the course is to give you practical examples of development that will take your abilities to the next level.

Eric has worked with SSIS since its release with SQL Server 2005 and before that he spent a lot of time wading around in DTS packages. He is bringing his experiences and frustrations to you so that you can learn SSIS quickly and correctly.

 

Course Structure/Cost

Once registered, you'll have instant access to all 9 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.
 

  Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form


 


 

Eric Johnson 
Introduction to SQL Server Integration Services
By Eric Johnson
(Show Details)  

       

Eleven Sessions Brought to you by SSWUG.ORG


Course Overview

As we build larger and more powerful data centric applications, the need to bring all this information together will become more and more important. Building efficient and intelligent ETL processes will be both a requirement and a skill that will be found to be in high demand. SQL Server Integration Services (SSIS) is one such ETL tool, and because it comes with Microsoft SQL Server, it will also continue to rise in popularity.

Watch Video

This Virtual Class, delivered by Eric Johnson, will guide you into the world of SQL Server Integration Services. The class will start at the very basics of making a new package, and will progress towards advanced topics such as debugging and deployment. The entire goal of the course is to take you from never having used SSIS to being a competent SSIS developer in eleven sessions delivered over four weeks.

You'll learn what SSIS is and how SSIS packages can be used to create rich and robust ETL packages. We will cover all aspects of SSIS including Control Flow and Data Flow elements. You will understand how tasks, transformations, sources, and destinations all work in concert to manipulate and move data.

The class will also explore more advanced aspects of SSIS such as scripts, expressions, debugging, deployment, and much more. By the end of the class you should be able to build, automate, and deploy packages that do what you want and run efficiently.

Eric has worked with SSIS since its release with SQL Server 2005 and before that he spent a lot of time wading around in DTS packages. He is bringing his experiences and frustrations to you so that you can learn SSIS quickly and correctly.

 

Course Structure/Cost

Once registered, you'll have instant access to all 11 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

Once you have completed the course, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link.
 

Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form

 

 

Denny Cherry 
Storage and Virtualization for the Database Administrator
By Denny Cherry
(Show Details)  

       

11 Sessions Brought to you by SSWUG.ORG


Course Overview

SSWUG.ORG's virtual class will provide database administrators (DBAs) with the skills to properly design storage and virtualization solutions.

Denny Cherry, course instructor and SQL Server MVP, will explain why storage can be one of the largest bottlenecks when it comes to database performance.

Watch Video

He will also explain why it can be one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not get along. Finally, he will dig into LUNs, HBAs, the fabric, as well as the storage itself.

In the second half of the course, Denny will review the pros and cons of moving SQL Servers into a virtual environment. He will also explain how to tie virtual platforms to the storage array, so that DBAs can maximize the storage performance for their SQL Servers and the virtual environment.

 

Session Descriptions

Throughout the 30-day course, you will learn how to:

  •     Understand the capabilities of the storage solutions in your organization
  •     Bridge the communications gap between storage administrators and database administrators
  •     Use the advanced features that are present within storage arrays
  •     Reduce costs and storage requirement

     

Course Structure/Cost

Once registered, you'll have instant access to all 11 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

Once you have completed the course, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link.

 

Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form

 

Scott Klein 
Mastering SQL Azure
By Scott Klein
(Show Details)  

       

Course Overview

When SQL Azure first came on the scene there was a huge misconception that it was just another NoSQL type of database. Scott Klein, an Microsoft SQL Azure MVP, will provide you with an introductory look at the overall architecture of SQL Azure and many of the great features and benefits that SQL Azure provides. With sessions on Administration, Data Sync Services, and Application Connectivity, you'll be sure to appreciate this great, comprehensive look at SQL Azure.

Watch Video
 

Session Descriptions

Throughout the 30-day course, you will learn about:

  • Migration
  • Security
  • Backup and Restore Strategies
  • Reporting
  • Sharding and Federations

 

Course Structure and Cost

Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the classes, as well as a link that will remain active for the 30 day on-demand period.

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads and the ability to email questions to the instructor are included with course purchase only.
 
Once you have completed the course, you will have the opportunity to take a course quiz and receive a course certificate. After passing the quiz, please allow up to five business days after the course is finalized to receive your certificate (.PDF via e-mail).

   Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form



 

 
 
Dan Clark 
PowerPivot for Techies
By Dan Clark
(Show Details)  

       

12 Sessions Brought to you by SSWUG.org
 

Course Overview

In a partnership agreement with Pragmatic Works, SSWUG.ORG’s virtual class, PowerPivot for Techies is an intensive course that is designed to get you up to speed using PowerPivot quickly and productively. You will start from basic concepts and move to complex data models and DAX formulas. In addition, this course covers creating and deploying tabular data models using SQL Server Data Tools. Once deployed, tabular data models can be used by data analysts, decision makers, and information workers for ad-hoc reporting and data exploration. By the end of this course, you will feel confident using this powerful toolset to analyze and gain insight from your business data. It includes plenty of demos designed to give you practical experience using PowerPivot and creating tabular data models.

Watch Video

Prerequisites: The target audience of this class is the developer or power user who is tasked with providing a self-service BI environment to the rest of the business. This class assumes that you have no previous knowledge of PowerPivot, DAX or SQL Data Tools. Some experience with pivot tables and formulas in Excel may be helpful. .

 

Course Structure and Cost

Once registered, you'll have instant access to all 12 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads and the ability to email questions to the instructor are included with course purchase only.

Once you have completed the course, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link.

 

  Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form
.




 

Andrew Thornton-Smith 
SharePoint 2010 Administration
By Andrew Thornton-Smith
(Show Details)  

       

 

Course Overview

Great SharePoint Administrators 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 SharePoint. We use a variety of lab exercises to ensure lecture sessions are backed up by hands on experience. With the instruction in the course, you will learn how to install & configure all major areas of the SharePoint farm. This course will cover all the advanced topics of the farm like scaled-out deployment, Service Applications setup and best practices.
 

Course Structure/Cost

Once registered, you'll have instant access to all 12 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.

Once you have completed the course, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link.

   Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form