Section 1 : Introduction to Database

lecture 1 What is a Database 3:56

Section 2 : Introduction to Database Objects

lecture 2 What is a Table 6:25
lecture 3 Table - Additional Details 7:5

Section 3 : Database Languages

lecture 4 Data Definition Language 4:22
lecture 5 Data Definition Language - Recap 2:2
lecture 6 Data Manipulation Language
lecture 7 Data Control Language 2:17

Section 4 : Database Objects - Index and View

lecture 8 What is an index 9:28
lecture 9 What is a View 3:54

Section 5 : Relational DBMS (RDBMS) - Introduction

lecture 10 What is a Foreign Key 6:14
lecture 11 What is a RDBMS 4:35
lecture 12 What is a Primary Key 4:1
lecture 13 What is an Unique Key 3:20
lecture 14 What is the difference between Primary Key and Uni 2:21

Section 6 : Computers and Databases

lecture 15 Computers and Databases 4:34
lecture 16 What is Data Concurrency
lecture 17 What is Data Consistency 2:31

Section 7 : Installing Oracle 12c in Windows 10

lecture 18 Download and Install Oracle 12c in a Windows PC or 11:58
lecture 19 Optional - Install Oracle 12c with Multitenancy 12:11
lecture 20 Using Oracle SQL Developer 2:11
lecture 21 Troubleshooting Connection Issues

Section 8 : Concepts Illustrated

lecture 22 Oracle Instance vs Database 6:13
lecture 23 Installation 2:24
lecture 24 Files 1:13
lecture 25 Starting a Database 2:30
lecture 26 Basics of Computing 4:52
lecture 27 Client Server Architecture 8:2
lecture 28 PGA - Program Global Area 4:58
lecture 29 Dedicated Server Mode 1:35
lecture 30 Shared Server Mode 8:55

Section 9 : Oracle Storage Structures

lecture 31 Oracle Physical Storage Structures 4:38
lecture 32 Oracle Logical Data Structures 1:56
lecture 33 Where can the Oracle Physical Structure files be s 3:29
lecture 34 What is a Raw Device
lecture 35 What is a File System 3:54
lecture 36 What is an Oracle ASM 3:5
lecture 37 What is a Cluster File System 4:24

Section 10 : Oracle Parameter Files

lecture 38 What is a Parameter file 1:43
lecture 39 What is a SPFILE 2:29
lecture 40 What is a PFILE 2:50

Section 11 : Connecting to an Oracle Database

lecture 41 How to connect to a Oracle Database 11:50
lecture 42 How does an Oracle database start 11:45
lecture 43 Demo of various starting methods of an Oracle data 20:29
lecture 44 How to log in to an Oracle Database 3:41
lecture 45 Oracle Database Dictionary 7:32
lecture 46 How to log in to an Oracle Database - Answer Video 3:58

Section 12 : Basics of Oracle Database Internals and Security

lecture 47 Basics of Oracle Internal Structure 9:20
lecture 48 What is a Database Control 8:24
lecture 49 How to create an user in Oracle Database 7:10
lecture 50 Default Tablespace and Temporary Tablespace for a 4:58
lecture 51 Oracle Roles and Privileges 6:32
lecture 52 Oracle System Privileges 6:22

Section 13 : Basic Oracle Database Operations

lecture 53 How to verify the Oracle Database Name 3:52
lecture 54 How to find the version of the Oracle Database 2:30
lecture 55 How to view the user accounts within an Oracle Dat 3:40
lecture 56 How to use DBA view in SQL Developer 2:28
lecture 57 How to find the tablespaces in an Oracle Databas 4:23
lecture 58 Oracle Tablespaces 7:0
lecture 59 What is an Oracle User 6:1
lecture 60 What is an Oracle Schema 9:53
lecture 61 Difference between an Oracle user and schema 4:9
lecture 62 General user architecture of a database 5:3

Section 14 : Structured Query Language (SQL)

lecture 63 SQL Structured Query Language 1:16
lecture 64 SQL CTAS method 4:34
lecture 65 SQL SELECT Statement 5:49
lecture 66 SQL INSERT Statement 3:51
lecture 67 SQL DELETE Statement 1:37
lecture 68 SQL UPDATE Statement 2:48

Section 15 : Oracle Memory and Background Processes

lecture 69 Oracle Background Processes 13:9
lecture 70 Dedicated Server vs Shared Server 9:42
lecture 71 SGA System Global Area of an Oracle Database 7:38
lecture 72 PGA Program Global Area of an Oracle Database 2:18
lecture 73 UGA User Global Area of an Oracle Database 3:45

Section 16 : SGA and Database Buffer

lecture 74 SGA Database Buffer Part 1 8:36
lecture 75 SGA Database Buffer Part 2 7:37
lecture 76 SGA Database Buffer Part 3 4:19
lecture 77 SGA Database Buffer Part 4 12:36
lecture 78 SGA Database Buffer Part 5 10:25
lecture 79 SGA Database Buffer Part 6 4:55
lecture 80 SGA Database Buffer Part 7 14:21
lecture 81 SGA Database Buffer Part 8 5:20
lecture 82 SGA Database Buffer Part 9 4:32
lecture 83 SGA Database Buffer Part 10 2:54
lecture 84 SGA Database Buffer Part 11 8:13

Section 17 : Programmable Objects

lecture 85 What is an Oracle Package 4:41
lecture 86 What is an Oracle Procedure 2:25
lecture 87 What is an Oracle Function 2:27
lecture 88 What is an Oracle Trigger 1:32
lecture 89 What is an Oracle Type 1:37

Section 18 : Oracle Backup and Recovery Concepts

lecture 90 Oracle Backup and Recovery Part 1 5:53
lecture 91 Oracle Backup and Recovery Part 2 8:12
lecture 92 Oracle Backup and Recovery Part 3 4:20

Section 19 : Oracle Database 12c

lecture 93 How to install Oracle 12c Database in Windows 7 13:9
lecture 94 Connecting to the Oracle 12c Database 17:29
lecture 95 Introduction to Oracle Enterprise Manager Express 3:57
lecture 96 Connecting to Oracle Enterprise Manager Express 9:4
lecture 97 Exploring Oracle Enterprise Manager Express 15:23
lecture 98 INSTALLATION OF ORACLE DATABASE 12C IN WINDOWS 8.1 5:11
lecture 99 INSTALLATION OF ORACLE DATABASE 12C IN WINDOWS 8.1 7:58
lecture 100 CONNECTING TO THE ORACLE 12C DATABASE IN WINDOWS 8 5:49

Section 20 : Oracle Networking

lecture 101 Oracle Networking Concepts 5:3
lecture 102 Oracle SID and Service Name 5:6
lecture 103 Oracle Listener 5:58
lecture 104 Oracle Client Side Networking
lecture 105 Naming Method 7:57

Section 21 : Diagnostic Data

lecture 106 Automatic Diagnostic Repository 5:46
lecture 107 Alert Log 2:33
lecture 108 Trace Files 3:21
lecture 109 Dump Files and Core Files 2:22
lecture 110 DDL Logs 1:31
lecture 111 ADRCI 2:47

Section 22 : LAB

lecture 112 LAB 1 - Scenario 8:43
lecture 113 LAB 2 - Connect String 3:6
lecture 114 Lab 3 - CREATE TABLESPACE 5:20
lecture 115 LAB 4 - Creating Schema User 6:39
lecture 116 LAB 5 - Logging in as the Schema user 3:26
lecture 117 LAB 6 - CREATE TABLE 5:55
lecture 118 LAB 7 - CREATE INDEX 5:20
lecture 119 LAB 8 - ALTER TABLE 2:25
lecture 120 LAB 9 - INSERT 6:32
lecture 121 LAB 10 - DELETE 3:34
lecture 122 LAB 11 - UPDATE 2:11
lecture 123 LAB 12 - Creating a ROLE 2:44
lecture 124 LAB 13 - Creating an Application use 4:35
lecture 125 LAB 14 - Testing the Application user 3:37
lecture 126 LAB 15 - Revoking the permissions 2:44
lecture 127 LAB 16 - Dropping the application user 1:37
lecture 128 LAB 17 - Dropping the Schema user 6:25
lecture 129 LAB 18 - Dropping the Tablespace 3:14

Section 23 : Conclusion

lecture 130 Conclusion 1:45

Section 24 : Extra Lectures

lecture 131 Purpose of ORACLE_BASE 7:7

Section 25 : Oracle Database Architecture - Retired

lecture 132 Overview of Oracle Database Architecture 21:12

Section 26 : How to install oracle 11g on windows 7 64 bit - Retired

lecture 133 Installation Part 1 of 5 3:5
lecture 134 Installation Part 2 of 5 0:44
lecture 135 Installation Part 3 of 5 3:38
lecture 136 Installation Part 4 of 5 8:16
lecture 137 Installation Part 5 of 5 0:48

Section 27 : Oracle Instance vs Database - Retired

lecture 138 What is an Oracle instance 3:36
lecture 139 What is an Oracle database 4:55
lecture 140 Difference between Oracle Instance and Oracle Data 2:34

Section 28 : Oracle SQL Developer - Retired

lecture 141 How to install Oracle SQL Developer in Windows 7 10:18
lecture 142 How to use Oracle SQL Developer 5:47