Solarwinds Orion 301: Database & Automation
The Orion 301: Database & Automation class is geared towards students that have extensive experience with the SolarWinds platform, but want to do a deep dive into topics such as: NPM, SQL Server Reporting Services (SSRS), and the Orion Software Development Kit (SDK).
While our Orion 101, 201, or 202 classes are not a prerequisite, students will be more successful with an advanced understanding of the SolarWinds platform as this course will not cover installation and basic overviews. Students will also highly benefit from a basic understanding of the Transact-SQL and PowerShell languages, but neither is a requirement.
Day 1: Orion Core Database
Installation of NPM
Orion Database Schema Review
- Tables and Data Rollup
Orion Database Manager vs. SQL Server Management Studio (SSMS)
Best practices for Orion Database Management
- Creating Database Backups and Maintenance Plans
Day 2: SQL Server Reporting Services
Installation of SQL Server Reporting Services & Report Builder Authoring Environment
Introduction to Transact-SQL Language
Orion Database Schema Review continued…
- Views, Stored Procedures, and Functions
Introduction to Report Builder Authoring Environment
Day 3: SQL Server Reporting Services (continued)
Creating Basic Reports with Report Builder
Creating Parameterized Reports with Report Builder
Embedding SSRS Reports into the Orion Website
Creating Advanced SQL Alerts with the Web Alert Engine
Day 4: SolarWinds SDK
Installation of SolarWinds SDK
Introduction to SolarWinds Query Language (SWQL)
PowerShell and SolarWinds SDK
- Connecting to SWIS
- Querying SWIS
- Updating SWIS
Sorry! It looks like we haven’t updated our dates for the class you selected yet. There’s a quick way to find out. Contact us at 502.265.3057 or email info@training4it.com
Request a Date