PoÄŤĂ­taÄŤová škola GOPAS  

Gopas CZ 
Gopas SK 
   
     Site map · Advanced search 
Offer of courses » Databases » Additional Database Courses » Úvod do databází a jazyka SQL v prostředí Oracle


   print

OFUN - Úvod do databází a jazyka SQL v prostředí Oracle

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.

Who the course is for

  • 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)

    Teaching methods

    Expert instruction with practical examples, computer practice

    Teaching materials

    The student materials include comprehensive courseware and other necessary materials for this class. All reading materials are in English.

    Course syllabus

    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

    Recommended subsequent courses

    11g_DBAI - Oracle Database 11g: Administration Workshop I
    SQL10g - Oracle 10g: SQL Language
    PLSF10g - ORACLE 10g: PL/SQL Fundamentals
    PLSP10g - ORACLE 10g: Creating Program Units Using PL/SQL
    10g_DBAI - Oracle Database 10g: Administration Workshop I
    SQL9i - Introduction to Oracle 9i: SQL

    Catalog price of course and handbook

    Locality Course price ex VAT Price of handbook ex VAT Number IT points
     Praha   20400 Kč  --   30 items
     Brno   20400 Kč  --   30 items

    Course dates

    Course date Course length Locality Price ex VAT Handbook ex VAT  Speaker language  
     01.11.2010   3   GOPAS Praha   20400 Kč included in course price Course Guaranteed course date
     07.02.2011   3   GOPAS Praha   20400 Kč included in course price Course Guaranteed course date
     25.10.2010   3   GOPAS Bratislava   678 EUR included in course price Course
     03.01.2011   3   GOPAS Bratislava   678 EUR included in course price Course
     07.03.2011   3   GOPAS Bratislava   678 EUR included in course price Course

    If none of the offered dates suits you, please contact our customer service department on tel. +420 234 064 900-3 (Prague), +420 542 219 935-6 (Brno).