Oracle Database Foundations

Oracle Database Foundations Course + Exam

Oracle Database Foundations Certification

The Oracle Database Foundations 1Z0-006 certification training course is designed for candidates who wish to build a solid foundation in Oracle databases.

This Oracle Database Foundations certification training enhances your understanding of the different types of database models and components.

This instructor-led training course will boost your knowledge of database components, concepts, design, and implementation of business roles. You will also learn about the SQL Language and queries and ERD modelling and language to manage data and transactions.

Upon completion, participants can attempt the 1Z0-006 Oracle certification exam to get certified.

Basic knowledge of databases

Candidates can achieve this certification by passing the following exam(s).

  • Oracle 1Z0-006 – Database Foundations

The certification exam can be registered and attempted within 3 months of course/module completion at Logitrain training centre on weekdays during normal business hours (excludes public holidays)

Oracle Database Foundations – Logitrain course material

  • Database Concepts
  • Relational Database Concepts
  • Gathering Requirements for Database Design
  • Using Conceptual Data Modeling
  • Using Unique Identifiers, Primary and Foreign Keys
  • Documenting Business Requirements and Rules
  • Using Attributes
  • Identifying Relationships
  • Identifying Hierarchical, Recursive, and Arc Relationships
  • Validating Data Using Normalization
  • Mapping Primary, Composite Primary and Foreign Keys
  • Using Data Definition Language (DDL)
  • Defining and using Basic Select statements
  • Defining Table Joins
  • Types of Databases Models
  • Defining Levels of Data Abstraction
  • The Language of Database and Data Modeling
  • Defining a Table in a Database
  • Defining Instance and Schema in Relational Databases
  • Data Modeling – Creating the Physical Model
  • Creating Physical Data Models
  • Defining Supertype and Subtype Entity Relationships
  • Using Unique Identifiers (UIDs)
  • Resolving Many to Many Relationships and Composite Unique Identifiers
  • Tracking Data Changes Over Time
  • Mapping the Physical Model
  • Mapping Entities, Columns and Data Types
  • Introduction to SQL
  • Using Structured Query Language (SQL)
  • Using Data Manipulation Language (DML) and Transaction Control Language (TCL)
  • Displaying Sorted Data

 

This course is likely to add to the employment-related skills of the participants. The skills developed are likely to be used in the course of being an employee or working in a business.

  • Database administrators
  • Database developers
  • Candidates seeking Oracle Database certifications
  • Describe the components of a database system
  • Explain the purpose of a database
  • Describe the characteristics of a relational database
  • Explain the importance of relational databases in business
  • List the major transformations in database technology
  • Gather requirements to implement a database solution
  • Explain business rules
  • Describe a conceptual data model
  • Explain the components of a conceptual/logical model
  • Identify unique identifiers and a corresponding primary key
  • Define composite and compound primary keys
  • Define relationships and corresponding foreign keys
  • Define barred relationships and the corresponding primary keys
  • Explain the importance of clearly communicating and accurately capturing database information requirements
  • Identify structural business rules
  • Identify procedural business rules
  • Identify business rules that must be enforced by additional programming (eg SQL)
  • Describe attributes for a given entity
  • Identify and provide examples of instances
  • Distinguish between mandatory and optional attributes
  • Distinguish between volatile and nonvolatile attributes
  • Explain  one-to-one,  one-to-many, and many-to-many relationships
  • Identify the optionality necessary for a relationship
  • Identify the cardinality necessary for a relationship
  • Identify nontransferable relationships
  • Name a relationship
  • Create ERDish sentences to represent ERDs
  • Create ERDs to represent ERDish sentences
  • Define a hierarchical relationship
  • Define a recursive relationship
  • Define an arc relationship
  • Identify  UIDs in a hierarchical, recursive and arc relationship model
  • Construct a model using recursion and hierarchies
  • Identify similarities and differences in an arc relationship and a supertype/subtype entity
  • Define the purpose of normalization
  • Define the rules of First, Second, and Third Normal Forms
  • Apply the rules of First, Second, and Third Normal Form
  • Identify primary keys from an ERD
  • Identify which ERD attributes would make candidate primary keys
  • Describe the purpose of a foreign key in an Oracle Database
  • Identify foreign keys from an ERD
  • Describe the relationship between primary keys, composite primary keys, and foreign keys in an Oracle Database
  • Describe the purpose of DDL
  • Use DDL to manage tables and their relationships
  • Identify the connection between an ERD and a Relational Database using SQL SELECT statements
  • Build a SELECT statement to retrieve data from an Oracle Database table
  • Use the WHERE clause to the SELECT statement to filter query results
  • Describe the different types of joins and their features
  • Use joins to retrieve data from multiple tables
  • Describe types of database models (relational, object oriented, flat, network…)
  • Compare the differences between the different types of databases
  • Define the terminology used for database storage
  • Describe levels of data abstraction used in relational databases
  • Describe the structure of a single table
  • Examine examples of an entity and a corresponding table
  • Examine examples of an attribute and a corresponding column
  • Explain instances and schemas in a relational database
  • Create a physical data model
  • Compare conceptual and  physical data models
  • Describe an example of an entity
  • Define supertype and subtype entities
  • Implement rules for supertype and subtype entities
  • Define the types of unique identifiers
  • Select a unique identifier using business rules
  • Define a candidate unique identifier
  • Define an artificial unique identifier
  • Resolve a many-to-many relationship using an intersection entity
  • Identify the variations of unique identifiers after creation of an intersection entity
  • Define a barred relationship
  • Identify composite unique identifiers
  • Explain necessity of tracking data changes over time
  • Identify data that changes over time
  • Identify the changes in unique identifiers after adding the element of time to an ERD
  • Map entities to identify database tables to be created from an ERD
  • Identify column data types from an ERD
  • Identify common data types used to store values in a relational database
  • Explain the relationship between a database and SQL
  • Describe the purpose of  DML
  • Use DML to manage data in tables
  • Use TCL to manage transactions
  • Use the ORDER BY clause to sort SQL query results
Learn More
  • This field is for validation purposes and should be left unchanged.
What is included with the Oracle Java Foundations Course?
Logitrain course includes official certification exam fee.
Includes Official Exam Fee

Take the certification exam within 3 months of course / module completion

Logitrain is an Authorised Pearson VUE Test Centre.
Authorised Test Centre

Take the official vendor certification exam at the Logitrain training center

Logitrain courses, programs and packages includes course material.
Includes Books & Meals

Course material in hardcopy is included. Full-time classroom courses include meals

Logitrain courses, packages and programs includes sample practise questions.
Includes Mock & Test Questions

Mock tests included in full-time courses for 3 months from course completion

Logitrain full-time course includes course retake, if you do not pass the official certification exam.
Highly Skilled Trainers

Our trainers are highly skilled with expertise and extensive hands-on experience

Logitrain courses include price beat guarantee.
Our Price Beat Guarantee

Relax, we will beat competitor’s advertised price. Our course has no extra costs

Dates, Locations & Prices
Logitrain Live Online Training Banner

LocationTypeDurationPriceDates
LocationTypeDurationPriceDates
OUR ACCREDITATIONS

Find out why we are the leading choice to help boost your career

Prepare to get IT job ready in 8 weeks

Trained 8000+ professionals and counting

Experienced Provider: Operating Since 2004

Trained staff from 1000+ Australian Businesses

We Have Placed Candidates In
SATISFIED CUSTOMERS
SOME OF OUR CLIENTS

Over 1000 organisations have relied on Logitrain to be their trusted training partner.

High-quality, cost-effective training since 2004
Learn More
  • This field is for validation purposes and should be left unchanged.

Dont’ Wait. Fill the form for a free no-obligation information session with our course specialists.

We are Open. Delivering Classroom and Live Instructor-led Training

Attend at our premises or from anywhere on any device.

1
Hi, how can we assist you?
Powered by