Oracle Tutorial

Categories: Oracle
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Oracle tutorial

Oracle tutorial provides basic and advanced concepts of Oracle. Our Oracle tutorial is designed for beginners and professionals.

Oracle is a relational database management system. It is widely used in enterprise applications.

What is Oracle?

Oracle database is a relational database management system (RDBMS) from Oracle Corporation. This article will explain a complete overview of the Oracle database, features, history, and editions . Before discussing the oracle, we will first need to know about the database.

What is a database?

A database refers to the organized collection of structured data stored electronically in a device . It allows us to access, manage, and find relevant information frequently. The flat file structure was extensively used to store data before the database system was invented. The relational database approach becomes popular in comparison to the flat file model . Because it eliminates redundant data . For example, suppose we have an employee and contact information stored in the same file. In such a case, the employees with multiple contacts will show up in many rows.

The RDBMS system manages the relational data. Oracle Database is the most famous relational database system (RDBMS) because it shares the largest part of a market among other relational databases . Some other popular relational databases are MySQL, DB2, SQL Server, PostgreSQL, etc.

What is the Oracle database?

Oracle database is a relational database management system  . It is one of the most popular relational database engines in the IT market for storing, organizing, and retrieving data.

Oracle database was the first DB that designed for enterprise grid computing and data warehousing. Enterprise grid computing provides the most flexible and cost-effective way to manage information and applications. It uses SQL queries as a language for interacting with the database.

Editions of Oracle database

Oracle database is compatible with a wide range of platforms such as Windows, UNIX, Linux, and macOS. It supports several operating systems like IBM AIX, HP-UX, Linux, Microsoft Windows Server, Solaris, SunOS, macOS, etc. In the late 1990s, Oracle began supporting open platforms like GNU/Linux.

The following is a list of Oracle database editions in order of priority:

  • Enterprise Edition: It is the most robust and secure edition. It offers all features, including superior performance and security.
  • Standard Edition: It provides the base functionality for users that do not require Enterprise Edition’s robust package.
  • Express Edition (XE): It is the lightweight, free and limited Windows, and Linux edition.
  • Oracle Lite:  for mobile devices.
  • Personal Edition: It’s comparable to the Enterprise Edition but without the Oracle Real Application Clusters feature.

Oracle tutorial full course

Show More

About the instructor

A

Course Curriculum

What is Oracle

Oracle Tables

CREATE TABLE AS in Oracle

ALTER TABLE In Oracle

DROP TABLE In Oracle

TRUNCATE TABLE In Oracle

QUERIES In Oracle

INSERT Query In Oracle

SELECT Query In Oracle

UPDATE Query In Oracle

DELETE Query In Oracle

INSERT ALL In Oracle

GROUP BY Clause In Oracle

HAVING Clause In Oracle

ORDER BY Clause In Oracle

MINUS In Oracle

INTERSECT Operator In Oracle

TRIGGER In Oracle

AFTER TRIGGER In Oracle

BEFORE TRIGGER In Oracle

ENABLE TRIGGER In Oracle

DISABLE TRIGGER In Oracle

DROP TRIGGER In Oracle

CURSOR In Oracle

VIEW In Oracle

DISTINCT Clause In Oracle

PROCEDURE In Oracle

UNION In Oracle

UNION ALL In Oracle

OUTER JOIN In Oracle

INNER JOIN In Oracle

CROSS JOIN In Oracle

EQUI JOIN In Oracle

SEMI JOIN In Oracle

SELF JOIN In Oracle

ANTI JOIN In Oracle

ROWNUM In Oracle

SQLERRM Function In Oracle

SQLCODE Function In Oracle

USERENV Function In Oracle

ACOS Function In Oracle

ADD_MONTHS Function In Oracle

ASCII Function In Oracle

ASCIISTR Function In Oracle

ASIN Function In Oracle

ATAN Function In Oracle

ATAN2 Function In Oracle

AVG Function In Oracle

BFILENAME Function In Oracle

ABS Function In Oracle

BIN_TO_NUM Function In Oracle

BITAND Function In Oracle

CARDINALITY Function In Oracle

CASE Function In Oracle

CAST Function In Oracle

CEIL Function In Oracle

CHARTOROWID Function In Oracle

CHR Function In Oracle

COALESCE Function In Oracle

COMPOSE Function In Oracle

CONCAT With Function In Oracle

CONCAT Function In Oracle

CONVERT Function In Oracle

CORR Function In Oracle

COS Function In Oracle

COSH Function In Oracle

COUNT Function In Oracle

COVAR_POP Function In Oracle

COVAR_SAMP Function In Oracle

CUME_DIST Function In Oracle

CURRENT_DATE In Oracle

CURRENT_TIMESTAMP Function In Oracle

DBTIMEZONE Function In Oracle

DECODE Function In Oracle

DECOMPOSE Function In Oracle

DENSE_RANK Function In Oracle

DUMP Function In Oracle

EMPTY_BLOB Fuction In Oracle

EMPTY_CLOB Function In Oracle

EXP Function In Oracle

EXTRACT Function In Oracle

FIRST_VALUE Function In Oracle

FLOOR Function In Oracle

FROM_TZ Function In Oracle

GLOBAL TEMP TABLES In Oracle

GREATEST Function In Oracle

GROUP_ID Function In Oracle

HEXTORAW Function In Oracle

INITCAP Function In Oracle

INSTR Function In Oracle

INSTR2 Function In Oracle

VARIANCE Function In Oracle

VAR_SAMP Function In Oracle

VAR_POP Function In Oracle

USER Function In Oracle

UID Function In Oracle

TZ_OFFSET Function In Oracle

TRUNC (Numbers) Function In Oracle

TRUNC (Dates) Function In Oracle

TO_YMINTERVAL Function In Oracle

TO_TIMESTAMP_TZ Function In Oracle

TO_TIMESTAMP Function In Oracle

TO_SINGLE_BYTE Function In Oracle

TO_NUMBER Function In Oracle

TO_NCLOB Function In Oracle

TO_MULTI_BYTE Function In Oracle

TO_LOB Function In Oracle

TO_DSINTERVAL Function In Oracle

TO_DATE Function In Oracle

TO_CLOB Function In Oracle

TO_CHAR Function In Oracle

TANH Function In Oracle

TAN Function In Oracle

SYSTIMESTAMP Function In Oracle

SYSDATE Function In Oracle

SYS_CONTEXT Function In Oracle

SQRT Function In Oracle

SESSIONTIMEZONE Function In Oracle

LOG Function In Oracle

LAST_DAY Function In Oracle

LEAST Function In Oracle

LENGTH Function In Oracle

LENGTH2 Function In Oracle

INSTR4 Function In Oracle

INSTRB Function In Oracle

INSTRC Function In Oracle

LAG Function In Oracle

LAST_VALUE Function In Oracle

LEAD Function In Oracle

LENGTH4 Function In Oracle

LENGTHB Function In Oracle

LENGTHC Function In Oracle

LISTAGG Function In Oracle

LN Function In Oracle

LNNVL Function In Oracle

LOCAL TEMP TABLES In Oracle

LOCALTIMESTAMP Function In Oracle

MAX Function In Oracle

MEDIAN Function In Oracle

MIN Function In Oracle

MOD Function In Oracle

MONTHS_BETWEEN Function In Oracle

NANVL Function In Oracle

NEW_TIME Function In Oracle

NEXT_DAY Function In Oracle

NULLIF Function In Oracle

NUMTODSINTERVAL Function In Oracle

NUMTOYMINTERVAL Function In Oracle

NVL Function In Oracle

NVL2 Function In Oracle

POWER Function In Oracle

STDDEV Function In Oracle

NTH_VALUE Function In Oracle

SINH Function In Oracle

SIN Function In Oracle

SIGN Function In Oracle

ROUND (Numbers) Function In Oracle

FROM Clause In Oracle

FUNCTION In Oracle

SUM Function In Oracle

ROUND (Dates) Function In Oracle

REMAINDER Function In Oracle

JOINS In Oracle

RANK Function In Oracle

RAWTOHEX Function In Oracle

REGEXP_COUNT Function In Oracle

Student Ratings & Reviews

No Review Yet
No Review Yet
error: Content is protected !!