Crash Course: Oracle basics |
 |
By Robyn Lorusso, Editor, SearchOracle.com
23 May 2006 | SearchOracle.com |
|
|
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.
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.
|
