Students learn basic skills needed for working with Oracle database. The course covers SQL fundamentals to retrieve, insert, update or delete data in database and fundamentals of procedural PL/SQL. Students get familiar with Oracle [...]
  • OFUN
  • Duration 3 days
  • 30 ITK points
  • 10 terms
  • Praha (23 625 Kč)

    Brno (23 625 Kč)

    Bratislava (990 €)

Students learn basic skills needed for working with Oracle database. The course covers SQL fundamentals to retrieve, insert, update or delete data in database and fundamentals of procedural PL/SQL. Students get familiar with Oracle architecture and relational database concepts.

»
  • IT Project Managers
  • System Analytics
  • Developers
  • Administrators
  • Technical Support Staff

    What we teach you

    • Introduction to relation databases
    • Data modeling
    • Purpose and benefits of  ER Diagrams
    • Fundamentals of Oracle architecture
    • SQL fundamentals
    • PL/SQL fundamentals
    • Introduction to Object-oriented technology
    • Workshop

    Required skills

  • Familiarity with data processing concepts and techniques
  • Ability to use a graphical user interface (GUI)

    Course Outline

    Database management systems

  • What is database systems
  • Traditional database systems
  • Relational database systems

    Data modeling

  • Oracle software life cycle
  • Conceptual data models
  • Data storage in relational databases, data normalization

    Oracle architecture fundamentals

  • Why to understand the architecture
  • Logical, Physical and memory structures
  • Oracle 9i features
  • Oracle product family

    SQL fundamentals

  • What is SQL
  • SELECT statement
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Transaction Control Language (TCL)
  • Data Control Language (DCL)
  • Differences in SQL and SQL*Plus

    PL/SQL fundamentals

  • What is PL/SQL
  • PL/SQL basics
  • Control structures in PL/SQL

    Introduction to Object-oriented technology

  • OO basics
  • Object-Relations Database Management Systems

    Workshop

  • Workshop
  • Current offer
    Training location
    Course language

    The prices are without VAT.