Learn how to use the Oracle database management system to plan, organize, and manage your data. This course will introduce you to the Structured Query Language (SQL), Oracle’s SQL*Plus, and other valuable tools used to develop, manage, and reference an Oracle database. You will learn how to create an Oracle database, build various database objects for the database, and write simple SQL statements that access the data from the database.

Learning Objectives:

• Comprehend terms and concepts surrounding a relational database.
• Learn how to create a database and table basics.
• Learn how to define and manage constraints.
• Learn how to write basic SQL statements.
• Understand SQL*Plus basics and learn how to create reports.
• Learn how to create other database objects and use the data dictionary.

View full course syllabus

For our online course refund policy, click here.

Requirements: Internet access, e-mail, Firefox or Internet Explorer web browser, and any type of computer with an installed copy of Oracle’s Database Software (versions 8, 9, 10 or 11 are acceptable). The Database software is available for downloading from Oracle’s website (www.oracle.com). Download the Oracle Database 10g Release 2 Standard Edition, Standard Edition One, and Enterprise Edition that supports your operating system. This course provides post-installation instruction on Oracle. Installation support will not be provided in the course. Installation support is provided from Oracle’s website. Please be sure to install required software on your computer before the course begins.

You will need to create a login for your online classroom. Go to www.ed2go.com/ksuconed. Find your course by browsing the catalog or using the search bar. Click the ‘Add to Cart’ button (this site does not accept payments – you will not be charged here). Select your start date and then create a Username and Password. You must make an 80 or higher on the final exam (online) to successfully complete the course. You may only take the exam once.

If you have questions about this course, please contact the online coordinator at 470-578-6693 or online@kennesaw.edu.