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.