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.
Duration: 4 days
RESOURCES
- Solarwinds Orion 301: Database and Automation Training – https://www.wiley.com/
- Solarwinds Orion 301: Database and Automation – https://www.packtpub.com/
- Solarwinds Orion 301: Database and Automation – https://store.logicaloperations.com/
- Solarwinds Orion 301: Database and Automation – https://us.artechhouse.com/
- Solarwinds Orion 301: Database and Automation – https://www.amazon.com/
RELATED COURSES
- Solarwinds Orion 101: Introduction to Solarwinds Training
- Solarwinds Orion 201 System Management & Monitoring Training
- SolarWinds Orion 202: Advanced Server Training
- Solarwinds Security Event Manager Training
- Solarwinds Web Help Desk Training
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