Oracle For Noob Developers

Oracle For Noob Developers
Published 5/2025
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

Oracle for absolute Beginners

What you’ll learn

Understand the basic architecture of Oracle Database, including key concepts like instances, databases, users, schemas, and tablespaces

Write and execute SQL queries in Oracle, including SELECT, INSERT, UPDATE, DELETE, and filtering with conditions

Create and manage tables with constraints, such as primary keys, foreign keys, unique, not null, and check constraints

Work with views, indexes, joins, and triggers, and understand when and how to use them effectively in real applications

Requirements

No prior experience needed – this course is designed for absolute beginners. Just bring your curiosity and a computer!

Description

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Project 1.0

Lecture 2 What is Oracle?

Lecture 3 Relational Database Systems

Lecture 4 Preparing Practice Environment

Lecture 5 Basic Architecture

Lecture 6 Tablespace, Schema and User

Lecture 7 DML DDL

Lecture 8 How to Create a Table

Lecture 9 ID and Primary Key

Lecture 10 What does the "Alter" command?

Lecture 11 What is a Constraint

Lecture 12 Commit and Roleback

Lecture 13 Insert, Update and Delete

Lecture 14 Quary 1.0

Lecture 15 Quary 1.1

Lecture 16 What does TO_DATE() Function

Lecture 17 What is Null

Section 3: Project 1.1

Lecture 18 What is a Sequence?

Lecture 19 Relationship and Foreign Key

Lecture 20 Inner Join

Lecture 21 Left-Right-Outer Join

Lecture 22 What is the Dual Table?

Lecture 23 What does "Group by"?

Section 4: Project 1.2

Lecture 24 How to Create "View"

Lecture 25 What does an "Index"?

Lecture 26 Transaction
Lecture 27 What is a Trigger?

Lecture 28 Good Night!

Beginner Oracle Developers,Beginner Oracle Administrators