Orion 301: Database & Automation Public Training Class

This 4-day class takes an in depth look at NPM, SQL Server Reporting Services (SSRS), Orion Software Development Kit (SDK)

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

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

Meet the Instructor

Lorenzo
Lorenzo Brizeño

Lorenzo Brizeño has spent more than 29 years in the IT industry—10 of those with SolarWinds, in technical support initially, and then moving on to become a sales engineer. In 2019, he moved with his family to Cedar Park, TX, and joined Loop1 as a technical trainer, deciding to put to good use his talent for spreading knowledge.

Lorenzo’s background in teaching is varied, from instructing individuals in Salsa dance, to teaching IT professionals how to make practical use of software in their environment. He has a total of 12 years in instructional training and is continually searching for new ways to help impart that knowledge in an effective and enjoyable way. Lorenzo currently holds 5 SCP’s—plus he is actively working toward his sixth.

In his spare time, Lorenzo enjoys catching up on the latest football stats, traveling as often as he can, dancing with his wife, and watching his daughter grow and change daily.

Let's Talk. Take the next step in your SolarWinds Training journey today!