SQL Essentials for Microsoft Configuration Manager Professionals
Starting October 24, 2023
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: Tuesday, October 24, 10:00 AM-12:00 PM Central Time (US and Canada)
- Module 2: Tuesday, November 7, 10:00 AM-12:00 PM Central Time (US and Canada)
- Module 3: Tuesday, November 14, 10:00 AM-12:00 PM Central Time (US and Canada)
- Module 4: Tuesday, November 28, 10:00 AM-12:00 PM Central Time (US and Canada)
- Module 5: Tuesday, December 12, 10:00 AM-12:00 PM Central Time (US and Canada)
- Module 6: Monday, December 18, 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
