Courses & Workshops
209 Advanced Schema and LiveReports
Duration: 1 day
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 and workflows.
By the end of this course, you will be able to:
- 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.
- Use DBMS-specific functions and LES views/
- Create complex LiveReports and sub reports using a variety of tabular and graphical formats.
- Use LiveReports within custom Content Server interfaces.
Audience:
System Administrators with SQL knowledge, Database Administrators.
Prerequisites:
Basic knowledge of SQL and LiveReports, detailed knowledge of Content Server functionality. Content Server Administration experience would be an asset.
Pricing
| Format | Currency | Price | ||||
|---|---|---|---|---|---|---|
| Per Student at Open Text Site: | € - Benelux | 700 | ||||
| Per Student at Open Text Site: | € - France | 600 | ||||
| Per Student at Open Text Site: | € - Germany | 700 | ||||
| Per Student at Open Text Site: | € - Italy | 600 | ||||
| Per Student at Open Text Site: | AUD | 800 | ||||
| Per Student at Open Text Site: | CHF | 1150 | ||||
| Per Course at Customer Site: | GBP | 2200 | ||||
| Per Student at Open Text Site: | GBP | 550 | ||||
| Per Student at Open Text Site: | SGD | 800 | ||||
| Per Student at Open Text Site: | USD | 895 |
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 and/or workshop from Open Text.
Selection & Registration Process
Before you can register for a course or workshop, you need to select which one you want to attend. To do this, simply click on the "Add to cart" link and it will be added to your shopping cart.
Note: After clicking on the "Add to cart" link, you will be taken to the main course and workshop selection page where all of the courses and workshops you have added to your shopping cart will appear at the top of the page.
Once you have selected all the courses and workshops you want to attend, simply select the "Check-out link and complete the registration form.
| Date | Course Type | Course Name | Language | Location | Price | Add | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Feb 04, 2013 | On-site | Schema & LiveReports | Deutsch | Munich_Grasbrunn - Open Text | 700 | Add to Cart | ||||||||
| Feb 11, 2013 | On-site | Schema & LiveReports | English | Ottawa, ON - Open Text | 895 | Add to Cart | ||||||||
| Feb 19, 2013 | On-site | Schema & LiveReports | English | Reading, UK - Open Text | 550 | Add to Cart | ||||||||
| Mar 11, 2013 | On-site | Schema & LiveReports | English | Virtual Classroom - North America | 895 | Add to Cart | ||||||||
| May 06, 2013 | On-site | Schema & LiveReports | Deutsch | Munich_Grasbrunn - Open Text | 700 | Add to Cart | ||||||||
| May 21, 2013 | On-site | Schema & LiveReports | English | Reading, UK - Open Text | 550 | Add to Cart |
