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
Oracle SQL for beginners
Introduction to the course and Promo video
Important stuff about the course (2:59)
Setting up the environment
Tools of the trade - Introduction (9:43)
Oracle virtual box and developer VM (3:03)
Setting up the database in the VM (15:53)
Alternatives to Virtual Machine (10:22)
(Select part 1) Let's write some SQL! Selecting data
Select statement : The very basics (16:32)
Data Types (8:34)
Aliases, Primary keys and unlocking other accounts (14:30)
(select part-2) Grants, Filters, Groups and more.
Grants/Privileges - Accessing someone else's objects (17:01)
Filtering data - "where clause" in SQL (36:02)
Groups and aggregates - part 1 (17:29)
Groups and Aggregates - Part -2 (15:01)
Sorting Data - "Order by" Clause in Oracle (17:35)
(select part-3) Oracle functions and SQL
Introduction to Oracle functions (9:04)
Character and Numeric functions in Oracle (21:04)
Date and Time functions in Oracle (21:32)
Conversion Functions in Oracle (24:48)
Null handling functions in Oracle (14:58)
Conditional Logic functions in Oracle (13:32)
Oracle Functions - Programming exercises
(Select part-4) Joins, Sub queries and more advanced SQL
Normalization (6:22)
Introduction to Joins, Inner-joins (part-1) (17:35)
Inner joins (Contd..), Self joins, and Cartesian Joins (12:45)
Outer Joins (14:28)
ANSI vs Oracle Syntax (8:22)
Joins programming exercises
Subqueries (17:04)
Set Operators (16:13)
Creating and modifying objects (DDL commands)
Introduction to DDL statements (2:52)
CREATE tables (and other objects) (13:27)
Modifying objects - the alter command (7:59)
Dropping objects (DROP Command) (6:47)
Data Manipulation - Basic DML
Transaction Control in Oracle (7:45)
the INSERT Statement (13:19)
the UPDATE Statement (17:53)
the MERGE statement (18:15)
the DELETE statement (5:40)
Oracle's TRUNCATE statement (12:35)
Subqueries
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock