Oracle Academy: Database Foundations (Online) 2020-2021

BeginnersOnlineNew

If you have no or little database experience and want to learn database design techniques using a modelling tool and to begin programming using SQL to implement and query databases using hands-on, engaging activities, this 90 hour course is for you. This course should be taken before Database Design and Database Programming with SQL .

The course teaches you relational database terminology, as well as data modelling concepts, building Entity Relationship Diagrams (ERDs), and mapping ERDs. Oracle SQL Developer Data Modeller is utilised to build ERDs and Structured Query Language (SQL) is used to interact with a relational database and manipulate date within the database. Leveraging project-based learning techniques, you will create and work with projects which challenge you to design, implement, and demonstrate a database solution for a business or organisation.

Exam Information

Through Oracle's Certification paths, you demonstrate a professional level of technical skills recognised throughout the information technology industry, this gives you a competitive edge in your career.

Completion of Database Design and Programming with SQL course prepares you close to being ready to sit the optional external exam Oracle Database Foundations | 1Z0-006. Read more about this exam.

• All current Cambridge University members (departments and colleges)
• Further details regarding eligibility criteria are available

• Ease with using a computer
• General knowledge of databases

• Introduction
  • Introduction to the Course
  • Introduction to Databases
  • Types of Database Models
  • Business Requirements
• Databases and Data Modeling
  • Relational Databases
  • Conceptual and Physical Data Models
  • Entities and Attributes
  • Unique Identifiers
  • Relationships
  • Entity Relationship Modeling (ERDs)

• Refining the Data Model
  • More with Relationships
  • Tracking Data Changes
  • Normalization and Business Rules
  • Data Modeling Terminology and Mapping
• Oracle SQL Developer Data Modeler
  • Oracle SQL Developer Data Modeler
  • Convert a Logical Model to a Relational Model
• Mapping to the Physical Model
  • Mapping Entities and Attributes
  • Mapping Primary and Foreign Keys
• Introduction to SQL
  • Introduction to Oracle Application Express
  • Structured Query Language (SQL)
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Transaction Control Language (TCL)
  • Retrieving Data Using SELECT
  • Restricting Data Using WHERE
  • Sorting Data Using ORDER BY
  • joining Tables Using JOIN

What is needed to access Oracle iLearning:

A browser, either:

• IE | Edge | Chrome | FireFox | Safari
• Cookies must be enabled
• Pop-ups must be allowed
• Adobe Acrobat Reader

This course is approximately 90 hours on a self study basis, however the course should be completed within one year of enrolment.

On-going

• Oracle Academy: Database Design and Programming with SQL (Online)
• Oracle Academy: Database Programming with PL/SQL (Online) 2021-2022
• Oracle Academy: Application Express – Application Development Foundations (Online) 2021-2022