Solarwinds Orion 301: Database & Automation Training

Solarwinds Orion 301: Database & Automation Training

Print Friendly, PDF & Email

Introduction:

Solarwinds Orion 301: Database and Automation Training with Hands-on Labs (Online, Onsite and Classroom Live)

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

solarwinds training courses

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.

RESOURCES

Duration: 4 days

RELATED COURSES
Solarwinds Orion 301: Database & Automation – CUSTOMIZE It:
  • If you are familiar with some aspects of Solarwinds Orion 301: Database & Automation, we can omit or shorten their discussion.
  • We can adjust the emphasis placed on the various topics or build the Solarwinds Orion 301: Database & 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 & Automation course in manner understandable to lay audiences.
Solarwinds Orion 301: Database and Automation – AUDIENCE / TARGET GROUP:

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

  • Administrators
  • Networking team
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 & 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

Whether you are looking for general information or have a specific question, we want to help!

Request More Information

    Time frame:

    0