Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Basic to Advanced Course
Introduction
SQL Course Overview (7:35)
Introduction to DBMS (15:01)
Types of DBMS (26:12)
What is Meta Data (11:07)
Installing Oracle (13:52)
SQL sub languages (22:29)
Oracle Data Types
SQL-Datatypes-Introduction (15:52)
character-data-types-in-oracle (19:40)
long-and-raw-datatypes (4:54)
number-data-types-in-sql (15:53)
datetime-data-types-in-sql (21:05)
Large-Object-data-types (8:01)
rowid-urowid-in-oracle (7:20)
Sub Languages with Examples
What is DDL (11:28)
create in ddl (11:10)
alter in ddl (15:18)
truncate in ddl (8:23)
rename in ddl (3:19)
drop, flashback, purge in ddl (36:57)
What is DML (7:40)
insert in DML (32:02)
update in DML (17:21)
delete in DML (6:01)
insert all in DML (18:39)
merge in DML (19:55)
DRL / DQL (34:04)
Arithmetic operators in c (5:47)
Relational Operators in SQL (5:38)
Logical Operators in SQL (7:58)
Special Operators in SQL (34:59)
Set Operators in SQL (14:59)
Concatenation Operator in SQL (2:41)
Transaction Control Language (TCL) (30:45)
Data Control Language (DCL) (28:25)
Group By, Having, Fetch, Offset Clauses
Group By Clause (28:28)
HAVING Clause (15:03)
OFFSET AND FETCH IN SQL (13:22)
Join operations in SQL
Introduction to join (27:32)
equijoin in SQL (32:15)
nonequijoin in SQL (24:47)
Outer Join in SQL (21:18)
Self Join in SQL (10:18)
Cross Join in SQL (5:17)
SubQueries in SQL
Introduction to Subqueries (16:03)
when should we use subqueries (16:09)
Types of subqueries (10:12)
Non-Correlated Subqueries (34:23)
Correlated Subqueries (17:29)
Inline-view Subqueries (5:24)
Scalar Subqueries (12:36)
Constraints in SQL
Introduction to Constraints in SQL (5:55)
Not Null Constraint in SQL (18:47)
Default Constraint in SQL (11:12)
Check Constraint in SQL (27:43)
Primary Key Constraint in SQL (34:10)
Unique Key Constraint in SQL (18:52)
Foreign Key Constraint in SQL (38:35)
Summary on Constraints (20:37)
Set Operators in SQL
Set Operators in SQL (16:45)
PL/SQL
Introduction to PL/SQL (16:28)
PL/SQL Procedures (24:52)
Variables in PL/SQL (20:11)
String Datatypes in PL/SQL (17:47)
String functions in PL/SQL (31:01)
Teach online with
String functions in PL/SQL
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock