Oracle SQL

Duration : 1 Month

Category : Database, SQL, DBMS

Course Objective
Curriculum

The objective of the Oracle SQL course is to equip learners with a strong foundation in Structured Query Language (SQL) using Oracle Database. This course is designed to develop the ability to store, retrieve, manipulate, and manage data efficiently in real-time business environments. Learners will gain hands-on experience working with Oracle database objects, writing optimized queries, and understanding core database concepts essential for application development, data analytics, and backend programming.

Whether you're starting fresh or upgrading your skills, this course provides the perfect blend of theory, practice, and industry relevance to help you stand out in today’s data-driven world.

By the end of the course, learners will be able to confidently create and manage tables, apply constraints, write advanced SQL queries, work with functions, joins, subqueries, and implement best practices for data handling in Oracle.

Introduction to SQL

Introduction to SQL
SQL Developer
Logging in SQL*Plus
Connecting to Database on windows and Linux

SQL languages-DDL,DML,TCL,DCL

Database Objects
CREATE TABLE statement
Data types
Overview of constraint
Creating a table using subquery
Use the ALTER TABLE statement to add, modify, and drop a column
DROP TABLE statement

Accessing Data using Queries

Select Statements
Arithmetic expressions and NULL values in the SELECT statement
Column aliases
Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
DESCRIBE command

Restricting and Sorting Data

Sorting rows using ORDER BY clause
SQL row limiting clause in a query

Using Single-Row Functions to Customize Output

Describe the differences between single row and multiple row functions
Manipulate strings with character function in the SELECT and WHERE clauses
numbers with the ROUND, TRUNC and MOD functions
Perform arithmetic with date data
Manipulate dates with the date functions

Working on Constraints

Managing constraints
TYPES of Constraints
ON DELETE Cascade option

Using the SET Operators

Set Operators
INTERSECT operator
MINUS operator
Matching the SELECT statements
Using ORDER BY clause in set operations

Using Conversion Functions and Conditional Expressions

Describe implicit and explicit data type conversion
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Apply the NVL, NULLIF, and COALESCE functions to data
Conditional Expressions

Reporting Aggregated Data Using the Group Functions

Group Functions
Grouping Rows (GROUP BY and HAVING clause)
Nesting Group Functions

Displaying Data From Multiple Tables Using Joins

Introduction to JOINS
Types of Joins
Natural join
Self-join
OUTER join
Cartesian Joins / Cross Joins

Using Subqueries to Solve Queries

Introduction to Subqueries
Single Row Subqueries
Multiple Row Subqueries

Dictionary Views

Introduction to Data Dictionary
Describe the Data Dictionary Structure
Using the Data Dictionary views
DBMS_metadata
User_source
User_views
Querying the Data Dictionary Views

Views, Sequences and Synonyms

Why Views
View TYPES
Sequences and its use
Using Synonyms

External tables & DBMS_Error

SQL*Loader
Loading data from excel / text files to tables
DBMS_ErrorLog
External tables

Indexes

Types of Indexes
Binary Tree
Bit Map

User access control

Grant/Revoke privileges to other users
With GRANT Option
Objects Vs System Privileges

TimeZone

Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
Working with INTERVAL data types
Using Datetime functions in queries

Alexzender Alex

CSE Teacher

Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusa dolore mque laudantium totam rem aperiam eaqipsa quae ab illo inventore veritatvolup tatem quia voluptas sit aspernatur aut odit aut fugit sed quia conseque.

Nathaniel Bustos

Manager

Latanya Kinard

Web Designer

Where Our Alumini Works