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)
Teach online with
the UPDATE Statement
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock