Online Entity Relationship eLearning - Training Resources
Entity Relationship Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Oracle9i SQL Basic SELECT Statements

...opment life cycle. o Identify the three components of an entity relationship model. o Match the entity relationship model components with their conventions. o Match the components of Oracle9i with their functions. o Identify the tools and languages used to communicate with the Oracle server. o Match the services provided by Oracle9iAS with their functions. o Match the tools in Oracle9iDS
more...
Oracle9i SQL Basic SELECT Statements
Oracle Designer 6i First Class Design Generation

...tify the features of Oracle Designer. o Identify how the Entity Relationship Diagrammer is used to prepare for Server Design. o Identify how a Function Hierarchy Diagrammer is used to prepare for Application Design. o Identify how a Matrix Diagrammer is used to prepare for application design. o Identify the uses of the Database Design Transformer. o Identify the uses of the Application
more...
Oracle Designer 6i First Class Analysis

...uirements into the Repository including process modeling, entity relationship modeling, and function modeling. This course is part of an Oracle integrated curriculum and forms the core course to all the Oracle Designer courses. L earn To: Identify and perform the primary tasks to implement an Oracle Designer project. Input business system requirements into the Oracle Designer
more...
Oracle Database 10g SQL Fundamentals I Part 1

...cle (SDLC) with their features.
Identify features of an Entity Relationship (ER) model.
Identify features of Relational Database Management System (RDBMS).
Identify the SQL statement to retrieve data from tables.
Identify arithmetic expressions used to perform operations on data.
Identify operators used to format results in SQL statements.
Identify features of single-row functions.
more...
Data Modeling - Create Basic Models

...information modeling.
Understand the components of the Entity Relationship Model.
Understand the need for detailed definitions of attributes, Identifiers, and domains.
Understand how attributes, Identifiers and domains will be used during later development.
C ontent Emphasis
Skills-Based
A udience
Business managers, business analysts, technical analysts, database
more...
Data Modeling - Develop Depth to Your Models

...on.
Explain the benefits of Normalization.
Place an Entity Relationship (ER) Model fully in the Third Normal Form (TNF).
Consider the value of Normalization and ER Modeling.
Use normalization as a QA technique for entities.
C ontent Emphasis
Skills-Based
A udience
Business managers, business analysts, technical analysts, database designers, database administrators, and
more...
SQL and PL SQL Basic SELECT

...esses by explaining the system development life cycle and entity relationship modeling. Describe the concept of object relational database management systems. Write SQL SELECT queries. Customize SQL queries when selecting data from a table. Identify SQL*Plus environment, features, and commands. Restrict rows retrieved by a query. Identify comparison operators that can be used in
more...
Oracle SQL for End Users--Part 1

...e cycle. Match components of the EMPLOYEE and DEPARTMENT entity relationship model with their description. Define structured query language (SQL). Match SQL statement types with their appropriate SQL commands. Identify the capabilities of the Oracle implementation of ORDBMS and RDBMS. Match database column values with their data types. Match the names of the three tables used in this
more...
CIW Database Specialist Part 1 Introduction to Database Design

This is the first course in a four part series that teaches students about relational databases and database planning and design. It introduces relational databases, Codd's rules, relational data structure and the ER model. It also covers the various phases in the design life cycle and database design methodology, including the creation of ER models. Learn To: o Identify features of a
more...
From Serebra Learning Corporation
Introduction to Oracle and SQL in Oracle 9i
To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements Junior database administrators, application developers, and database operators
more...
Introduction to Oracle and SQL in Oracle Database 10g
To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements Database administrators, application developers, and database operators
more...
RDBMS Concepts
The success of an organization depends on its ability to acquire timely and accurate data about its operations, to manage this data effectively, and to use this data for analyzing its requirements and controlling its activities. Since the volume of data available to an organization might be vast, it is important to process this data to derive relevant information quickly. The data can be managed
more...
Oracle Designer First Class: Analysis
This is the first title in a series of two and covers the same material as the first half of the Instructor Led course Oracle Designer: First Class. This course takes students along a streamlined path through the Oracle Designer development environment. It covers recording business requirements into the Repository including process modeling entity relationship modeling and function modeling. This
more...
Oracle Designer 6i First Class: Analysis
This is the first course in a two part series which covers the same material as the first half of the Instructor Led course Oracle Designer 6i: First Class. The course takes students along a streamlined path through the Oracle Designer development environment. It covers recording business requirements into the Repository including process modeling entity relationship modeling and function
more...
Data Modeling: Create Basic Models
This is the first course in a two-part series which covers Data Modeling. You will begin by learning a top-down systematic approach to database development using entity-relationship models and normalization. Then you will use this approach to identify and define business information requirements both in the course and within your work environment. This course can be used as part of Oracle's
more...
Data Modeling: Develop Depth to Your Models
This is the second course in a two-part series which covers Data Modeling. You will begin by learning a top-down systematic approach to database development using entity-relationship models and normalization. Then you will use this approach to identify and define business information requirements both in the course and within your work environment. This course can be used as part of Oracle's
more...
From Teach Me IT
RDBMS Concepts

The RDBMS Concepts WBT is an end user course that provides an overview of the architecture, functions, and benefits of a database management system and discusses various database models. The course describes the data structure of a relational database model in detail. It extensively covers the normalization process and compares SQL with other popular relational databases. After completing this
more...
Developing the Solution Architecture

The Developing the Solution Architecture WBT is the second course in the Requirements and Solutions Architecture curriculum that caters to part of the Microsoft Certified Professional exam 70-100, Analyzing Requirements and Defining Solution Architectures. This course enables students to identify the essential steps performed in the various design phases of the application development process.
more...
