skip to main content

3-0127 OpenText Content Server Schema and Report Fundamentals v16.2.4

Have questions about training?   Contact us

Duration: 2 days

Understand the Content Server schema and the relationships among various tables. Learn to write complex SQL queries and LiveReports to extract information from core Content Server tables and from Users/Groups, custom Attributes, Notifications, eLink, and Workflows.

Highlights:

  • Locate many types of Content Server data within the database and plan sophisticated reports.
  • Write simple and complex SQL queries and LiveReports to retrieve information about Content Server content, permissions, attributes, users/groups, workflows, and many other types of content

On completion of this course, participants should be able to:

  • Write SQL queries and LiveReports to retrieve information about users, groups, notification, form data and workflow details, and other Content Server items
  • Write useful SQL and LiveReports using DBMS-specific functions and views
  • Locate resources for querying workflow and form data, as well as use LiveReports within custom Content Server interfaces

Audience

Administrator

Prerequisites

  • 1-0184 Managing Documents in Content Server and
  • 1-0185 Collaborating in Content Server
  • and
  • A strong understanding of Content Server functionality; in particular, you need to know about the types of items that can be added to Content Server such as Categories and Attributes, notification, users, and groups, however, Administration-level training is not required
  • Knowledge of SQL (structured query language). This class requires that you have a basic understanding of SQL concepts. In particular, you need to know the fundamental parts of an SQL select statement, including the use of where clauses and the use of alias notation
  • Pricing

    Format Currency Price
    Per Student at OpenText Site € - Germany  1,400.00 
    Per Student at OpenText Site € - Nordic  1,400.00 
    Per Student at OpenText Site AUD  1,600.00 
    Per Student at OpenText Site GBP  1,100.00 
    Per Student at OpenText Site SGD  1,600.00 
    Per Student at OpenText Site USD  1,790.00 

    Taxes: All prices exclude VAT or other taxes where applicable (all currencies).

    Extra expenses: Customer site course prices do not include instructor travel expenses, which are billed separately.

    Reservations: Please provide a minimum of 3 weeks advance notice when arranging courses at customer sites.

    Course & Workshop Calendar

    Below is a listing of all the currently available dates and locations for this course or workshop from OpenText.

    To register, please select the course you want to attend by clicking the "Add to cart" button.

    Date Course type Course name Language Location Price Add
    Jan 13, 2020  On-site  3-0127  English  Virtual Classroom - North America 1,790.00  Add to cart
    Jan 22, 2020  On-site  3-0127  Deutsch  Munich_Grasbrunn - Open Text 1,400.00  Add to cart
    Feb 10, 2020  On-site  3-0127  English  Ottawa, ON - OpenText 1,790.00  Add to cart
    Mar 23, 2020  On-site  3-0127  English  Virtual Classroom - North America 1,790.00  Add to cart
    May 04, 2020  On-site  3-0127  English  Ottawa, ON - OpenText 1,790.00  Add to cart
    Jun 09, 2020  On-site  3-0127  Deutsch  Munich_Grasbrunn - Open Text 1,400.00  Add to cart
    Jun 15, 2020  On-site  3-0127  English  Virtual Classroom - North America 1,790.00  Add to cart