Oracle Tutorial

  • Home
  • Start Here
  • Basics
  • Advanced
    • Oracle View
    • Oracle Index
    • Oracle Synonym
    • Oracle Sequence
    • Oracle Administration
  • PL/SQL
  • Functions
    • Aggregate Functions
    • Analytic Functions
    • Comparison Functions
    • Date Functions
    • String Functions
  • API
    • Python Oracle
Home / Getting Started with Oracle Database

Getting Started with Oracle Database

If you have never been working with the Oracle Database or any other relational database systems (RDBMS) such as SQL Server, MySQL, or PostgreSQL,  this getting started section will be an excellent start.

The Oracle Database is quite a complex system; getting it up and running is time-consuming and sometimes challenging if you are just starting out. To be productive in the Oracle Database, you must read many books, ask lots of questions on various forums, and connect these parts to make your knowledge more practical.

Because we already experienced what you have been going through, we created this section to make your journey less painful and more fun to start working with the Oracle Database.

To start, just go through the following tutorials:

What Is Oracle Database
Give you a brief overview of the Oracle Database and its main component.
Install Oracle Database Server
Show you step by step how to install the Oracle Database on your local computer or server.
Download Oracle Sample Database
Introduce you to an Oracle sample database so that you can practice in the subsequent tutorials.
Create Oracle Sample Database
Walk you through steps for createing the Oracle sample database in Oracle.
Connect To Oracle Database Server
Guide you on how to connect to the Oracle Database Server using SQL*plus and SQL Developer tools. We choose these tools because they are freely available when you install the Oracle Database Server software. If you prefer to work with other client tools, you can feel free to do so.

If you have completed all five tutorials above, then congratulation, you are one step closer to mastering the Oracle Database.

Have fun learning and working with the Oracle Database.

Previous Oracle Tutorial
Next Oracle Basics

Getting Started

  • What Is Oracle Database
  • Install Oracle Database Server
  • Download Oracle Sample Database
  • Create Oracle Sample Database
  • Connect To Oracle Database Server

Oracle Data Manipulation

  • SELECT
  • Oracle DUAL Table
  • ORDER BY
  • SELECT DISTINCT
  • WHERE
  • Table & Column Aliases
  • AND
  • OR
  • FETCH
  • BETWEEN
  • IN
  • LIKE
  • IS NULL
  • Joins
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL OUTER JOIN
  • CROSS JOIN
  • Self Join
  • GROUP BY
  • HAVING
  • UNION
  • INTERSECT
  • MINUS
  • GROUPING SETS
  • CUBE
  • ROLLUP
  • PIVOT
  • UNPIVOT
  • INSERT
  • INSERT INTO SELECT
  • INSERT ALL
  • UPDATE
  • DELETE
  • MERGE
  • Subquery
  • Correlated Subquery
  • EXISTS
  • NOT EXISTS
  • ANY
  • ALL

Oracle Data Types

  • Oracle Data Types
  • NUMBER
  • FLOAT
  • BINARY_FLOAT
  • CHAR
  • NCHAR
  • VARCHAR2
  • NVARCHAR2
  • DATE
  • INTERVAL
  • TIMESTAMP
  • TIMESTAMP WITH TIME ZONE

Oracle Data Definition

  • CREATE TABLE
  • Identity Column
  • ALTER TABLE
  • ALTER TABLE ADD Column
  • ALTER TABLE MODIFY Column
  • Drop Columns
  • DROP TABLE
  • TRUNCATE TABLE
  • RENAME Table
  • Oracle Virtual Column

Oracle Constraints

  • PRIMARY KEY
  • FOREIGN KEY
  • UNIQUE
  • CHECK
  • NOT NULL

Oracle Views

  • CREATE VIEW
  • DROP VIEW
  • Updatable Views
  • Inline Views
  • WITH CHECK OPTION

About Oracle Tutorial

OracleTututorial.com website provides Developers and Database Administrators with the updated Oracle tutorials, scripts, and tips.

Search

Recent Tutorials

  • Oracle Implicit Statement Results
  • Calling PL/SQL Stored Functions in Python
  • Calling PL/SQL Procedures in Python
  • Managing Transaction in Python
  • Deleting Data From Oracle Database in Python

Site Links

  • Oracle Books
  • About
  • Contact
  • Privacy Policy
  • Terms of Use

Copyright © 2021 Oracle Tutorial. All Rights Reserved.