Oracle SQL: An Introduction to the most popular database

A quick tour of the six principal clauses of the SELECT statement.
Rating: 4.5 out of 5 (173 ratings)
8,798 students
Oracle SQL: An Introduction to the most popular database
Rating: 4.5 out of 5 (173 ratings)
8,800 students
Either Download and Install Oracle Express Edition and Oracle SQL Developer on your computer - for free
Write your own SELECT statements.
Learn the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses.
Get an easy way to remember the order of these clauses.
Find out what more you need to know, and resources in how to learn it.

Requirements

  • No knowledge of Oracle SQL at all is needed.
  • You need to know how to use a computer, including installing programs.
  • This is a free course - you have nothing to lose!
  • Why not have a look at the curriculum below and see what you can learn? If you already know this information, then please see my other courses.
Description

This course is a brief presentation of Oracle SQL.

We will install a version of Oracle Express Edition and Oracle SQL Developer for free.

We'll then look at the SELECT statement with its 6 main clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY).

Following this, we'll look at what else you need to know, and resources (which range from FREE to very expensive) which will help you to learn it..

No prior knowledge is required - just a willingness to learn.

See you on the course.

Who this course is for:
  • This beginner's course is for you if you want to learn about Oracle SQL and the six principal clauses of the SELECT statement.
  • If you have already heard about Oracle SQL, and wish to learn more about SQL code, then please have a look at my courses.
Course content
6 sections • 22 lectures • 1h 30m total length
  • Introduction
    01:39
  • Welcome to Udemy
    00:35
  • Download Oracle Express Edition
    08:20
  • Install Oracle Express Edition
    04:02
  • Download and Install Oracle SQL Developer
    04:14
  • Connect to Database
    04:14
  • Solving the "The network adaptor cannot establish the connection" error
    02:37
  • The SELECT and FROM clauses
    08:59
  • Renaming fields
    06:30
  • Using the AS keyword
    02:18
  • Semicolons and comments
    04:55
  • The WHERE clause
    05:56
  • The GROUP BY clause
    07:19
  • The HAVING clause, and information about error messages.
    05:29
  • The ORDER BY clause
    04:12
  • Remembering the order of the clauses
    02:28
  • Practice Activity Number 1
    00:22
  • Practice Activity Number 1 - The Solution
    04:56
  • What should you learn, and resources for you
    05:33
  • Bonus video - Learn more, and save money!
    04:58
  • Bonus lecture - Here's the link for more
    00:12
  • Thank you for watching
    00:40

Instructor
Best Selling Instructor - over 200,000 students so far
Phillip Burton
  • 4.5 Instructor Rating
  • 30,297 Reviews
  • 231,291 Students
  • 39 Courses

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.

He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.

He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.

His interests are working with data, including Microsoft Excel, Access and SQL Server.