Crash Course: Oracle basics

This crash course will bring you up to speed on Oracle DBMS basics for versions 8.x through 9.x, and provide you with an overview of Oracle10g's new tools and features.

 

Oracle often comes head to head with SQL Server and DB2 in DBMS evaluations. While Oracle's price tag may be higher, many users claim its functionality is preferred over that of its competitors, particularly in large-enterprise environments. Judge for yourself. This crash course will help you research Oracle technologies or get started with your own Oracle DBMS. It will bring you up to speed on Oracle DBMS basics for versions 8.x through 9.x, and provide you with an overview of Oracle10g's new tools and features.


More on Oracle basics

See what is on the Oracle wish lists of Oracle DBAs

Read about the options for Oracle third-party tools

Learn about tuning Oracle instance recovery

  TABLE OF CONTENTS
   Know your terminology
   Oracle overview
   Product details
   Is Oracle right for you?
   Getting started with your DBMS
   Database administration basics
   Upgrade considerations
   Resources to help you along the way

 

 


  Know your terminology
[ Return to Table of Contents ]
Before you invest your time and money in Oracle, make sure you know what you're talking about. The following resources will help you find your way through the sea of Oracle terms and acronyms.

 


  Oracle overview
[ Return to Table of Contents ]
Are you a self-dubbed Oracle newbie? Are you in the early stages of your Oracle research? Seeking some quick answers to your tough questions? Here's a list of beginning Oracle resources, including tutorials, expert technical advice and FAQs.


 

 


  Product details
[ Return to Table of Contents ]
Oracle8i, 9i, 10g... what do all the numbers mean? Get product details, version comparisons and an overview of Oracle tools and features here.

 


  Is Oracle right for you?
[ Return to Table of Contents ]
Many users are torn about which DBMS is best -- Oracle, SQL Server, DB2 or another option. One offers advanced functionality with a high price, another is cheaper but may limit you to smaller projects. Read the debates and comparisons among the DBMS solutions.

 


  Getting started with your DBMS
[ Return to Table of Contents ]
So you've chosen Oracle -- now what? You need to make sure you properly design and install your DBMS. The following resources will help you determine storage and sizing requirements, initiate design plans and identify installation best practices.


 

 


  Database administration basics
[ Return to Table of Contents ]
The job of a DBA is never done. They have to consider security, performance, availability, backup and recovery, migrations and so on -- and many of these tasks have to be performed on a daily basis. The following list will give you some quick insights into the job of an Oracle DBA.

 


  Upgrade considerations
[ Return to Table of Contents ]
Choosing Oracle for your DBMS needs means making a long-term investment in that vendor and its products. Upgrades are necessary to keep up with the latest and greatest technologies. The following resources will help you determine why and how to upgrade your DBMS.

 


  Resources to help you along the way
[ Return to Table of Contents ]
Feeling stumped by your Oracle research, installation or administration? The following resources may come in handy.

 

This was first published in May 2006

Dig deeper on Oracle DBA jobs, training and certification

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close