and Programming with SQL
This Oracle designed
curriculum is geared to meet the learning needs of a variety of students, from those interested in gaining broad exposure
to business and technical skills to students planning on pursuing a technical education or career. This course utilizes an
Oracle hosted, state-of-the-art lab environment to build database design and programming skills. Students analyze case studies
to identify data patterns and connections in order to design relational databases. ERD conventions and standards are used
to graphically depict the databases designed. Students develop technical skills in SQL and are exposed to business and professional
skills including teamwork, project management, and technical presentations that are used in a variety of industries and job
roles. Advanced students have the opportunity to sit for the Oracle Certified Associate (OCA) Certification Exam #1
(1Z0-007: Introduction to Oracle9i: SQL).
Database Programming with PL/SQL
This course covers PL/SQL, a procedural language extension to SQL. Through
an innovative project-based approach, students learn procedural logic constructs such as variables, constants, conditional
statements, and iterative controls. The course blends virtual and face-to-face training, hands-on exercises, assessments,
and project based learning experiences while leveraging the latest Oracle technologies. Students utilize an Oracle hosted,
state-of-the-art lab environment to build database programming skills using PL/SQL and Oracle Application Express. Advanced
students have the opportunity to complete the Oracle Certified Associate (OCA) Certification by taking the second of two required
exams (1Z0-147: Program with PL/SQL).
Java Fundamentals and Programming
This is a new course to be offered for the
first time in 2013-2014. This Oracle designed curriculum introduces fundamental programming concepts and terminology in an
engaging manner through the creation of simple animations and interactive games using Object Oriented Programming environments.
While mastering basic programming constructs using OPP, students will learn basic Java syntax. Using a popular, industry recognized
Java IDE and the Java programming language, students will write, edit, compile, deploy, and debug Java programs. Java classes,
arrays, stacks, strings, and the core APIs that are used to design object-oriented applications will be covered. The GridWorld
case study is closely examined and used to enhance student knowledge of core Java concepts. The AP Java subset is also addressed.
As in other Oracle courses, collaboration and problem solving are emphasized throughout the course.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.