Here is a simple guide to learning Oracle as a developer from scratch, on your own. For an absolute beginner to Oracle, it helps you navigate your way around the sea of information available at your disposal.
A 5-step answer to the question "How to learn Oracle?"
1. Get yourself an Oracle development environment
If you are learning at your workplace, ask for access to a training instance of the Oracle database.
Register on Oracle LiveSQL, which gives you access to an empty Oracle 12c schema via the web browser without having to install anything. You can try out your scripts in LiveSQL or reuse their community scripts.
2. Do the basic Oracle Learning Library Course
Oracle’s comprehensive learning library has some courses designed for beginners. Of these, you can start with the Oracle by Example (OBE) tutorial: Oracle Database Quickstart.
With the course, you should be able to do these basic operations in the Oracle database:
- Create a schema and connect to it
- Create and delete tables
- Insert, modify, and delete records in a table
- Query, filter and sort data
- Assign and revoke privileges
Depending on your interest, you can choose to dig deeper into specific areas by taking up any number of 12c tutorials.
[Oracle Database Quickstart lists the following as pre-requisites, but if you already have a development environment at your disposal, you need not go through them for setup your environment:
3. Read the Database 2-Day Developer’s Guide
Oracle has a handy 2-Day Developer’s Guide in tune for beginners, a primer for Oracle application development using SQL and PL/SQL.
The latest at the time of writing this (Oracle 12c guide) – is here .
If you are using Oracle XE 11g R2, the corresponding documentation is here: Database 2-Day Developers Guide (11g R2).
By the end of reading and working with the 2-Day Developer’s Guide, you should have an understanding of how to do these in the Oracle database:
- Create and manage DB objects
- Develop stored procedures, packages
- Use triggers
- Implement globalization support
- Understand SQL and PLSQL best practices
- Develop and deploy a simple Oracle database application
4. Visit Oracle discussion forums
After getting the hang of the basics, visit some good Oracle discussion forums to see real-world problems that others face in Oracle development, and what kind of solutions help them.
Here are a few useful forums:
5. Work on a project
Nothing helps more than on-the-job experience. Master the basics, then get on an actual project with Oracle database work. If you get to work with those who know more than you, learn from them.
All the best on your journey to learning Oracle development. It is a fascinating ride!