In this tutorial you will learn how to install Oracle Database 10g Express in Ubuntu Lucid Lynx (Ubuntu 10.04 LTS). The express edition is free and any beginning developer can practice using Oracle on their Linux computer without needing a license. Emphasis will be placed on the installation of Oracle on a Debian Linux x86 system.
What will you learn here: As a starter in Oracle, you can experience a lot of difficulties learning this database especially working with Linux environment. To minimize the problem, this six must know Oracle commands are important so that you will have skills to work around with the most important database tasks without the need to study hundreds of commands. The following are skills you will acquire after reading that tutorial:
a.) Starting and Shutting down the Oracle database. b.) Connecting to the database using a command line. c.) Creating new admin user to your Oracle database and granting rights. This admin user is also called DBA (database administrator). d.) Creating tables in the database, inserting and modifying data.
a.) Once you are highly familiar with the Oracle Database Homepage. You can then start designing, creating and troubleshooting Oracle projects. This is where you can use the Oracle SQL Developer. This is an IDE for working with Oracle databases.