long-and-raw-datatypes | TELUGUWEBGURU

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)
number-data-types-in-sql (15:53)
long-and-raw-datatypes (4:54)
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)
Number Datatypes in PL/SQL (8:12)
Number related Functions (43:13)
Date Datatypes in PL/SQL (11:14)
Date Functions in PL/SQL (20:17)
How to read input from user in PL/SQL (10:21)
%TYPE and %ROWTYPE in PL/SQL (21:18)
Control Statements in PL/SQL (9:38)
If Statement in PL/SQL (36:57)
Case in PL/SQL (20:26)
For loop in PL/SQL (30:40)
While and Simple Loops (18:45)
Introduction to Cursors (15:03)
Implementing Cursors in PL/SQL (44:23)
Ref Cursors in PL/SQL (8:49)
Error Handling in PL/SQL (48:40)

Teach online with

long-and-raw-datatypes

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock