DBMS / RDBMS with Oracle SQL & PL/SQL

DBMS (Database Management System) is a software that helps you store, organize, and manage data in a structured way so that you can easily add, view, update, or delete information.

An RDBMS is a DBMS based on E. F. Codd’s relational model: data is kept in tables of rows and columns, and tables are related through primary and foreign keys.
SQL is the standard, non-procedural language of relational databases – used to define tables, manipulate data, control access and query information.
PL/SQL is Oracle’s procedural extension of SQL – blocks, variables, control structures, exceptions, cursors, stored procedures, packages and triggers.
This course follows a training-institute database (courses, faculty, batches, students and payments) through 24 chapters – from DBMS concepts to native dynamic SQL.

What You Will Learn

Relational Concepts

DBMS features, data models, keys, integrity rules, relational algebra and client/server.

Tables & Constraints

Datatypes, CREATE/ALTER/DROP TABLE, constraints, DML and transactions.

Queries

Functions, grouping, joins, set operators, subqueries and views.

Administration Basics

Indexes, clusters, sequences, security, roles and SQL*Plus reports.

PL/SQL Programming

Blocks, control structures, exceptions, cursors, procedures, packages and triggers.

Practice & Assessment

15 questions with answers and a 5-question MCQ test on every chapter.

24 chapters 337 pages of notes 360 Q/A 120 MCQs

PDF Viewer – Free Tool

Read every chapter’s notes in the built-in PDF viewer: page navigation, zoom, fit-to-width, rotate, search inside the PDF, night-reading mode, full screen and download – and it remembers the page where you stopped. You can also open any PDF from your own device; it is read in your browser only and is never uploaded.

Open PDF Viewer

Course Contents

SQLChapters - SQL

CHAPTER-1 · 18 pages

Introduction to RDBMS

Introduction to DBMS and RDBMS: features, data models, tables, primary and foreign keys, integrity rules, relational algebra, SQL and client/server.

CHAPTER-2 · 12 pages

Introduction to Oracle

Introduction to Oracle: Oracle database server, Oracle instance, Personal Oracle, starting the database, SQL*Plus logon, host string and common errors.

CHAPTER-3 · 15 pages

Getting Started with Oracle

Getting started with Oracle SQL: CREATE TABLE, naming rules, datatypes, DESCRIBE, INSERT, SELECT, WHERE, ORDER BY, special operators and SQL buffer.

CHAPTER-4 · 18 pages

Creating Sample Tables

Oracle integrity constraints: PRIMARY KEY, UNIQUE, NOT NULL, CHECK, FOREIGN KEY and DEFAULT, column vs table constraints, and the sample tables.

CHAPTER-5 · 16 pages

Changing Structure and Data

ALTER TABLE, DROP TABLE, UPDATE and DELETE, transactions with COMMIT, ROLLBACK and SAVEPOINT, locking and read consistency in Oracle.

CHAPTER-6 · 12 pages

Arithmetic and Date Functions

Oracle single-row functions: arithmetic functions, the DUAL table, date arithmetic and date functions such as SYSDATE, ADD_MONTHS and MONTHS_BETWEEN.

CHAPTER-7 · 22 pages

String, Conversion and Miscellaneous Functions

Oracle string functions, TO_CHAR, TO_DATE and TO_NUMBER conversion with format models, and miscellaneous functions such as NVL, DECODE and GREATEST.

CHAPTER-8 · 12 pages

Grouping Data

Grouping data in Oracle SQL: GROUP BY, group functions COUNT, SUM, AVG, MAX and MIN, the HAVING clause, and ROLLUP and CUBE summaries.

CHAPTER-9 · 10 pages

Joining Tables

Joining tables in Oracle SQL: equi-join, table aliases, self-join, outer join with the (+) operator, and set operators UNION, INTERSECT and MINUS.

CHAPTER-10 · 23 pages

Views

Oracle views: what a view is, why it is needed, CREATE VIEW, simplifying queries, changing base tables through views, updatable join views and DROP VIEW.

CHAPTER-11 · 16 pages