3-0127 - Content Server Schema and Report Fundamentals
Duration: 2 days
Understand the Content Server schema and the relationships among various tables. Learn to write 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 SQL queries and LiveReports to retrieve information about Content Server content, permissions, attributes, users/groups, workflows, and many other types of content
- Learn about all the features of the LiveReport creation interface
On completion of this course, participants should be able to:
- Write SQL queries and create LiveReports to retrieve information about users and groups, categories and attributes, notifications, form data and workflow details, and other Content Server items
- Write useful SQL and create LiveReports in Content Server using DBMS-specific functions and views
- Learn about the LiveReport creation interface and its many features and controls
- Locate resources for querying workflow and form data, as well as use LiveReports within custom Content Server interfaces
Delivery Options:
- Instructor-led
- Public: See scheduled public classes below
- Private: Email Us for information on how you can arrange a private class.
- On Demand
- Register for this option here: 3-0127 OpenText Content Server Schema and Report Fundamentals On Demand
Audience
- Business Analyst, Administrator, Developer
Prerequisites
- 1-0184 Managing Documents in Content Server and 1-0185 Collaborating in Content Server or equivalent experience
- 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 | € | 1,500.00 |
Per Student | GBP | 1,200.00 |
Per Student | SGD | 1,750.00 |
Per Student | USD | 1,800.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 and workshop calendar
Below is a listing of all the currently available dates and locations for this course or workshop from OpenText.
Start Date | End Date | Start Time | TimeZone | Session Duration | Language | Location | Price | Currency | Guaranteed To Run | Add |
---|---|---|---|---|---|---|---|---|---|---|
Nov 11, 2024 | Nov 13, 2024 | 10:00 | (UTC+01:00) Europe/Paris (CET) | Full Day | English | Virtual Classroom - Europe | 1,500.00 | EUR | Add to cart | |
Nov 11, 2024 | Nov 12, 2024 | 10:00 | (UTC+01:00) Europe/Paris (CET) | Full Day | Deutsch | Virtual Classroom - Germany | 1,500.00 | EUR | Add to cart | |
Nov 12, 2024 | Nov 13, 2024 | 9:00 | (UTC-06:00) America/Chicago (CST) | Full Day | English | Virtual Classroom - North America | 1,800.00 | USD | ✔ | Add to cart |
Jan 06, 2025 | Jan 07, 2025 | 9:00 am | (UTC-06:00) America/Chicago (CST) | Full Day | English | Virtual Classroom - North America | 1,800.00 | USD | Add to cart | |
Jan 07, 2025 | Jan 07, 2025 | 10:00 | (UTC+01:00) Europe/Paris (CET) | Full Day | English | Virtual Classroom - Europe | 1,500.00 | EUR | Add to cart | |
Jan 07, 2025 | Jan 08, 2025 | 10:00 | (UTC+01:00) Europe/Paris (CET) | Full Day | Deutsch | Virtual Classroom - Germany | 1,500.00 | EUR | Add to cart | |
Feb 24, 2025 | Feb 25, 2025 | 9:00 am | (UTC-06:00) America/Chicago (CST) | Full Day | English | Virtual Classroom - North America | 1,800.00 | USD | Add to cart | |
Apr 03, 2025 | Apr 04, 2025 | 10:00 | (UTC+02:00) Europe/Paris (CEST) | Full Day | Deutsch | Virtual Classroom - Germany | 1,500.00 | EUR | Add to cart | |
Apr 03, 2025 | Apr 04, 2025 | 10:00 | (UTC+02:00) Europe/Paris (CEST) | Full Day | English | Virtual Classroom - Europe | 1,500.00 | EUR | Add to cart | |
Jun 10, 2025 | Jun 11, 2025 | 10:00 | (UTC+02:00) Europe/Paris (CEST) | Full Day | Deutsch | Virtual Classroom - Germany | 1,500.00 | EUR | Add to cart | |
Jun 10, 2025 | Jun 11, 2025 | 10:00 | (UTC+02:00) Europe/Paris (CEST) | Full Day | English | Virtual Classroom - Europe | 1,500.00 | EUR | Add to cart |