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 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 Led by an SCP instructor with years of experience working on hundreds of unique Solarwinds environments for companies of all sizes.

Duration: 4 days

Related Courses

Resources:

  • Solarwinds Orion 301: Database & Automation Guide by Joe Dissmeyer – Paperback/Amazon
  • Solarwinds Orion 301: Database & Automation Guide by Leon Adato, Patrick Hubbard, et al. – Paperback/Amazon
  • Solarwinds Orion Training Guide by Joe Dissmeyer – Paperback/Kindle/Amazon
  • Solarwinds Training Guide by Justin M. Brant – Kindle/Amazon
  • Solarwinds Training Guide by Joe Dissmeyer – Hardcover/Amazon

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 Training – 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:

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

SQL Server Reporting Services

  • Installation of SQL Server Reporting Services and 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

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

SolarWinds SDK

  • Installation of the SolarWinds SDK
  • Introduction to SolarWinds Query Language (SWQL)
  • PowerShell and the SolarWinds SDK
  • Connecting to SWIS
  • Querying SWIS
  • Updating SWIS

Solarwinds Orion 301: Database and Automation (LABS)

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

Request More Information

Time frame:

0