Courses Courses Arts and Design Arts and Design Animation Graphic Arts Photography Web Design Other Business Business Accounting Administrative Communication Finance Marketing and Sales Operations Project Management Small Business Soft Skills Career Online High School Career Online High School Online High School Diploma Computer Applications Computer Applications AutoCAD Microsoft QuickBooks Windows Other Computer Programming Computer Programming Programming Classes Construction and Trades Construction and Trades Construction Environmental and Energy Trades Health and Fitness Health and Fitness Alternative Medicine Dental Fitness Medical Veterinary Wellness Hospitality Hospitality Hospitality Service Information Technology Information Technology Cloud Computing Networking Other Security Language Language Languages Legal Legal Legal Studies Math and Science Math and Science Mathematics and Science Teacher Professional Development Teacher Professional Development Child Development Classroom Technology Math and Science Reading and Writing Other Test Prep Test Prep Exam Prep Writing Writing Writing and Editing How It Works How It Works About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
Courses
Arts and Design
Animation
Graphic Arts
Photography
Web Design
Other
Business
Accounting
Administrative
Communication
Finance
Marketing and Sales
Operations
Project Management
Small Business
Soft Skills
Career Online High School
Online High School Diploma
Computer Applications
AutoCAD
Microsoft
QuickBooks
Windows
Other
Computer Programming
Programming Classes
Construction and Trades
Construction
Environmental and Energy
Trades
Health and Fitness
Alternative Medicine
Dental
Fitness
Medical
Veterinary
Wellness
Hospitality
Hospitality Service
Information Technology
Cloud Computing
Networking
Other
Security
Language
Languages
Legal
Legal Studies
Math and Science
Mathematics and Science
Teacher Professional Development
Child Development
Classroom Technology
Math and Science
Reading and Writing
Other
Test Prep
Exam Prep
Writing
Writing and Editing
How It Works
About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
ed2go Information Technology Other Introduction to Oracle
Return to Other
oracle-courses

Introduction to Oracle

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 six-week 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.

6 Weeks / 24 Course Hrs
Starting October 18, 2017

Offered in Partnership with your Preferred School

Kent State University Ashtabula Why this school? It's been chosen based on your location or if you've visited this school's website.

Change School

Learning Method

Instructor-led Confirm your Start Date in Cart

Introduction to Oracle

Learning Method

Instructor-led Confirm your Start Date in Cart

Introduction to Oracle Reviews

Introduction to Oracle Details + Objective

Course Code: ioc

You Will Learn
  • Learn to plan, organize and manage data with Oracle
  • Learn how to create an Oracle database
  • Discover how to build various database objects for the database
  • Understand how to write simple SQL statements that access the data from the database
  • Learn how to write Data Definition Language statements to create, update, and delete database objects
  • Learn how to execute Data Control Language statements to give or delete access rights to database objects
  • Discover how to query the data and create finished reports
How the course is taught
  • Instructor-led course
  • 6 weeks in duration
  • Courses begin each month
  • 2 lessons released each week
  • 24 course hours
How you will benefit
  • Gain confidence in your ability to use the Oracle database management system to plan, organize, and manage your data
  • Open the door to new opportunities with skills that can transfer to any data-driven organization
Introduction to Oracle Outline
Expand All
Week 1

In this lesson, you'll gain a solid understanding of terms and concepts surrounding a relational database. You'll learn what's involved in the planning of a database and the steps involved in designing a database. Then, jump right in and create an actual database that you will use to practice the rest of the lessons in this course.

Week 2

In this lesson, you'll learn about database users and you'll even have an opportunity to create a user of your very own. This lesson will not only provide you with a crash course in SQL*Plus, but it will also help you create all the tables you'll need for your database. Then, you'll learn about the five integrity constraints that Oracle supports, as well as what their purposes are.

Week 3

Execute the INSERT and SELECT commands to insert rows of data into the tables and query the data you inserted. Then, you'll gain experience with additional SQL*Plus know-how as you learn how to correct errors and manipulate lines in the SQL buffer.

Week 4

In this lesson, you're going to learn more about the SELECT command, the most commonly used SQL statement, which allows you to query the data in a database. Then, learn more advanced features of the INSERT command and the different methods of inserting rows of data and apply those skills to load data into your tables.

Week 5

Learn how to modify data in the database's tables using the UPDATE command. Then, you're going to learn how to display data from multiple tables. You'll learn how to utilize your working knowledge of the SELECT statement and explore the world of joins.

Week 6

In this lesson, you'll learn about other database objects and learn how to put them to use, too. Then you'll make use of the data dictionary and query some useful views. Finally, you're going to learn how to format query results to generate a finished report.

View All Sections
Introduction to Oracle Instructors
Cindy Delia

Cindy Delia is a Systems Analyst and a certified instructor. She has been working in information technology for more than 18 years and has been a technical trainer for over 6 years. As a Systems Analyst, she specializes in database management systems and develops PC applications. She has taught computer courses at the community college level and also performs corporate training. Cindy has also written technical manuals for WordPerfect.

Introduction to Oracle Requirements / Prerequisites

There are no prerequisites for this course.

You'll need any type of computer with an installed copy of Oracle's Database Software. The Database Software is available for downloading from Oracle's website (www.oracle.com). Download the Oracle Database 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.

Introduction to Oracle Frequently Asked Questions
Expand All
When can I get started?

A new session of each course opens each month, allowing you to enroll whenever your busy schedule permits!

How does it work?

Once a session starts, two lessons will be released each week, for the six-week duration of your course. You will have access to all previously released lessons until the course ends.

How long do I have to complete each lesson?

Keep in mind that the interactive discussion area for each lesson automatically closes 2 weeks after each lesson is released, so you’re encouraged to complete each lesson within two weeks of its release.

What if I need an extension?

The Final Exam will be released on the same day as the last lesson. Once the Final Exam has been released, you will have 2 weeks plus 10 days to complete the Final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.

Browse All