Oracle Tutorials

Understanding SQL Basics

This tutorial will help you understand SQL basics, SQL,  and Structured English Query Language (SEQUEL ), RDBMS (Relational Database Management Systems).

Understanding SQL SELECT Query Statements

This tutorial will help you understand  SQL SELECT Query Statements. This guide has all the information about sql statements along with challenging exercises like sorting and counting query outputs, selecting rows/columns from tables and views,  grouping outputs/applying group functions, merging tables, using subqueries, etc..

Understanding SQL Transaction Management

This tutorial explains  SQL Transaction statements so you can manaage your database well. An SQL transaction is a logical unit of work that has been requested by a user which is to be applied to the existing database objects. SQL transaction management allows users to group  SQL statements into a single transaction so that it can be either  be applied to the database or all rolled back.

Managing Oracle User Accounts, Schema and Privileges

Managing a database is a tough task, and that is why this tutorial has been created for all you guys who want to know how to manage Oracle User Accounts, Schema & Priviledges.

Understanding SQL DDL Statements

This tutorial will help you understand SQL DDL Statements. DDL stands for Data Definition Language and these are statements  that can be used to create, manage data objects in the database.

Understanding SQL DML Statements

This tutorial  explains  SQL DML Statements. DML stands for Data Manipulation Language, which are statements that allows users to change data values in database tables.

Managing Oracle Database Tables

This tutorial will show you how to manage Oracle Database Tables.  For you to be able to manage any Oracle DB tables, you must know how to store data in rows and columns, define a table name,  set of columns, etc..

Creating Your Own PL/SQL Procedures and Functions

This tutorial will show you how to create your own PL/SQL Procedures and Functions.

Managing Oracle Table Indexes

This is a tutorial that will teach you how to manage Oracle Table Indexes. A table index is an optional structure that is associated with a table that allows any sql statements to work accordingly against a table.  Proper managing of table indexes will result to faster access path to a table data.

Managing Oracle Tablespaces and Data Files

This tutorial will show you how to manage Oracle Tablespaces & Data Files.  Oracle tablespace is a huge unit of logical storage in a specific Oracle database which is used by the Oracle server as storage for structures data objects, like tables & indexes.