Oracle Fundamentals

Quick Facts

Delivery Method Online
Professional Certificate
24hrs Suggested Study Time
3 Months Access
Tutor Support
Study On Any Device
5785 Students

Learn how to use the Oracle database management system to plan, organise, and manage your data.

Learn how to use the Oracle database management system to plan, organise, 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 self-paced 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.

Courses are delivered to you through expertly executed lessons, online instruction and interaction with like-minded students. Our courses are designed to deliver all of the benefits of studying in a classroom whilst giving you the flexibility to study at a time and place to suit your needs. You can access your classroom 24/7 from any device with an internet connection.

This course has a 3 month duration. You'll complete comprehensive lessons, quizzes and assignments before submitting your final exam at the end of the course to achieve your certificate. Courses must be completed within the 3 month access period.

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 we'll talk specifically about the Structured Query Language (SQL) and the database tools you'll use throughout the course.

Today you'll jump right into the course by creating the actual database you'll use in all the lessons that follow. You'll learn about the most common object in Oracle: the table. Then, I'll explain addresses the common datatypes that describe the kind of information a column in a table will store.

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. We'll also discuss managing tables and how to modify their structure by altering and deleting information.

Today, we'll put together all the pieces of the database puzzle. We'll discuss defining and managing table constraints, then you'll learn about the five integrity constraints that Oracle supports, as well as what their purposes are. I'll show you how to define integrity constraints during table creation with the CREATE TABLE statement and after a table have been created with the ALTER TABLE statement. With this information, you'll create the primary and foreign keys for your database's tables.

You'll gain considerably more knowledge about the Structured Query Language in this lesson, where you'll be introduced to two new commands—the INSERT and SELECT commands. Then, you'll execute the commands to insert rows of data into the tables and query the data you inserted.

Today you'll gain experience with additional SQL*Plus know-how. You'll learn how to correct errors and manipulate lines in the SQL buffer. Then you'll understand additional syntax of the SELECT statement.

In this lesson, you're going to learn more about the SELECT command, the most commonly used SQL statement. The SELECT command allows you to query the data in a database. You'll find that you need to be familiar with the data in your database, and that queries provide you with means to view what's stored in your tables.

Today, you'll go beyond the INSERT command's basics. I'll introduce you to more advanced features of the INSERT command, then you'll learn the different methods of inserting rows of data and apply those skills to load data into your tables. You'll also learn some troubleshooting techniques to perform when Oracle returns an error message during an INSERT command.

In today's lesson, you're going to learn how to modify data in the database's tables using the UPDATE command. You'll learn how to manipulate the data in your tables by updating the values in the columns and by deleting rows of data. You'll learn how to make those changes permanent with the COMMIT command, as well as how to undo a change with the ROLLBACK command.

Up to this point in the course, you've been creating queries based on a single table. Today, 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.

Today, you're going to learn more about common database objects and their uses. At this point, you'll have gained considerable knowledge of the most common database object—the table. 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.

In our final lesson, you're going to learn how to format query results to generate a finished report. You'll use SQL*Plus to create reports by using SELECT statements. Then you'll modify the display of the query results to create a polished report.

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 specialises in database management syst... Read more

Read Cindy Delia's Profile

Frequently Asked Questions

Once you've made the payment, we'll send you a confirmation email with a link to start your course. Feel free to get started whenever you're ready!

You'll have 3 months access to your course. In that time you are free to study at your own pace. The course duration is 24 hours.

Online learning is a flexible way to study that fits around your schedule, giving you the freedom to learn at your own pace from anywhere in the world. You'll have 3 months to complete the course and can take the multiple-choice questions and final exam whenever it suits you.

If you need help, you can contact us anytime. You can also join the discussion area where you can interact with other students. The discussion area for each lesson is open for the entire duration of the course.

Of course! We offer a 7-day money back guarantee. As long as you haven't completed the course, you can get a full refund within 7 days of enrolling.

We do not offer extensions or transfers for this self-paced course. However, you will have 3 months to complete the course, and if you need to cancel within the first 10 days of enrolment, we offer a money back guarantee.

What people are saying about our courses

Great introduction course. And C. Delia's method and style was great as well. It was just what I was looking for.

Verified Student

I enjoyed the course although I was not able to dedicate as much time to the lessons as I would have liked to. I downloaded/printed the lessons and will use them in the future to continue to enhance my Oracle skills. We are using PL/SQL at work to write reports and create portals for our customers.

Verified Student

I found this course to provide just the right increments of learning a totally new (to me) subject. The examples, writing style and exercises were just plain perfect! Thank YOU!

Verified Student

See More Reviews

The Learning Environment

From the moment that you enrol in the Oracle Fundamentals you will become an integral part of our learning community. You'll find yourself with the freedom to learn at a speed that suits you, on any device, from anywhere in the world. Achieving your career goals no longer has to mean compromising family and work commitments.

Our Values

Learn At Your Own Pace

We believe in personalised learning. That's why we provide all the tools and support you need to succeed at your own pace. With flexible learning, you'll stay motivated and retain more information. Plus, you can balance your studies with work and family commitments to make your dreams a reality.

We Won't Break The Bank

Education should be accessible to anyone who wants to learn. That's why we offer some of the most competitive prices in the industry with payments plans for just $25 per week. Investing in your future is a smart choice and doesn’t have to break the bank.

Industry-Led Courses

There's no better way to learn than from experts with years of experience in your field. That's why each of our 200+ industry-led courses are designed to give you a real-life perspective on your industry. With our expert mentors, you'll learn from people who have a wealth of knowledge and experience, and who are passionate about sharing it with you.

Get The Personal Support You Deserve

At Vibe Learning, we're real people who are dedicated to providing you with personal support every step of the way. Our industry experts are not only professional and knowledgeable but also incredibly passionate about sharing their expertise with you. With their guidance, you'll gain invaluable insights and practical knowledge to help you succeed.

Still looking?

Check out the following courses related to Oracle Fundamentals:

Crystal Reports Fundamentals

Database Development Fundamentals

Oracle Intermediate

SQL Fundamentals

SQL Intermediate

Discover more online courses

Oracle Fundamentals

$599

$389AUD

Save 35%

Make Money from your Writing

Now Only

$389

AUD

35% off

$599 AUD

Quick Facts

Delivery Method Online
Professional Certificate
24hrs Suggested Study Time
3 Months Access
Tutor Support
Study On Any Device
2751 Students

You really can make money with your writing. Whether you want to create your own business, add to your income, supplement your retirement, or boost what you're earning as a writer, you'll find the how-to's here.

You really can make money with your writing. Whether you want to create your own business, add to your income, supplement your retirement, or boost what you're earning as a writer, you'll find the how-to's here.

In this course, I'll share secrets, methods, and tips to help you generate income with your writing. This class includes all the practical information that so rarely gets taught in writing classes.

Now I know in most courses and social groups it's taboo to discuss money . . . but not here. We'll embrace it! Making money is the focus of the lessons.

You'll explore a dozen genres that can help you establish a sometime, part-time, or full-time career as a writer. Along the way, you'll learn methods to work faster, suffer less rejection, and bring home more bacon (even if you're a vegan like me).

You'll get facts on ghostwriting, collaboration, writing for the Web, writing for new technologies, copywriting, article and essay writing, and novel and nonfiction book writing, plus I'll give tips for finding publishers and agents. And you're going to practice different writing techniques in a safe environment as I mentor you.

Please join me for this course. Fulfilling (and lucrative) writing work is waiting for you!

Where do great ideas come from? How do best-selling authors get to be that way? What makes writing so very scary, intimidating, delicious, and wickedly wonderful? How are words pulled from nothingness and zapped to the screen or printed page? What makes writing nearly addictive to one group of humanity and yet an overwhelming task for others? Are there born writers? Can anyone learn to write? Why do some people get published and others fail? Today, we'll start answering these questions and begin the journey to becoming a better writer.

Have you ever heard that to be a writer, you only need a pen and paper? That's true. Yet, too many writers throw in other requirements—from a year of unfettered time, to a trust fund that will keep them in caviar until the royalties come flooding in. In this lesson, we'll delve more deeply into the writing life as we expose some myths about writing.

Today we'll discuss self-editing and researching. Self-editing and researching are both skills you'll want to learn so you can sell your work. It's highly unlikely you'll ever sell a first draft, and it's equally as unlikely that you'll sell something you didn't research. So join me in this lesson, and I'll teach you some simple tricks to make your work shine!

Today's lesson could be called Magazine Writing 101. If you've written for magazines before, then today's lesson will be a refresher or a nudge. If you haven't written for magazines and would like to, today you'll find out indispensable information that will get you going. With this info, you could find your niche and begin making money as a freelancer, possibly while you're working on your novel.

In the previous lesson, we focused on writing nonfiction articles for popular magazines. But you won't find every magazine that uses freelance work in your grocery store or big super bookstore. There are magazines, publications, and periodicals with otherwise large distribution that never even get to these places. And these magazines are looking for short works such as short stories, columns, essays, and poetry. Today we'll talk about how you can sell your short works to magazines and newspapers.

Some writers just love to write long fiction and have a story that is burning to get out. If you fit into this group, or just wonder how one goes about writing a novel, then this lesson should speak to you. You'll find out why some of us need to get that book out and what it takes to do so. By the end of this lesson, you'll have a working knowledge of the genre possibilities and what it takes to write a novel. You'll learn how stories are found, how some famous novelists were discovered, how to stay motivated, and what has stopped a few hopeful writers from writing.

Now it's time to give the nonfiction genres a turn. Adults are infatuated with nonfiction and it sells better than any other type of book. There are scads of different genres in nonfiction books. In this lesson, we're going to focus on the types of nonfiction writing and how to get a project started, written, and noticed by publishers and agents. Nonfiction books concern real people, places, events, information, or situations. Whether you're addicted to reading nonfiction, or just want to learn all you can about writing, this lesson will give you valuable information that will help you better understand the world of publishing.

What does it mean to be a ghost in the literary world? This lesson will give you the scoop on this lucrative business. If you have a talent for emulating peoples' voices, and if you're fast, efficient, and good with people, this might be the field for you. Today we'll talk about how to advertise and find clients, how to select appropriate clients, and how to maintain a good working relationship so you can produce the best book possible.

Today, we're going to talk about the roles of editors and agents. Specifically, you'll find out what each of their jobs includes and why you need to know this information. If you're currently writing a novel or a nonfiction book, gathering a collection of poetry or short stories, or maybe just dabbling in the idea, you'll want to read this lesson carefully. Find out how agents interact with editors at publishing houses and how you can interact with agents and editors.

Attend any writing conference or sit with a group of published writers, and you're bound to hear words like: self-publishing, POD, copublishing and e-publishing. In this lesson, we'll discuss the options that are often called alternative publishing. If you're serious about joining the world as a writer, you should be aware of these options. They're not for everyone, but the information I'll give you today will help you make sound career and financial decisions.

This lesson is all about the legal side of writing. Today, you'll see sample agreements and contracts that should keep you in good stead as you become the writer of your dreams. We'll also talk about royalties, advances, and the scoop on that lovely green stuff that pays the bills.

Saturday comes, finally. The house looks like a disaster hit. The kids need shoes, the dog has a vet's appointment, and you swear that the health department might condemn the car. Unlike Dorothy in The Wizard of Oz, you can't seem to click your heels hard enough to make it all disappear. You've got a yearning, a deep burning to write, but the clutter, the mess, the hours spent doing things for others (okay, and procrastination) are eating at your heart. What does all of this have to do with creativity? Check the clock, because it's all about time management, and that's what you'll learn in this vital lesson.

Eva Shaw

Eva Shaw, Ph.D. is a full-time working writer of 1000 articles, essays and short stories. She’s the ghost or author of 70 books including: Ghostwriting for Fun & Profit, Writeriffic: Creativity Training for Writers, Write Your Book in 20 Minutes ... Read more

Read Eva Shaw's Profile

Frequently Asked Questions

Once you've made the payment, we'll send you a confirmation email with a link to start your course. Feel free to get started whenever you're ready!

You'll have 3 months access to your course. In that time you are free to study at your own pace. The course duration is 24 hours.

Of course! We offer a 7-day money back guarantee. As long as you haven't completed the course, you can get a full refund within 7 days of enrolling.

What people are saying about our courses

I was in your magazine writing course last year. I actually used the magazine article query letter I wrote for a class assignment, and I sold the story. It is on the children's musical composition project called "Hey, Mozart!" and will be in the Aug/Sept issue of American Music Teacher (AMT) magazine. Yippee!

Verified Student

Eva has found the right mix of lessons for an Advanced Writing class. Her commitment to teaching is, as aways, very strong. She comments constructively on all submitted work, and encourages useful and positive feedback from fellow students. She creates a wonderful, positive class, that was very inspiring. Very well done!

Verified Student

Eva, I truly appreciate all your help, encouragement and patience. I can honestly say had it not been for you and this amazing class, I wouldn't be writing.

Verified Student

See More Reviews

The Learning Environment

From the moment that you enrol in the Make Money from your Writing you will become an integral part of our learning community. You'll find yourself with the freedom to learn at a speed that suits you, on any device, from anywhere in the world. Achieving your career goals no longer has to mean compromising family and work commitments.

Ready to get started?

Enrol Now