Oracle SQL – A Complete Introduction

Oracle SQL – A Complete Introduction

Learn the basics of Oracle SQL with these easy-to-follow Oracle SQL lessons and examples.

What you’ll learn

  • 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.
Requirements
  • Nothing – this is a beginner’s course

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

This lesson demonstrates how to create a new user. This is done for security reasons as we don’t want to use the SYS or SYSTEM accounts.

An explanation of the sample database we will be using.

A demonstration of how to set up the database for this course.

This lecture demonstrates how to use the SELECT statement to view data.

Expansion of the SELECT statement to select individual columns.

How to restrict the rows you are shown using the WHERE clause.

How to use different comparison operators in your queries.

Using the LIKE operator to filter on partial matches for words.

How to filter your results on date values.

How to use two filters in your queries in the WHERE clause.

Using three or more filters in WHERE clauses.

What is a NULL value and how is it treated in Oracle?

Using the DISTINCT keyword to find unique records in our queries.

A quiz to cover topics learnt on the SELECT query.

A quiz on using operators.

Description

Learn how to use Oracle SQL from scratch, to improve your developer skills or to access an Oracle SQL database at work.

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

It uses video lectures to teach you Oracle SQL, 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 learn.

Why should you take this course?

There are many benefits of taking my Oracle SQL course:

  • You can go from absolute beginner to capable of writing Oracle SQL statements in a matter of hours
  • Avoid paying thousands of dollars for training.
  • You can also study in your own time!
  • Learn from someone who actually has Oracle SQL experience (and runs a website teaching others how to use and optimise their Oracle SQL)!

If you want to learn Oracle SQL from someone who has experience, then take this course.

Who this course is for:
  • 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

Redeem Coupon

Tags:

We will be happy to hear your thoughts

Leave a reply

iLearnE