Learn Oracle SQL

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Installation

Lecture 1: Installing Oracle 12c in Windows 10

Lecture 2: Using SQL Developer

Lecture 3: Troubleshooting Connection Issues

Chapter 3: Infrastructure Architecture

Lecture 1: Client Server Architecture

Lecture 2: Different types of Clients

Chapter 4: Oracle RDBMS Architecture

Lecture 1: Quick Overview of Oracle RDBMS Architecture

Lecture 2: Connecting to an Oracle Database

Lecture 3: Demo – Connecting as SYSDBA

Lecture 4: DEMO – Stopping an Oracle Database

Lecture 5: DEMO – Starting an Oracle Database

Lecture 6: What is a Table?

Lecture 7: Data Types

Chapter 5: SELECT – Basic SELECT Statement

Lecture 1: Basics of a SELECT Statement

Lecture 2: DESCRIBE Command – DESC

Lecture 3: SELECT COUNT – Find the total number of Rows

Lecture 4: DBA_TABLESPACES

Lecture 5: Selecting Particular Columns

Lecture 6: WHERE Clause – Basics

Chapter 6: DBA Info – Oracle Database User Architecture

Lecture 1: Oracle Database User Architecture

Lecture 2: Schema Vs User

Lecture 3: How objects are stored?

Lecture 4: Accessing the Objects

Chapter 7: Classification of SQL Commands

Lecture 1: Classification of SQL Commands

Lecture 2: DML – Data Manipulation Language

Lecture 3: DDL – Data Definition Language

Lecture 4: DCL – Data Control Language

Lecture 5: TCL – Transaction Control Language

Chapter 8: Creating a Schema

Lecture 1: Create a User

Lecture 2: Create a Table

Chapter 9: DML – Data Manipulation Language

Lecture 1: Basics of DML

Lecture 2: DML – SELECT STATEMENT

Lecture 3: DML – INSERT STATEMENT

Lecture 4: LAB – DML – INSERT Fails. Why?

Lecture 5: DBA Info – METADATA

Lecture 6: DBA Info – DATA DICTIONARY

Lecture 7: DBA Info – DEFAULT PERMANENT TABLESPACE

Lecture 8: DML – Fixing the Failed INSERT

Lecture 9: Demonstration of the commands to fix the INSERT

Lecture 10: DML – UPDATE STATEMENT

Lecture 11: Demo of an UPDATE STATEMENT

Lecture 12: DML – DELETE STATEMENT

Lecture 13: Demo – DELETE STATEMENT

Lecture 14: DML – MERGE STATEMENT

Chapter 10: TCL – Transaction Control Language

Lecture 1: TCL – Basics

Lecture 2: Definition of a Transaction

Lecture 3: What is a Transaction?

Lecture 4: Demo of a Transaction

Lecture 5: DBA Info – Internal handling of Transaction through REDO

Lecture 6: DBA Info – Internal handling of Transaction through UNDO

Lecture 7: TCL – COMMIT STATEMENT

Lecture 8: TCL – COMMIT Demo

Lecture 9: TCL – ROLLBACK STATEMENT

Lecture 10: TCL – SAVEPOINT STATEMENT

Lecture 11: TCL – SAVEPOINT Demo

Chapter 11: DCL – Data Control Language

Lecture 1: DCL – GRANT STATEMENT

Lecture 2: DCL – SYSTEM PRIVILEGES

Lecture 3: DCL – OBJECT PRIVILEGES

Lecture 4: DCL – ROLE PRIVILEGES

Lecture 5: DCL – REVOKE STATEMENT

Lecture 6: DCL – GRANT and REVOKE – FULL DEMO

Lecture 7: DBA Info – Find the DBAs

Chapter 12: DDL – Data Definition Language

Lecture 1: DDL – CREATE STATEMENT

Lecture 2: DDL – ALTER STATEMENT

Lecture 3: DDL – DROP STATEMENT

Lecture 4: DDL – RENAME STATEMENT

Lecture 5: DDL – TRUNCATE STATEMENT

Lecture 6: DDL – TRUNCATE vs DELETE

Lecture 7: DDL – COMMENT STATEMENT

Lecture 8: ALL THE DDL STATEMENTS – FULL DEMO

Lecture 9: Addressing the Objects

Chapter 13: Database Design

Lecture 1: OLTP – Online Transaction Processing System

Lecture 2: DSS – Decision Support System

Lecture 3: DATA MODELING – ENTITY RELATIONSHIP MODEL or ER MODEL

Lecture 4: ER MODEL – CREATION & NORMALIZATION

Lecture 5: ER MODEL – CONCEPTUAL MODEL

Lecture 6: ER MODEL – LOGICAL MODEL

Lecture 7: ER MODEL – PHYSICAL MODEL

Lecture 8: ER MODEL vs ER DIAGRAM

Lecture 9: ENTITY, ATTRIBUTE, TUPLE & RELATIONSHIPS

Chapter 14: What is Next?

Lecture 1: Next course to take