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:
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:
If you want to learn Oracle SQL from someone who has experience, then take this course.
This lecture demonstrates how to download and install the Oracle Express database.
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.
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.