top of page

Database Module (Oracle)

​

The Oracle PL/SQL language is a flexible procedural extension to SQL and increases productivity, performance, scalability, portability and security. In this course, you will gain the practical knowledge to write PL/SQL programs. You will learn to build stored procedures, design and execute modular applications and increase the efficiency of data movement.

​

Database Administration      
Quality Analysis  
   E-Commerce

1. Introduction to Databases and Oracle

  • Understanding Databases and Database Management Systems (DBMS)

  • Introduction to Oracle Database

  • Oracle SQL Developer Setup

  • Connecting to the Oracle Database

​

2. SQL Basics

  • Introduction to SQL

  • SELECT Statement

  • Filtering Data with WHERE Clause

  • Sorting Data with ORDER BY

  • Aliases for Column Names

​

3. Retrieving Data from Multiple Tables

  • Understanding Table Joins

  • INNER JOIN, LEFT JOIN, RIGHT JOIN

  • CROSS JOIN, SELF JOIN

  • USING Clause

  • UNION and UNION ALL Operators

​

4. Filtering Data with Advanced Techniques

  • Using the BETWEEN Operator

  • Working with NULL Values

  • Using IN and NOT IN Operators

  • Combining Conditions with AND, OR, NOT

  • Subqueries and Nested Queries

​

5. Data Modification and Transactions

  • INSERT, UPDATE, and DELETE Statements

  • COMMIT and ROLLBACK Statements

  • Introduction to Transactions

  • Savepoints

​

6. Aggregating and Grouping Data

  • GROUP BY Clause

  • Aggregate Functions (SUM, AVG, COUNT, MAX, MIN)

  • HAVING Clause

  • GROUPING SETS and ROLLUP

  • Cube and Grouping

​

7. Working with Date and Time Data

  • Date and Time Data Types

  • Date Functions (TO_DATE, TO_CHAR, TO_TIMESTAMP)

  • Calculating Date Differences

  • Extracting Date Components

​

8. Managing Data with DDL Statements

  • Introduction to Data Definition Language (DDL)

  • Creating and Altering Tables

  • Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK)

  • Indexes

9. Views, Sequences, and Synonyms

  • Creating Views

  • Sequences

  • Synonyms

  • Privileges and Security

​

10. Advanced SQL Topics

  • Analytic Functions (ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD)

  • Working with Large Data Sets

​

Assessments and Projects:

  • Weekly quizzes or assignments

  • Midterm exam

  • Final exam

  • Hands-on projects (e.g., building a database application)

Staffing Support​

  • Resume Preparation

  • Mock Interview Preparation

  • Phone Interview Preparation

  • Face to Face Interview Preparation

  • Project/Technology Preparation

  • Internship with internal project work

  • Externship with client project work

Our Salient Features:

  • Hands-on Labs and Homework

  • Group discussion and Case Study

  • Course Project work

  • Regular Quiz / Exam

  • Regular support beyond the classroom

  • Students can re-take the class at no cost

  • Dedicated conf. rooms for group project work

  • Live streaming for the remote students

  • Video recording capability to catch up the missed class

bottom of page