Where to start with Oracle?

Question

This question only needs one answer: a list of great resources for getting started with Oracle, including Database Administration, PL/SQL and SQL.

You may find your question has been closed as a duplicate of this one, if so, please don't be offended: we are trying to be as helpful as we can without diluting the expert focus of this site. Closing a question as a duplicate of this one is us saying "What you really need is to spend some time reading some of the best resources available rather than have your specific question answered right now. If you do get through these resources, you'll soon be back with more advanced questions!

Answer 1

Oracle's official documentation library has some great resources, including:

• The Database Concepts guide, which is essential reading for beginner and Oracle ninja alike.
• The 2 Day DBA
• The 2 Day Developer's Guide

Oracle 12c official PL/SQL documentation:

• PL/SQL Language Reference
• PL/SQL Packages and Types Reference
• Chapter 5 Developing Stored Subprograms and Packages from 2 Day Developer's Guide

PL/SQL 101

This is a twelve part series of articles on understanding and using PL/SQL. It is written by Steven Feuerstein and published in Oracle Magazine.

1. Building with Blocks
2. Controlling the Flow of Execution
3. Working with Strings
4. Working with Numbers in PL/SQL
5. Working with Dates in PL/SQL
6. Error Management
7. Working with Records
8. Working with Collections
9. Bulk Processing with BULK COLLECT and FORALL
10. The Data Dictionary: Make Views Work for You
11. Wrap Your Code in a Neat Package
12. Working with Cursors

Answer 2

I like this one:

Oracle Magazine SQL 101