Oracle SQL and PLSQL Beginner Resources

In this post lets take a look at few of the free Oracle SQL and PLSQL Beginner resources. These can also be used by Intermediate and advanced users!!

Oracle Dev Gym

Here is a great blog by Steven Feuerstein about Oracle Dev Gym. The portal has got 4 main sections:

• Classes: there are some really awesome free tutorials on SQL and PLSQL.
• Quizzes: daily quizzes on SQL, PLSQL and various other topics.
• Workouts
• Tournaments

Sign up for a free account or use your existing Oracle user name and password to access Oracle Dev Gym.

Live SQL

This is a great free learning tool for those of you who want to learn and code SQL on an Oracle Database. It comes pre loaded with schema that you have access to. If you are new, you can register for free. If you already have an account in oracle.com, you can use the existing details to  login to live sql. Once you login, click on “Start Coding” or “SQL Worksheet” to start working with SQL queries. Go ahead and try the below queries. Login in here.

SELECT TO_CHAR(SYSDATE,'DY')
     , TO_CHAR(SYSDATE,'Dy')
     , TO_CHAR(SYSDATE,'MONTH')
     , TO_CHAR(SYSDATE,'Month')
  FROM  DUAL;

/*Fetch the first 5 rows from employees table in HR Schema*/
SELECT * 
  FROM hr.employees
 FETCH FIRST 5 ROWS ONLY;

/*Join employees and department tables and fetch the first 10 rows*/
SELECT e.first_name, e.last_name, d.department_name
  FROM hr.employees e
     , hr.departments d
 WHERE d.department_id = e.department_id
 FETCH FIRST 10 ROWS ONLY;

YouTube Channels

• The Magic of SQL: Have got some wonderful SQL tutorials. The tutorials are well suited for Beginners.
• Connor McDonald: If you want to learn more about Analytic functions in SQL, definitely check this channel out.
• Practically Perfect PLSQL with Steven Feuerstein: Check out this channel for everything PLSQL. This is one of the best resources to learn more about PLSQL programming.

Check out my YouTube video as well. I hope this was helpful for you. If you know of any other free and useful resources let me know and I will add it to the blog.