Solarwinds Orion 301: Database and Automation Training

This 4-day Solarwinds Orion 301: Database and Automation Training class takes an in depth look at NPM, SQL Server Reporting Services (SSRS), Orion Software Development Kit (SDK)

This Solarwinds Orion 301: Database and Automation Training course is a comprehensive overview and detailed explanation of utilizing the database for custom reporting and alerts. The Solarwinds Orion 301: Database and 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.

The Solarwinds Orion 301: Database and Automation class is Led by an SCP instructor with years of experience working on hundreds of unique Solarwinds environments for companies of all sizes.

Solarwinds Orion 301: Database and Automation TrainingDuration: 4 days

RESOURCES
RELATED COURSES
CUSTOMIZE It
  • We can adapt this Solarwinds Orion 301: Database and Automation course to your group’s background and work requirements at little to no added cost.
  • If you are familiar with some aspects of this Solarwinds Orion 301: Database and Automation course, we can omit or shorten their discussion.
  • We can adjust the emphasis placed on the various topics or build the Solarwinds Orion 301: Database and Automation Course around the mix of technologies of interest to you (including technologies other than those included in this outline).
  • If your background is nontechnical, we can exclude the more technical topics, include the topics that may be of special interest to you (e.g., as a manager or policy-maker), and present the Solarwinds Orion 301: Database and Automation course in manner understandable to lay audiences.
AUDIENCE/TARGET GROUP

The target audience for this Solarwinds Orion 301: Database and Automation course:

  • Administrators
  • Networking team
CLASS PREREQUISITES

The knowledge and skills that a learner must have before attending this Solarwinds Orion 301: Database and Automation course are:

  • N/A
Solarwinds Orion 301: Database and Automation Training - OBJECTIVES

Upon completing this Solarwinds Orion 301: Database and Automation course, learners will be able to meet these objectives:

  • Design/Implement custom reports & review Orion SDK
  • NPM, SQL Server Reporting Services (SSRS), Orion Software Development Kit (SDK)
  • SQL Server Reporting Services
  • SolarWinds SDK
Solarwinds Orion 301: Database and Automation Training - COURSE SYLLABUS
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
Solarwinds Orion 301: Database and Automation Training Course Wrap-Up

Whether you are looking for general information or have a specific question, we want to help.
Request More Information

    Time frame: