Introduction to Database
  • What is a Database?
Introduction to Database Objects
  • What is a Table?
  • Table - Additional Details
Database Languages
  • Data Definition Language
  • Data Definition Language - Recap
  • Data Manipulation Language
  • Data Control Language
Database Objects - Index and View
  • What is an index?
  • What is a View?
Relational DBMS (RDBMS) - Introduction
  • What is a Foreign Key?
  • What is a RDBMS?
  • What is a Primary Key?
  • What is an Unique Key?
  • What is the difference between Primary Key and Unique Key?
Computers and Databases
  • Computers and Databases
  • What is Data Concurrency?
  • What is Data Consistency?
Installing Oracle 12c in Windows 10
  • Download and Install Oracle 12c in a Windows PC or Laptop
  • Optional - Install Oracle 12c with Multitenancy in a Windows PC or Laptop
  • Using Oracle SQL Developer
  • Troubleshooting Connection Issues
Concepts Illustrated
  • Oracle Instance vs Database
  • Installation
  • Files
  • Starting a Database
  • Basics of Computing
  • Client Server Architecture
  • PGA - Program Global Area
  • Dedicated Server Mode
  • Shared Server Mode
Oracle Storage Structures
  • Oracle Physical Storage Structures
  • Oracle Logical Data Structures
  • Where can the Oracle Physical Structure files be stored?
  • What is a Raw Device?
  • What is a File System?
  • What is an Oracle ASM?
  • What is a Cluster File System?
Oracle Parameter Files
  • What is a Parameter file?
  • What is a SPFILE?
  • What is a PFILE?
Connecting to an Oracle Database
  • How to connect to a Oracle Database?
  • How does an Oracle database start?
  • Demo of various starting methods of an Oracle database
  • How to log in to an Oracle Database?
  • Oracle Database Dictionary
  • How to log in to an Oracle Database? - Answer Video
Basics of Oracle Database Internals and Security
  • Basics of Oracle Internal Structure
  • What is a Database Control?
  • How to create an user in Oracle Database?
  • Default Tablespace and Temporary Tablespace for a new Oracle Database user
  • Oracle Roles and Privileges
  • Oracle System Privileges
Basic Oracle Database Operations
  • How to verify the Oracle Database Name?
  • How to find the version of the Oracle Database?
  • How to view the user accounts within an Oracle Database?
  • How to use DBA view in SQL Developer?
  • How to find the tablespaces in an Oracle Database?
  • Oracle Tablespaces
  • What is an Oracle User?
  • What is an Oracle Schema?
  • Difference between an Oracle user and schema
  • General user architecture of a database
Structured Query Language (SQL)
  • SQL Structured Query Language
  • SQL CTAS method
  • SQL SELECT Statement
  • SQL INSERT Statement
  • SQL DELETE Statement
  • SQL UPDATE Statement
Oracle Memory and Background Processes
  • Oracle Background Processes
  • Dedicated Server vs Shared Server
  • SGA System Global Area of an Oracle Database
  • PGA Program Global Area of an Oracle Database
  • UGA User Global Area of an Oracle Database
SGA and Database Buffer
  • SGA Database Buffer Part 1
  • SGA Database Buffer Part 2
  • SGA Database Buffer Part 3
  • SGA Database Buffer Part 4
  • SGA Database Buffer Part 5
  • SGA Database Buffer Part 6
  • SGA Database Buffer Part 7
  • SGA Database Buffer Part 8
  • SGA Database Buffer Part 9
  • SGA Database Buffer Part 10
  • SGA Database Buffer Part 11