DRL / DQL | 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)
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)

Teach online with

DRL / DQL

Lesson content locked

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

Enroll in Course to Unlock