- Thread Starter
- #1
Oracle For Noob Developers
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
rapidgator.net:
nitroflare.com:
Published 5/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 528.18 MB | Duration: 2h 9m
Oracle for absolute Beginners
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 528.18 MB | Duration: 2h 9m
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
Screenshots
rapidgator.net:
You must reply in thread to view hidden text.
nitroflare.com:
You must reply in thread to view hidden text.
