Oracle For Noob Developers

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

Are you a developer or a database administrator curious about Oracle Database but don’t know where to start? This course is designed just for you! Whether you're completely new to databases or have worked with other systems, this course will help you build a solid foundation in Oracle from scratch.In this beginner-friendly course, we’ll walk you through the essential concepts of Oracle Database and RDMBS, including how to set up a lightweight environment using Oracle XE and Oracle SQL Developer—without overwhelming you with complex installation steps. You’ll learn about users, schemas, tables, data types, constraints, indexes, and more. We’ll also explore how to insert, update, delete, and query data using SQL, and you’ll get hands-on practice through real-world, beginner-focused examples.You’ll discover how relationships between tables work, how to use joins, and even how to create views and basic triggers. We’ll very briefly touch on functions, procedures, packages, and cursors so you know what’s possible, even though these are covered more deeply in advanced PL/SQL courses.No previous Oracle experience is required. By the end of this course, you’ll feel confident navigating Oracle as a developer and ready to dive into more advanced topics when you're ready to grow further.

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