Scribd Logo
Upload

Welcome to Scribd!

  • 388 views

    DFo 1 1 PDF

    Uploaded by

    Ichsan Mulya

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    DFo 1 1 PDF

    Uploaded by

    Ichsan Mulya
    388 views14 pages

    Original Title

    DFo_1_1.pdf

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    388 views14 pages

    DFo 1 1 PDF

    Uploaded by

    Ichsan Mulya

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 14
    At a glance
    Powered by AI
    The key takeaways are that the course will cover relational databases, data modeling, and using Oracle tools like SQL Developer and SQL Developer Data Modeler. It will also prepare students for an industry certification.

    The goals of the course are to describe the purpose of relational databases, describe key business requirements, develop entity relationship diagrams to model data, create physical models from logical models, write and execute SQL statements in Oracle Application Express.

    The main tools that will be used in the course are Oracle SQL Developer version 4, Oracle SQL Developer Data Modeler version 4, and access to the Oracle APEX application.

    Database Foundations

    1-1
    Introduction

    Copyright 2015, Oracle and/or its affiliates. All rights reserved.


    Roadmap
    Types of
    Introduction to Database
    About the You are here Databases Models
    Course

    Understanding
    Database Business
    Relational Storage Requirements
    Databases Structures

    DFo 1-1 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 3
    Introduction
    Objectives

    This lesson covers the following objectives:


    Identify the course goals and objectives
    Describe the course learning strategy
    Understand the course environment

    DFo 1-1 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 4
    Introduction
    Course Goals

    The goal of this course is for you to be able to:


    Describe the purpose of a relational database
    Describe key business requirements when
    developing a database
    Use data modeling to architect a
    relational database

    DFo 1-1 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 5
    Introduction
    Course Goals

    The goal of this course is for you to be able to:


    Develop an entity relationship diagram (ERD) to
    model data
    Use Oracle SQL Developer Data Modeler to build
    ERDs
    Map a physical model from an ERD

    DFo 1-1 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 6
    Introduction
    Course Goals

    The goal of this course is for you to be able to:


    Create a physical model from a logical model (ERD)
    Write, execute, and save SQL statements in Oracle
    Application Express

    DFo 1-1 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 7
    Introduction
    Course Outline

    DFo 1-1 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 8
    Introduction
    Course Strategy

    Instructor-led training
    Project-driven curriculum
    Industry-recognized certification

    DFo 1-1 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 9
    Introduction
    Technological Requirements

    Oracle SQL Developer (version 4)


    Oracle SQL Developer Data Modeler (version 4)
    Access to the Oracle APEX application

    DFo 1-1 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 10
    Introduction
    Links to Resources

    Oracle Database 12c


    https://docs.oracle.com/en/database/
    https://www.oracle.com/database/index.html

    DFo 1-1 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 11
    Introduction
    Links to Resources

    Oracle SQL Developer


    http://www.oracle.com/technetwork/developer-
    tools/sql-developer/index.html
    http://www.oracle.com/technetwork/developer-
    tools/sql-developer/learnmore/index.html
    Oracle SQL Developer Data Modeler
    http://www.oracle.com/technetwork
    /developer-tools/datamodeler/index.
    html

    DFo 1-1 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 12
    Introduction
    Summary

    In this lesson, you should have learned how to:


    Identify the course goals and objectives
    Understand the course environment
    Describe the course learning strategy

    DFo 1-1 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 13
    Introduction

    You might also like