Dinis RDB Training
The following courses are on offer
Course Code : RDBI
Introduction to RDB for DINIS.
Course Duration:
2 days
Course Description:
This course is designed to provide a solid grounding in RDB theory and
SQL practice.
This course is designed for the current DINIS System Administrator
and those charged with planning and implementing an integration
strategy.
It is intended to give users an insight into what an RDBMS is capable
of and the ways in which data stored in an RDBMS can be shared and
accessed from other applications.
Course Content:
- RDB Fundamentals
- SQL Fundamentals
- DINIS RDB Model
- Retrieving information
- More Precise Retrievals
- Advanced Retrieval Overview
- Updating Data
- Exploiting the DINIS RDB
- Data Management Overview
- Data Integration Overview
Prerequisites:
There are no pre-requisites.
Further Training:
Fujitsu Services through its associated training company Kowledgepool is
able to provide the complete range of ORACLE training courses
Fujitsu Services also offer an extensive range of Sun Unix and Oracle
training courses.
Return To Top
Course Code : RDBU
Introduction to the DINIS RDB for DINIS Users
Course Duration:
1 day
Course Description:
This is a basic and practical course for the DINIS end user.
It is focused on briefing the user on the main aspects of RDBMS use
and data access.
There will be a common core to this course that will be relevant to
all organisations, but the course will be customised to cover the tools,
report generation packages and applications that will be made available
to the user.
Course Content:
- RDB Fundamentals
- SQL Fundamentals
- DINIS RDB Tools
- DINIS RDB Report Generation Packages
- DINIS RDB Applications
- Exploiting the DINIS RDB
Prerequisites:
A competent level of DINIS skills are required, as delivered by the
Introduction to DINIS(E) - Part 1 training course.
Further Training:
Fujitsu Services through its associated training company Knowledgepool is
able to provide the complete range of ORACLE training courses.
Fujitsu Services also offer an extensive range of Sun Unix courses.
Return To Top
Course Code : RDBM
DINIS Relational Data Model
Course Duration:
1 day
Course Description:
This course is designed to introduce the relational data model used to
hold DINIS(E) network data.
This is aimed at all end users of DINIS.By careful explanation of the
relational data model it introduces the concepts associated with
relational databases and the extra opportunities for data manipulation
and presentation that they offer.
Course Content:
- Relational Database Concepts
- DINIS(E) Schema Overview
- Entity Relationship diagrams
- DINIS(E) Entities
- Relationships
- Integrity Constraints
- Use in enforcing relationships
- Naming Conventions
- Internal Data Representation
- Network Equivalent Tables
- Ordnance Survey Co-ordinates of Network Objects
- Detailed Table Explanation's
- Table Joins
- Electrical Line Tables
- Shared Data Tables
Prerequisites:
A competent level of UNIX and ORACLE System Administration skills are
required. Attendance on the course DINIS RDB for DINIS System
Administrators is required.
Further Training:
Fujitsu Services through its associated training company Knowledgepool is
able to provide the complete range of ORACLE training courses please check for further information.
Return To Top
Course Code : RDBSA
DINIS RDB for DINIS System Administrators
Course Duration:
1 day
Course Description:
This is a one day update for the DINIS System Administrator (who may be
DINIS Data Administrator and/or DBA).
It will build on the information in the current DINIS System
Administration course and will cover how the DINIS RDB module is
installed, communication with Oracle and use of the RDB
import/export/set-up utilities.
Course Content:
- DINIS(E) RDB Installation
- Oracle 7.3.x Installation
- DINIS(E) RDB - Oracle Communication
- Establishing database connectivity via SQL*Net
- Network Configuration files
- Listener control utility
- Troubleshooting connectivity errors
- Oracle database configuration for DINIS(E) RDB
- The rdbsetup utility - initializing an Oracle user schema for
DINIS(E) RDB
- DINIS(E) RDB logon options
- Setting connection parameters vis X resource strings
- Database table population - The rdbpopulate option
- The rdbimport utility
- Rdbimport data cleanup
- Controlling DINIS(E) RDB data access via Oracle's security
mechanisms
- The rdbexport utility
Prerequisites:
A competent level of UNIX and ORACLE System Administration skills are
required.
Further Training:
Fujitsu Services through its associated training company Knowledgepool is
able to provide the complete range of ORACLE training courses please check for further information.
