Oracle Application Development

In this course, students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database. This course also discusses how to use the regular expression support in SQL.

In this course, students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database. This course also discusses how to use the regular expression support in SQL.

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions. Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions. Students are introduced to the utilization of some of the Oracle-supplied packages.

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions. Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions. Students are introduced to the utilization of some of the Oracle-supplied packages.

If you need to learn more about the design of relational database systems, this course is for you. You'll explore how the relational database approach is used in both open and closed systems and on both mainframe and client/server platforms, and learn about the design of systems of all sizes including standalone, workgroup, departmental, and enterprise-wide applications. You'll also learn how to incorporate data from legacy systems as well as how to develop entirely new systems. You'll have the opportunity to design a rational database model in class and refine it for a real-world system or case study. Topics include an overview of database systems, defining business entities, entity relationship modeling (ERM) for top-down analysis, defining relational database tables and attributes, conversion of logical design to physical design, normalization of tables, and using structured query language (SQL) to process data and generate reports.

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Topics in this course include: Oracle database architecture, Oracle Net services, database storage structures, backup and recovery, data and concurrency, undo data, performance and database diagnostic. The lesson topics are reinforced with structured hands-on practices.

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Topics in this course include: Oracle database architecture, Oracle Net services, database storage structures, backup and recovery, data and concurrency, undo data, performance and database diagnostic. The lesson topics are reinforced with structured hands-on practices.