This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Getting Started With Oracle Database (SQL & PL/SQL)
Introduction to Oracle Database Course
Course Introduction (10:16)
Course Material
Introduction to DBMS
What is Database? (4:35)
Types of Databases (8:01)
Difference Between Computerized Database vs Manual Database (11:47)
How Data is Stored in Computerized Databases (6:28)
How Data is Stored in Traditional File Oriented Approach (8:36)
What is DBMS & Types of DBMS (5:07)
Features of DBMS (11:22)
Different Types of Data Models (9:55)
Introduction to Relational Model (5:25)
Terminologies Used in Relational Model (12:13)
Introduction to Database Components & Users (8:10)
Data Abstraction and Three Views of Database Schema (4:12)
Quiz - 1
Getting Started With Oracle Database
Introduction to Oracle (4:24)
Introduction to Oracle Architecture (3:33)
Setting Up Oracle Database Environment.
Downloading & Installing Oracle Database (21:19)
Download Oracle 11g
Quiz - 1
Working With SQL Command Line Interface & Unlocking HR Account (8:56)
Quiz - 2
Downloading & Installing SQL Developer (15:29)
Download SQL Developer
Quiz - 3
Addition Documentation for Getting Started Guide
Getting Started With SQL Commands
Introduction to SQL & SQL* Plus (20:17)
What is Schema & HR Schema of Oracle Database (10:15)
Classification of SQL Commands (4:36)
Quiz - 1
Getting Started With SELECT Command
Working with Select Command (9:54)
Using Select Statement to Display Selected Columns (12:30)
Arithmetic Expressions and Column Alias in Select Clause (9:24)
Concatenated Columns and Literals in Select Clause (8:12)
Working with NVL() Function (16:47)
Working with Distinct Clause (5:57)
Quiz - 1
Working with Order by clause (17:10)
Working with Where clause (13:01)
Working with SQL Operators (16:56)
Working with Logical Operators (14:06)
Quiz-2
Difference Between Computerized Database vs Manual Database
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock