Fundamentals of Database Systems

Topics Covered in This Course:
  In Section 1 of this course you will cover these topics:
    Database concepts: a relational approach.
    Database design: data modeling and normalization.
    Oracle 9i: an overview.
  In Section 2 of this course you will cover these topics:
    Oracle tables: data definition language -ddl-.
    Working with tables: data manipulation and retrieval.
  In Section 3 of this exam you will be evaluated on below listed topics:
    Working with tables: functions and grouping.
    Multiple tables: joins and set operators.
  In Section 4 of this course you will cover these topics:
    Subqueries: nested queries.
    Advanced features: objects, transactions, and data control.
  In Section 5 of this course you will cover these topics:
    Pl/sql: a programming language.
    More on pl/sql: control structures and embedded sql.
    Cursors and exceptions.
    Pl/sql composite data types: records, tables, and varrays.
    Pl/sql named blocks: procedure, function, package, and trigger.
    Connecting to oracle database: jdbc, sqlj.
    Oracle 9i architecture and administration.