Solarwinds Orion 301: Database and Automation (Custom reports and Orion SDK) Course Overview

SolarWinds Orion 301: Database and Automation (Custom reports and Orion SDK) Public Training

SolarWinds Orion 301: Database and Automation training is a four days program designed to provide insights into the usage of database for custom reports and alerts. The classes are conducted by the SolarWinds Certified Professionals (SCP) with years’ experience of working in different SolarWinds® environments. 

SolarWinds Orion 301: Database and Automation software is designed for hybrid and cloud IT environments. It helps the system administrators identify the causes of issues through wait-time data base analysis. Its response time analysis is highly effective to identify the bottlenecks and to prioritize the actions to eliminate the identified causes.   

Benefits and Objectives of SolarWinds Orion 301 Database and Automation Course: 

• Learning designing and implementation of custom reports

• Learning about Orion SDK Survey

• Understanding NPM

• Understanding SQL Server Reporting Services (SSRS)

• Learning to use Orion Software Development Kit (SDK)

• Learning to Customize SQL Server Reporting Services

 SolarWinds Orion 301 Database and Automation class provides insights into the objective-oriented monitoring and management of large enterprise-class IT infrastructures. The gained knowledge and practical expertise for ‘Report Builder Authoring Environment’ helps to quickly add different items like launch table, map wizards, format report data, chart etc in reports.

How to Get SolarWinds Orion 301: Database and Automation Certification: 

We at Microtek Learning provide virtual public training help the students pass SolarWinds Orion 301: Database and Automation Certification exam. Once you complete training, you can appear in scheduled exam from anywhere. After passing the online exam, you get a certification kit.

Solarwinds Orion 301: Database and Automation (Custom Reports and Orion SDK) Course Outline

Our certified SCP Solarwinds Orion 301 trainers follow the most detailed syllabus for ‘Solarwinds Orion 301: Database and Automation’ training encompassing all the aspects of Custom Reports & Orion SDK.     

Day1: Orion Core Database

• Installation of NPM                                                        

• Orion Database Schema Review with Tables and Data Rollup

• Orion Database Manager and SQL Server Management Studio (SSMS) - A comparative overview of  Database Manager and SSMS

• Best practices for Orion Database Management

• Database Backups & Maintenance Plans

Day2: SQL Server Reporting Services                                                                                             

• Installation of SQL Server Reporting Services and Report Builder Authoring Environment    

• Introduction to Transact-SQL Language                 

• Orion Database Schema Review - Views, Functions and Stored Procedures

• Report Builder Authoring Environment                  

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

Day 4: SolarWinds SDK

• Installation of SolarWinds SDK                                   

• Introduction to SolarWinds Query Language (SWQL)           

• PowerShell and SolarWinds SDK - Connecting to SWIS, Querying SWIS and SWIS Updating

Microtek Learning students secure excellent pass rate in exam as well as in career growth because our professional Solarwinds Orion 301 Database and Automation trainers teach differently.    

Solarwinds Orion 301: Database and Automation (Custom Reports and Orion SDK) Prerequisites:

Orion 101, 201, or 202 trainings are not the prerequisite but the students with advanced understanding of the SolarWinds platform find the learning of NPM, SQL Server Reporting Services (SSRS), and the Orion Software Development Kit (SDK) easier.  

Students also get help from the basic understanding of Transact-SQL and PowerShell languages but neither of these is must-have qualification.

FAQs for Solarwinds Orion 301: Database and Automation Training Course 

1. How does the data retention altering affect the database size?

In SolarWinds Orion database, the collected detailed data is summarized first into hourly database increments; then it is converted into the daily data increments. Extending hourly retention affects the database size less while the extended detailed data retention impacts more on database size and its performance.

2. What is the benefit of NPM installation in daily use?

Node Package Manager (NPM) manages the dependencies of project tools, in addition, to managing multiple code versions and code dependencies etc.

3. How will I benefit by installing Orion Database Management?

By installing and understanding Orion Database Management, you will be able for improved but simplified real-time historic monitoring. You will be able to analyze index, query tuning advisors and database from different perspectives.   

4. Is there any maintenance support for Solarwinds Orion products?

Yes, SolarWinds licensed products come with one year of maintenance back up support from the date of purchase.

5. How much time will I have to spend for Solarwinds Orion 301: Database and Automation certification preparation? 

We provide the robust Solarwinds Orion 301 Database and Automation training scheduled for four days. The total virtual teaching period is 32 hours. Although you gain in-depth knowledge of all the topics in syllabus; still, you are expected to go through the online study material post training also but you never need to compromise with existing professional duties/schedule.