Course Description

Don't miss the chance to join a LIVE Online Training on the ViaMonstra Academy with Microsoft MVP Johan Arwidmark. In this LIVE Online Training, you will get a solid introduction to the role SQL Server has in a ConfigMgr environment and learn to use it for everyday operational and troubleshooting tasks in ConfigMgr. If you are new to SQL Server, this is the perfect course for getting started, and it is also a great foundation for our other ConfigMgr courses that list SQL experience as a prerequisite. As with all our Academy courses, the information presented is up-to-date and gathered from real-world implementations.

Note: If you already have an All-Access Pass subscription, this course has been added to your account.

This LIVE Online Training runs for six weeks, and includes: 

  • Six weekly live webinars (with recordings and Q&A)
  • Weekly assignments to guide your progress
  • A community of individuals with the same goals
  • A private Facebook group with other participants for sharing reflections, progress, etc. 
  • The chance to ask Johan Arwidmark questions directly in a live training environment


This LIVE Online Training is for YOU if you want to:

  • Learn fundamental SQL Server skills for ConfigMgr
  • Use SQL for practical everyday operational and troubleshooting tasks
  • Create and customize ConfigMgr Reports


Course Schedule

Dates and start time for the live two-hour webinars:

  • Module 1: Wednesday, January 31, 10:00 AM-12:00 PM Central Time (US and Canada)
  • Module 2: Wednesday, February 7, 10:00 AM-12:00 PM Central Time (US and Canada)
  • Module 3: Wednesday, February 14, 10:00 AM-12:00 PM Central Time (US and Canada)
  • Module 4: Wednesday, February 21, 10:00 AM-12:00 PM Central Time (US and Canada)
  • Module 5: Wednesday, February 28, 10:00 AM-12:00 PM Central Time (US and Canada)
  • Module 6: Wednesday, March 6, 10:00 AM-12:00 PM Central Time (US and Canada)

Course Outline

Module 1: SQL Server Infrastructure Primer

  • Installing SQL Server for ConfigMgr
  • Introduction to SQL Server Management Studio
  • Configuring and Optimizing the SQL Database
  • Setting Up SQL Database Maintenance
  • Configuring Security for the SQL Server Agent
  • Installing and Configuring SQL Reporting Services
  • Monitoring SQL Server Health
  • Upgrading SQL Server


Module 2: Querying Data - Introduction to Transact-SQL

  • Understanding SQL Databases and SQL Statements
  • Learning about the ConfigMgr Database
  • Using the Select Statement
  • Understanding Subqueries
  • Using Group By 
  • Sorting and Filtering Results


Module 3: Combining Multiple Tables with JOINs

  • Reviewing the ConfigMgr Tables and Views
  • Understanding Join Concepts
  • Creating Queries with Inner and Outer Joins
  • Joining ConfigMgr Views


Module 4: Using PowerShell with SQL Data

  • Connecting to Various Data Sources
  • Reading and Exporting Data
  • Searching, Sorting, and Filtering Data
  • Exploring the dbatools PowerShell Module


Module 5: SQL Server Reporting and Power BI 

  • Learning about Report Authoring Tools
  • Creating Reports for ConfigMgr
  • Customizing and Modifying Existing Reports
  • Extending Hardware Inventory and Reporting on the Data
  • Using Power BI and SQL Reporting Services


Module 6: Recovery Options: Backup and Restoring SQL

  • Troubleshooting SQL Server
  • Introduction to SQL Server Profiler
  • Backing Up Databases and Transaction Logs
  • Managing Database Backups
  • Restoring a ConfigMgr Database


Instructor

Johan Arwidmark

Johan Arwidmark is a consultant, author, speaker, and all-around geek specializing in Enterprise Windows Deployment Solutions and Systems Management. Johan speaks at several conferences each year, including MMS and Ignite around the world. He is also actively involved in the deploymentresearch.com community, and he has been awarded Microsoft Most Valuable Professional (MVP) since 2005. Johan is known for his energetic and humorous style, tackling complex concepts using simple "Real World" scenarios and lots of live demos. His areas of expertise include Enterprise Windows Deployment Tools and Management Systems: Intune, MDT, WinPE, WDS, and ConfigMgr (SCCM).

Johan Arwidmark

Technical Fellow