Introduction
  • Introduction
PART I - SQL DEVELOPMENT FOR BEGINNERS
  • BEGINNING OF PART I
Installation
  • Installing Oracle 12c in Windows 10
  • Self Test - Oracle Installation
  • Using SQL Developer
  • Troubleshooting Connection Issues
Infrastructure Architecture
  • Client Server Architecture
  • Different types of Clients
Oracle RDBMS Architecture
  • Quick Overview of Oracle RDBMS Architecture
Connecting to an Oracle Database
  • Connecting to an Oracle Database
  • Demo - Connecting as SYSDBA
  • LAB - Connecting as SYSDBA
Stopping and Starting an Oracle Database
  • DEMO - Stopping an Oracle Database
  • LAB - Stopping an Oracle Database
  • DEMO - Starting an Oracle Database
  • LAB - Starting an Oracle Database
Table
  • What is a Table?
  • Data Types
SELECT - Basic SELECT Statement
  • Basics of a SELECT Statement
  • DESCRIBE Command - DESC
  • LAB - DESCRIBE or DESC Command
  • SELECT COUNT - Find the total number of Rows
  • LAB - SELECT COUNT
DBA Info - DBA_TABLESPACES
  • DBA_TABLESPACES
  • LAB - DBA_TABLESPACES
SELECT - Selecting Specific Data
  • Selecting Particular Columns
  • LAB - Selecting Particular Columns
  • WHERE Clause - Basics
  • LAB - WHERE Clause
DBA Info - Oracle Database User Architecture
  • Oracle Database User Architecture
  • Schema Vs User
  • How objects are stored?
  • Accessing the Objects
Classification of SQL Commands
  • Classification of SQL Commands
  • DML - Data Manipulation Language
  • DDL - Data Definition Language
  • DCL - Data Control Language
  • TCL - Transaction Control Language
Creating a Schema
  • Create a User
  • LAB - Create a User
  • Create a Table
  • LAB - Create a Table
DML - Data Manipulation Language
  • Basics of DML
  • DML - SELECT STATEMENT
  • DML - INSERT STATEMENT
  • LAB - DML - INSERT Fails. Why?
  • DBA Info - METADATA
  • DBA Info - DATA DICTIONARY
  • DBA Info - DEFAULT PERMANENT TABLESPACE
  • DML - Fixing the Failed INSERT
  • Demonstration of the commands to fix the INSERT
  • LAB - Demonstration of the commands to fix the INSERT
  • DML - UPDATE STATEMENT
  • Demo of an UPDATE STATEMENT
  • LAB - DML - UPDATE
  • DML - DELETE STATEMENT
  • Demo - DELETE STATEMENT
  • LAB - DML - DELETE
  • DML - MERGE STATEMENT
TCL - Transaction Control Language
  • TCL - Basics
  • Definition of a Transaction
  • What is a Transaction?
  • Demo of a Transaction
  • LAB - TCL - Transactions
  • DBA Info - Internal handling of Transaction through REDO
  • DBA Info - Internal handling of Transaction through UNDO
  • TCL - COMMIT STATEMENT
  • TCL - COMMIT Demo
  • LAB - TCL - COMMIT STATEMENT
  • TCL - ROLLBACK STATEMENT
  • LAB - ROLLBACK STATEMENT
  • TCL - SAVEPOINT STATEMENT
  • TCL - SAVEPOINT Demo
  • LAB - TCL - SAVEPOINT
DCL - Data Control Language
  • DCL - GRANT STATEMENT
  • DCL - SYSTEM PRIVILEGES
  • DCL - OBJECT PRIVILEGES
  • DCL - ROLE PRIVILEGES
  • DCL - REVOKE STATEMENT
  • DCL - GRANT and REVOKE - FULL DEMO
  • LAB - GRANT and REVOKE - FULL DEMO
  • DBA Info - Find the DBAs
  • LAB - Find the DBAs