Introduction to Oracle (Self-Paced Tutorial)

Learn how to use the Oracle database management system to plan, organize, and manage your data. Introduction to Oracle will provide you with a practical hands-on approach to relational databases concepts and Oracle’s database management system. 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.

In this online course, 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. This course will teach you how to write Data Definition Language statements to create, update, and delete database objects. You will learn how to execute Data Control Language statements to give or delete access rights to database objects. You will write Data Manipulation Language statements to insert, update, and delete records from a database. Finally, you will learn how to query the data and create finished reports.

Hardware Requirements:

• This course can be taken on either a PC or Mac.

Software Requirements:

• PC: Windows 8 or newer.
• Mac: OS X Snow Leopard 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• Oracle’s Database Software 12c. The Database Software is available for download from Oracle’s website. Click here to download the Oracle Database 12c 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.
• Adobe Acrobat Reader. Click here to download the Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

There are no prerequisites to take this course.

Course Hours: 24.00