CAAP 4601: Oracle 10g: SQL

Description

Databases are electronic filing systems capable of holding and processing large amounts of information. Oracle databases are among the most capable and highly regarded, and serve critical functions in organizations of all sizes around the world. In addition, individuals who possess Oracle Database Administration (DBA) and Oracle application development skills are some of the most sought after on the market.

This course will focus on providing a foundation to work with Oracle databases. Students will learn the basics of relational databases, Oracle's Structured Query Language (SQL), database design, and documentation. This course is hands-on with significant time spent working directly with Oracle software. Upon successful completion of this course, students will have satisfied the prerequisites for the Oracle PL/SQL programming course.

Students access recorded, multi-media formatted video sessions of each class lecture. These versatile, multi-media classes show the instructor, any program that is displayed on the instructor’s computer, the instructor’s notes and real-time digital markups, and sound all together in a single presentation!

Students can access the class sessions by streaming on the Internet as often as they like and have the ability to pause, rewind and forward to key sections of interest.

The instructor will be constantly monitoring the class portal and available to answer questions, provide feedback, and other guidance via the portal, community message board, internet chat, and internal class email system.

The instructor will post video lectures on a weekly basis for the students to view and perform lab and homework activities. The instructor will host live office hours each week via conference call, chat, and/or video conference.

Registration is on an open, rolling basis; register when you want up to two weeks before the end date. The course requirements must be completed by the end date.

Topics Covered:

Intro to Relational Databases
Normalization, Primary & Foreign Keys
SQL - DML (Data Manipulation Language)
Joins
Number, Text, and Date Manipulation
Advanced queries
SQL - DDL (Data Definition Language)
Designing Custom Tables & Data

View Sample Lecture

Benefits

The University of Colorado at Boulder has partnered with Oracle Corporation to bring you the very best in training and development. This unique partnership combines the exemplary education program of the University of Colorado with the hands-on expertise of Oracle Corporation. Some of the benefits of taking an Oracle course with our program include:

Students will learn material that help prepare them for the Oracle certification exam
Students receive exclusive supplementary Oracle University training workbooks
Students receive a 50% discount on selected Oracle certification exam practice test software
Students receive a 25% discount on Oracle certification exams
Free membership to the Oracle Technology Network: The definitive source for Oracle technical information when developing for the Internet. An online community with access to free software, OTN-sponsored Internet developer conferences, and discussion group

As an Oracle certified education partner, the University of Colorado is able to offer these exclusive benefits to students at a very reasonable price.

Prerequisites

Students do not need to have prior exposure to Oracle or databases, but any prior experience is helpful. However, students should be very comfortable with basic PC operations and usage of general software and the Internet (e.g. Windows, Microsoft Office, web browsers, etc.).

Education Officer (EO)

Not Required

Hardware & Software

CU is providing web-based access to an Oracle database. On this database, students will have access to all required data for the course and be able to perform all Oracle SQL coding activities. Students will need a PC with Internet access (preferably broadband). Minimum system requirements: Pentium III with 256MB of RAM.

To view the lectures online, you will need one of the following:

At least Internet Explorer 7, or
FireFox 2, or
Google Reader at http://google.com/reader

Interact

Courses