Data Modeling – Logical Database Design

This course provides a foundational knowledge that can be used to implement relational databases, multidimensional data warehouses and business intelligence (BI) technologies. The principal objective of this initial course volume is to convey a practical and common-sense guide to the theory and concepts of data modeling. Using these sophisticated techniques, one can create an elegant and logical database design. Within this course we discuss not only the premier modeling theories from industry experts but also the practical and real-world experience from 20-years of Sideris data design practitioners.
The methodologies discussed are applicable to any relational database environment, including IBM DB2, the Oracle database, Microsoft SQL Server, the open-source MySQL and PostgreSQL databases as well as other RDBMS platforms. They are also applicable to multiple database technologies, such as object databases and legacy IMS and IDMS databases. Finally, while we use the free Oracle SQL Developer Data Modeler product as a demonstration modeling tool, one can complete the exercises of this course and apply the techniques learned using any other popular data model diagramming tool, such as IBM InfoSphere Data Architect, CA ErWin Data Modeler, Embarcadero ER/Studio and others.

Oracle APEX Version 4.2.5

This course provides a complete, hands-on introduction to Oracle APEX 4.2.5, a premier rapid application development tool. It allows developers to efficiently create complex web-based applications to run on any operating system environment, including smart phones. Interactive reports can be created and customized by:

  • Searching and sorting,
  • Creating control break reports,
  • Performing highlighting to focus on specific rows or values,
  • Adding custom computations including aggregations,
  • Charting and custom dashboards.

In this class, students will learn by building a fully functioning application from the ground up.

Oracle 12c Release 1 DBA I

This course provides a complete, hands-on introduction to Oracle Database Administration, including the use of Enterprise Manager Database Express (EMDE), SQL Developer and SQL*Plus.

Oracle 12c Release 1 SQL

This course provides a complete, hands-on introduction to SQL, including the use of both SQL Developer and SQL*Plus. This coverage is appropriate for both users of Oracle12c and Oracle11g. A full presentation of the basics of relational databases and their use are also provided.