Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Master RDBMS, Querying & Data Handling with SQL
A comprehensive & detailed SQL course
Introduction to Data, Analytics & SQL (64:32)
Installation & Structure of RDBMS (66:13)
LiveSql, Schemas, Data Dictionary and Select Command (58:43)
Keywords (58:13)
Arithmatic Operations, Aliases and Concatination (61:09)
Working with Oracle Live SQL and More (62:31)
Working With Live SQL Cont...Order By & Oracle Installation (60:24)
Functions & Dual (51:48)
Functions Cont... (65:34)
User Creation & Number & Other Functions Cont... (59:46)
Date & Time, Round, Trunc & Other Functions (57:15)
Data Type Conversions (59:19)
Conversion Function Use Cases (52:31)
Joins (35:58)
Equi - Joins (61:13)
Non-Equi Joins, Inner Joins, Outer Joins (54:20)
New 9i Joins - Cross, Natural, Full Outer- Inner & More (50:35)
Aggregate Functions Or Multiple Row Functions, Group By & Order By Clause (48:21)
Nesting Of Group By Function & Sub Queries (54:29)
Sub Queries Cont... (56:22)
Single - Multiple Row Subqueries & Comparison Operators (49:37)
Multiple & Co-Related Sub Queries & Data Manipulation Language ( DML ) (53:55)
DML - Insert, Update, Delete (52:32)
DML - Create, Insert, Update, Delete Cont...... (61:40)
Auto Committ & Auto Rollback & Data Definition Language ( DDL ) (59:47)
DDL - Alter, Drop, Rename Statement (54:42)
Truncate Statement, Constraints - Not Null, Unique, Check, Primary Key, Foreign Key (52:50)
Data Dictionaries & Constraints Primary Key, Foreign Key Cont... (51:39)
Column & Table Level Constraints & Constraints Enforcing & Views (61:20)
Views, Synonyms, Sequences & Data Controlling Language ( DCL ) - Grant & Revoke Statement (39:10)
Installation & Structure of RDBMS
Complete and Continue
Discussion
0
comments
Load more
0 comments