Relational Database Design

This course helps participants learn an effective approach to developing a relational database. Topics in this course are: defining user requirements, developing an entity-relationship (ER) diagram and mapping your logical database model to a physical database design. Exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience. A hands-on modeling workshop is facilitated on the third day, providing participants the opportunity to model a real-world database application.

Using SQL Developer UT Features

In this course, you’ll learn how to test PL/SQL code using the Oracle SQL developer unit testing framework. It is a robust and feature rich framework which allows you to easily create test cases for your PL/SQL program units, organize them in test suites, reuse your work with libraries and share your tests in a team development environment.
First, you’ll discover that it allows you to analyze your code coverage and view previous runs and results with several built-in reports. Next, you’ll explore how it lets you synchronize your tests when the name or definition of the underlying program units change. Finally, you’ll learn how it gives you the ability to automate your tests using the SQL Developer command line interface, which is extremely useful in implementing your continuous testing strategy. When you’re finished with this course, you’ll have a foundational understanding of Oracle SQL Developer PL/SQL Unit Testing feature, which will help you immensely when implementing extensive test cases for your PL/SQL program units and achieving test automation.

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.