HiveBrain v1.2.0
Get Started
← Back to all entries
patternModerate

Where to start with Oracle?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
withoraclewherestart

Problem

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!

Solution

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.

  • Building with Blocks



  • Controlling the Flow of Execution



  • Working with Strings



  • Working with Numbers in PL/SQL



  • Working with Dates in PL/SQL



  • Error Management



  • Working with Records



  • Working with Collections



  • Bulk Processing with BULK COLLECT and FORALL



  • The Data Dictionary: Make Views Work for You



  • Wrap Your Code in a Neat Package



  • Working with Cursors

Context

StackExchange Database Administrators Q#56123, answer score: 18

Revisions (0)

No revisions yet.