EncartaLabs

CA Automic Workload Automation - Database

( Duration: 3 Days )

This CA Automic Workload Automation - Database training course explains the database schema for CA Automic Workload Automation, showing techniques and best practices for Automation Engine database queries. You will learn how to retrieve data from the Automation Engine database using a SQL client and directly via the Automic Web Interface (AWI).

By attending CA Automic Workload Automation - Database workshop, delegates will learn to:

  • Write SQL queries that retrieve data from the Automation Engine database.
  • Identify best practices for querying the Automation Engine database.

  • Experience with using the Automation Engine
  • Access to the Automation Engine Database
  • Basic SQL knowledge – particularly SELECT Statements

The CA Automic Workload Automation - Database class is ideal for:

  • Experienced users of the CA Automic Workload Automation who have access to and need to run jobs against the Automation Engine database

COURSE AGENDA

1

Day 1: SQL

  • Relational database systems: concepts and basic terms
  • The SELECT statement: operators and practical use-cases
  • Functions
  • Subselects
  • Common table expression
  • Recursive database queries
  • Join
  • Three-valued logic and NULL
2

Day 2: The Automation Engine Database

  • AE database
  • Existing documentation
  • Standards
  • Best practices for queries to the database
  • AE DB schema
  • Queries on the object area, the activities area, and the archive and statistics area
  • Methodical approach to new queries and requirements
3

Day 3: Workshop

  • Customer examples or group exercises

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top