Section 1 : Introduction to Database
|
|
Lecture 1 | What is a Database | 00:03:56 Duration |
Section 2 : Introduction to Database Objects
|
|
Lecture 1 | What is a Table | 00:06:25 Duration |
|
|
Lecture 2 | Table - Additional Details | 00:07:05 Duration |
Section 3 : Database Languages
|
|
Lecture 1 | Data Definition Language | 00:04:22 Duration |
|
|
Lecture 2 | Data Definition Language - Recap | 00:02:02 Duration |
|
|
Lecture 3 | Data Manipulation Language | |
|
|
Lecture 4 | Data Control Language | 00:02:17 Duration |
Section 4 : Database Objects - Index and View
|
|
Lecture 1 | What is an index | 00:09:28 Duration |
|
|
Lecture 2 | What is a View | 00:03:54 Duration |
Section 5 : Relational DBMS (RDBMS) - Introduction
|
|
Lecture 1 | What is a Foreign Key | 00:06:14 Duration |
|
|
Lecture 2 | What is a RDBMS | 00:04:35 Duration |
|
|
Lecture 3 | What is a Primary Key | 00:04:01 Duration |
|
|
Lecture 4 | What is an Unique Key | 00:03:20 Duration |
|
|
Lecture 5 | What is the difference between Primary Key and Uni | 00:02:21 Duration |
Section 6 : Computers and Databases
|
|
Lecture 1 | Computers and Databases | 00:04:34 Duration |
|
|
Lecture 2 | What is Data Concurrency | |
|
|
Lecture 3 | What is Data Consistency | 00:02:31 Duration |
Section 7 : Installing Oracle 12c in Windows 10
|
|
Lecture 1 | Download and Install Oracle 12c in a Windows PC or | 00:11:58 Duration |
|
|
Lecture 2 | Optional - Install Oracle 12c with Multitenancy | 00:12:11 Duration |
|
|
Lecture 3 | Using Oracle SQL Developer | 00:02:11 Duration |
|
|
Lecture 4 | Troubleshooting Connection Issues |
Section 8 : Concepts Illustrated
|
|
Lecture 1 | Oracle Instance vs Database | 00:06:13 Duration |
|
|
Lecture 2 | Installation | 00:02:24 Duration |
|
|
Lecture 3 | Files | 00:01:13 Duration |
|
|
Lecture 4 | Starting a Database | 00:02:30 Duration |
|
|
Lecture 5 | Basics of Computing | 00:04:52 Duration |
|
|
Lecture 6 | Client Server Architecture | 00:08:02 Duration |
|
|
Lecture 7 | PGA - Program Global Area | 00:04:58 Duration |
|
|
Lecture 8 | Dedicated Server Mode | 00:01:35 Duration |
|
|
Lecture 9 | Shared Server Mode | 00:08:55 Duration |
Section 9 : Oracle Storage Structures
|
|
Lecture 1 | Oracle Physical Storage Structures | 00:04:38 Duration |
|
|
Lecture 2 | Oracle Logical Data Structures | 00:01:56 Duration |
|
|
Lecture 3 | Where can the Oracle Physical Structure files be s | 00:03:29 Duration |
|
|
Lecture 4 | What is a Raw Device | |
|
|
Lecture 5 | What is a File System | 00:03:54 Duration |
|
|
Lecture 6 | What is an Oracle ASM | 00:03:05 Duration |
|
|
Lecture 7 | What is a Cluster File System | 00:04:24 Duration |
Section 10 : Oracle Parameter Files
|
|
Lecture 1 | What is a Parameter file | 00:01:43 Duration |
|
|
Lecture 2 | What is a SPFILE | 00:02:29 Duration |
|
|
Lecture 3 | What is a PFILE | 00:02:50 Duration |
Section 11 : Connecting to an Oracle Database
|
|
Lecture 1 | How to connect to a Oracle Database | 00:11:50 Duration |
|
|
Lecture 2 | How does an Oracle database start | 00:11:45 Duration |
|
|
Lecture 3 | Demo of various starting methods of an Oracle data | 00:20:29 Duration |
|
|
Lecture 4 | How to log in to an Oracle Database | 00:03:41 Duration |
|
|
Lecture 5 | Oracle Database Dictionary | 00:07:32 Duration |
|
|
Lecture 6 | How to log in to an Oracle Database - Answer Video | 00:03:58 Duration |
Section 12 : Basics of Oracle Database Internals and Security
|
|
Lecture 1 | Basics of Oracle Internal Structure | 00:09:20 Duration |
|
|
Lecture 2 | What is a Database Control | 00:08:24 Duration |
|
|
Lecture 3 | How to create an user in Oracle Database | 00:07:10 Duration |
|
|
Lecture 4 | Default Tablespace and Temporary Tablespace for a | 00:04:58 Duration |
|
|
Lecture 5 | Oracle Roles and Privileges | 00:06:32 Duration |
|
|
Lecture 6 | Oracle System Privileges | 00:06:22 Duration |
Section 13 : Basic Oracle Database Operations
|
|
Lecture 1 | How to verify the Oracle Database Name | 00:03:52 Duration |
|
|
Lecture 2 | How to find the version of the Oracle Database | 00:02:30 Duration |
|
|
Lecture 3 | How to view the user accounts within an Oracle Dat | 00:03:40 Duration |
|
|
Lecture 4 | How to use DBA view in SQL Developer | 00:02:28 Duration |
|
|
Lecture 5 | How to find the tablespaces in an Oracle Databas | 00:04:23 Duration |
|
|
Lecture 6 | Oracle Tablespaces | 00:07:00 Duration |
|
|
Lecture 7 | What is an Oracle User | 00:06:01 Duration |
|
|
Lecture 8 | What is an Oracle Schema | 00:09:53 Duration |
|
|
Lecture 9 | Difference between an Oracle user and schema | 00:04:09 Duration |
|
|
Lecture 10 | General user architecture of a database | 00:05:03 Duration |
Section 14 : Structured Query Language (SQL)
|
|
Lecture 1 | SQL Structured Query Language | 00:01:16 Duration |
|
|
Lecture 2 | SQL CTAS method | 00:04:34 Duration |
|
|
Lecture 3 | SQL SELECT Statement | 00:05:49 Duration |
|
|
Lecture 4 | SQL INSERT Statement | 00:03:51 Duration |
|
|
Lecture 5 | SQL DELETE Statement | 00:01:37 Duration |
|
|
Lecture 6 | SQL UPDATE Statement | 00:02:48 Duration |
Section 15 : Oracle Memory and Background Processes
|
|
Lecture 1 | Oracle Background Processes | 00:13:09 Duration |
|
|
Lecture 2 | Dedicated Server vs Shared Server | 00:09:42 Duration |
|
|
Lecture 3 | SGA System Global Area of an Oracle Database | 00:07:38 Duration |
|
|
Lecture 4 | PGA Program Global Area of an Oracle Database | 00:02:18 Duration |
|
|
Lecture 5 | UGA User Global Area of an Oracle Database | 00:03:45 Duration |
Section 16 : SGA and Database Buffer
|
|
Lecture 1 | SGA Database Buffer Part 1 | 00:08:36 Duration |
|
|
Lecture 2 | SGA Database Buffer Part 2 | 00:07:37 Duration |
|
|
Lecture 3 | SGA Database Buffer Part 3 | 00:04:19 Duration |
|
|
Lecture 4 | SGA Database Buffer Part 4 | 00:12:36 Duration |
|
|
Lecture 5 | SGA Database Buffer Part 5 | 00:10:25 Duration |
|
|
Lecture 6 | SGA Database Buffer Part 6 | 00:04:55 Duration |
|
|
Lecture 7 | SGA Database Buffer Part 7 | 00:14:21 Duration |
|
|
Lecture 8 | SGA Database Buffer Part 8 | 00:05:20 Duration |
|
|
Lecture 9 | SGA Database Buffer Part 9 | 00:04:32 Duration |
|
|
Lecture 10 | SGA Database Buffer Part 10 | 00:02:54 Duration |
|
|
Lecture 11 | SGA Database Buffer Part 11 | 00:08:13 Duration |
Section 17 : Programmable Objects
|
|
Lecture 1 | What is an Oracle Package | 00:04:41 Duration |
|
|
Lecture 2 | What is an Oracle Procedure | 00:02:25 Duration |
|
|
Lecture 3 | What is an Oracle Function | 00:02:27 Duration |
|
|
Lecture 4 | What is an Oracle Trigger | 00:01:32 Duration |
|
|
Lecture 5 | What is an Oracle Type | 00:01:37 Duration |
Section 18 : Oracle Backup and Recovery Concepts
|
|
Lecture 1 | Oracle Backup and Recovery Part 1 | 00:05:53 Duration |
|
|
Lecture 2 | Oracle Backup and Recovery Part 2 | 00:08:12 Duration |
|
|
Lecture 3 | Oracle Backup and Recovery Part 3 | 00:04:20 Duration |
Section 19 : Oracle Database 12c
|
|
Lecture 1 | How to install Oracle 12c Database in Windows 7 | 00:13:09 Duration |
|
|
Lecture 2 | Connecting to the Oracle 12c Database | 00:17:29 Duration |
|
|
Lecture 3 | Introduction to Oracle Enterprise Manager Express | 00:03:57 Duration |
|
|
Lecture 4 | Connecting to Oracle Enterprise Manager Express | 00:09:04 Duration |
|
|
Lecture 5 | Exploring Oracle Enterprise Manager Express | 00:15:23 Duration |
|
|
Lecture 6 | INSTALLATION OF ORACLE DATABASE 12C IN WINDOWS 8.1 | 00:05:11 Duration |
|
|
Lecture 7 | INSTALLATION OF ORACLE DATABASE 12C IN WINDOWS 8.1 | 00:07:58 Duration |
|
|
Lecture 8 | CONNECTING TO THE ORACLE 12C DATABASE IN WINDOWS 8 | 00:05:49 Duration |
Section 20 : Oracle Networking
|
|
Lecture 1 | Oracle Networking Concepts | 00:05:03 Duration |
|
|
Lecture 2 | Oracle SID and Service Name | 00:05:06 Duration |
|
|
Lecture 3 | Oracle Listener | 00:05:58 Duration |
|
|
Lecture 4 | Oracle Client Side Networking | |
|
|
Lecture 5 | Naming Method | 00:07:57 Duration |
Section 21 : Diagnostic Data
|
|
Lecture 1 | Automatic Diagnostic Repository | 00:05:46 Duration |
|
|
Lecture 2 | Alert Log | 00:02:33 Duration |
|
|
Lecture 3 | Trace Files | 00:03:21 Duration |
|
|
Lecture 4 | Dump Files and Core Files | 00:02:22 Duration |
|
|
Lecture 5 | DDL Logs | 00:01:31 Duration |
|
|
Lecture 6 | ADRCI | 00:02:47 Duration |
Section 22 : LAB
|
|
Lecture 1 | LAB 1 - Scenario | 00:08:43 Duration |
|
|
Lecture 2 | LAB 2 - Connect String | 00:03:06 Duration |
|
|
Lecture 3 | Lab 3 - CREATE TABLESPACE | 00:05:20 Duration |
|
|
Lecture 4 | LAB 4 - Creating Schema User | 00:06:39 Duration |
|
|
Lecture 5 | LAB 5 - Logging in as the Schema user | 00:03:26 Duration |
|
|
Lecture 6 | LAB 6 - CREATE TABLE | 00:05:55 Duration |
|
|
Lecture 7 | LAB 7 - CREATE INDEX | 00:05:20 Duration |
|
|
Lecture 8 | LAB 8 - ALTER TABLE | 00:02:25 Duration |
|
|
Lecture 9 | LAB 9 - INSERT | 00:06:32 Duration |
|
|
Lecture 10 | LAB 10 - DELETE | 00:03:34 Duration |
|
|
Lecture 11 | LAB 11 - UPDATE | 00:02:11 Duration |
|
|
Lecture 12 | LAB 12 - Creating a ROLE | 00:02:44 Duration |
|
|
Lecture 13 | LAB 13 - Creating an Application use | 00:04:35 Duration |
|
|
Lecture 14 | LAB 14 - Testing the Application user | 00:03:37 Duration |
|
|
Lecture 15 | LAB 15 - Revoking the permissions | 00:02:44 Duration |
|
|
Lecture 16 | LAB 16 - Dropping the application user | 00:01:37 Duration |
|
|
Lecture 17 | LAB 17 - Dropping the Schema user | 00:06:25 Duration |
|
|
Lecture 18 | LAB 18 - Dropping the Tablespace | 00:03:14 Duration |
Section 23 : Conclusion
|
|
Lecture 1 | Conclusion | 00:01:45 Duration |
Section 24 : Extra Lectures
|
|
Lecture 1 | Purpose of ORACLE_BASE | 00:07:07 Duration |
Section 25 : Oracle Database Architecture - Retired
|
|
Lecture 1 | Overview of Oracle Database Architecture | 00:21:12 Duration |
Section 26 : How to install oracle 11g on windows 7 64 bit - Retired
|
|
Lecture 1 | Installation Part 1 of 5 | 00:03:05 Duration |
|
|
Lecture 2 | Installation Part 2 of 5 | 00:00:44 Duration |
|
|
Lecture 3 | Installation Part 3 of 5 | 00:03:38 Duration |
|
|
Lecture 4 | Installation Part 4 of 5 | 00:08:16 Duration |
|
|
Lecture 5 | Installation Part 5 of 5 | 00:00:48 Duration |
Section 27 : Oracle Instance vs Database - Retired
|
|
Lecture 1 | What is an Oracle instance | 00:03:36 Duration |
|
|
Lecture 2 | What is an Oracle database | 00:04:55 Duration |
|
|
Lecture 3 | Difference between Oracle Instance and Oracle Data | 00:02:34 Duration |
Section 28 : Oracle SQL Developer - Retired
|
|
Lecture 1 | How to install Oracle SQL Developer in Windows 7 | 00:10:18 Duration |
|
|
Lecture 2 | How to use Oracle SQL Developer | 00:05:47 Duration |
