Introduction to Oracle SQL

Learn the basics of using the SQL language on an Oracle database with these easy-to-follow lessons and examples.

Video Error

We tried several times to play your video but there was an unforeseen error. We have notified our engineers.

Visit https://helpx.adobe.com/flash-player.html to check that Flash is enabled on your browser.

With Flash enabled, please try again in a few minutes or contact support.

$20
Take This Course
  • Lectures 37
  • Video 4 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2013 English

Course Description

Learn how to use Oracle SQL AND get a Certification of Completion when you finish.

This course will teach you the basics of the SQL language on an Oracle database.

It uses video lectures, covering database topics such as:

  • Setting up your Oracle environment
  • Basic terminology
  • Reading data using a SELECT statement
  • What can be done using a SELECT statement
  • Functions
  • Data types
  • Joins, set operators, subqueries
  • Inserting, updating and deleting data
  • Creating tables

The course materials run for approximately 4 hours and are split into multiple sessions.

It's structured into various sessions and lectures, grouped by functional areas to make it easier to lean.

Why should you take this course?

You can go from absolute beginner to capable of writing SQL statements in a matter of hours, without paying thousands of dollars for training. You can also study in your own time!

What are the requirements?

  • Access to an Oracle database - a test database or somewhere you can install Oracle yourself

What am I going to get from this course?

  • In this course, you will learn how to write basic SQL statements to view data, insert data, update existing data and delete data in a database.

What is the target audience?

  • Those who have some knowledge about IT but minimal SQL knowledge
  • University or college students
  • Those who need to use a database at work, but don't know how

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction and Setup
02:08

An introduction to this course, who I am, and what will be covered.

07:38

Explains key concepts used in Oracle and this course, as well as what tools are needed for this course.

01:45

Demonstration of how to download the Oracle Client.

01:24

Demonstration of how to install the Oracle Client.

How To Install Oracle On A Mac
Article
01:10

Demonstration of how to download the Java Development Kit.

01:20

Demonstration of how to install the Java Development Kit.

02:46

Demonstration of how to download the Oracle SQL Developer software.

02:15

Demonstration of how to setup the Oracle SQL Developer software.

01:11

Demonstration of how to setup the connections inside the Oracle SQL Developer software.

Section 2: Viewing Data
02:52

Covers the basics of an SQL statement and how to run it on SQL Developer.

02:35

Demonstrates how to create a new user in SQL Developer.

03:26

Demonstrates how to create and populate the tables required for this course.

05:02

Includes how to run SELECT statements on the data in this database.

13:22

Explains the concepts of operators, as well as the DISTINCT and NULL keywords.

05:19

Covers some of the data types used in Oracle SQL.

13:16

Part one of how to restrict the data and sort it in a SELECT statement.

10:22

Part two of how to restrict the data and sort it in a SELECT statement.

Section 3: Functions
11:20

Explains some of the string functions in Oracle SQL.

06:11

Explains some of the number functions in Oracle SQL.

05:27

Covers how to work with dates and times in Oracle.

04:23

Explains some of the date functions in Oracle SQL.

03:42

Explains some of the conversion functions in Oracle SQL.

11:39

Covers the aggregate functions used in Oracle.

Section 4: More SELECT Concepts
16:42

Explains what table aliases are, as well as how to use joins.

08:42

Part two of using joins on tables in Oracle.

06:33

This session covers the concept of set operators and how to use them.

06:39

Covers three concepts inside Oracle - Translate, Decode and Case.

13:19

Explains the concept of a subquery, focusing on those that work with single rows.

17:12

Explains the concept of a subquery, focusing on those that work with multiple rows.

Section 5: DML - Data Manipulation Language
07:13

Introduces the INSERT statement for inserting data into a table.

06:05

Covers the UPDATE statement for updating data in a table.

04:25

Covers how to delete data from a table.

Section 6: Objects
15:46

Explains several of the object types used in Oracle.

20:26

Looks at how to create a table, as well as how constraints are used.

04:48

Covers how to alter and drop a table in Oracle.

Section 7: Conclusion
01:10

The course conclusion and next steps.

Instructor Biography

Ben Brumm, IT Software Consultant

I'm a software consultant that has a passion for databases, and teaching others. I have over seven years experience in the IT industry in many roles, including database support, database development, database design, reporting, business analysis, project management, and even Excel.

I obtained the Oracle SQL Expert certification and currently looking into the next certification on my list!

I'd like to teach others about databases and database topics, such as SQL, database design, and performance.

Ready to start learning?
Take This Course