SQL - Oracle - From Beginner to Expert

39 videos • 12,783 views • by Dr. Parag Shukla This playlist is for the learners who want to learn Oracle SQL from beginning. This playlist will helpful to build skill from beginner to expert level in oracle SQL.
1
SQL- Lecture 1 - Overview SQL Statement, Constraints, Create Table
Dr. Parag Shukla
Download
2
SQL - Lecture-2 Table Naming Rules, Create Table with Default Expr, Primary Key, Not Null and Unique
Dr. Parag Shukla
Download
3
SQL - Lecture 3 - Default Expression & Check Constraints - Oracle - Practical Demonstrations
Dr. Parag Shukla
Download
4
SQL-Lecture-4 (Check Constraint - Part-2)
Dr. Parag Shukla
Download
5
SQL-Lecture-5 (Table Creation with Constraints on Contact, Email, Date-Time Validation with RegExp)
Dr. Parag Shukla
Download
6
SQL-Lecture 6 - Primary Key & Foreign Key - Practical Demonstration - Oracle
Dr. Parag Shukla
Download
7
SQL-Lecture-7 (Composite Primary Key and Composite Foreign Key with Practical Demonstrations)
Dr. Parag Shukla
Download
8
SQL-Lecture-8 (ON DELETE CASCADE/SET NULL & Use of sysdate in Check constraint - Practical Demo)
Dr. Parag Shukla
Download
9
SQL-Lecture-9 ALTER TABLE- ADD, DROP COL, ADD DROP CONSTRAINT, MODIFY STRUCTURE, RENAME COL & TABLE)
Dr. Parag Shukla
Download
10
SQL Lecture-10 (DROP, PURGE, FLASHBACK, TRUNCATE, TRUNCATE VS DELETE, INSERT ... SELECT)
Dr. Parag Shukla
Download
11
SQL-Lecture-11 (INSERT...SELECT, INSERT ALL, CONDITIONAL INSERT, COPY_TABLE, UPDATE)
Dr. Parag Shukla
Download
12
SQL-Lecture 12 - UPDATE, DELETE, COMMIT, ROLLBACK & SAVEPOINT
Dr. Parag Shukla
Download
13
SQL-Lecture-13 (DCL Statements Grant & Revoke, Table Level Privileges - Practical Demonstrations)
Dr. Parag Shukla
Download
14
SQL-Lecture-14 (DCL-Grant Revoke-Part-2) Table Level, System Level Privileges, ROLE Management
Dr. Parag Shukla
Download
15
SQL-Lecture-15 - Writing Basic SQL SELECT Statement (Practical Demonstrations)
Dr. Parag Shukla
Download
16
SQL-Lecture-16 Restricting Data using Where Clause - Demo of IN, BETWEEN AND, LIKE & IS NULL
Dr. Parag Shukla
Download
17
SQL-Lecture-17 (Restricting & Sorting Data using Where & Order by Clause)
Dr. Parag Shukla
Download
18
SQL-Lecture-18 (Introduction to Single Row Functions)
Dr. Parag Shukla
Download
19
SQL-Lecture-19 Character, Number & Date Functions
Dr. Parag Shukla
Download
20
SQL-Lecture-20 (Conversion Functions - Implicit & Explicit Function - To_Char, To_Number & To_Date)
Dr. Parag Shukla
Download
21
SQL-Lecture-21 (General Functions) NVL, NVL2, COALESCE, NULLIF, DECODE and CASE .. WHEN
Dr. Parag Shukla
Download
22
SQL Join - Part-1 (Practical Demonstrations of Inner, Left, Right, Full and Cross Join with example)
Dr. Parag Shukla
Download
23
SQL Join-Part-2 (PRACTICAL DEMONSTRATIONS OF CROSS JOIN, INNER, LEFT, RIGHT, FULL, SELF JOIN)
Dr. Parag Shukla
Download
24
SQL - Group Functions - Group By and Having (Practical Demonstrations - COUNT, MIN, MAX, AVG, SUM)
Dr. Parag Shukla
Download
25
Self Join with Practical Demonstrations and Example
Dr. Parag Shukla
Download
26
Sub Queries in SQL - Practical Demonstrations with Single Row Sub-Query and Multiple Row Sub Query
Dr. Parag Shukla
Download
27
SQL - Find Nth Highest Value for each group using RANK(), DENSE_RANK()
Dr. Parag Shukla
Download
28
SQL-Practical SET - Class Test Solution - From Create table with records to Query - Practical demo
Dr. Parag Shukla
Download
29
SQL-Practical SET-2 - Class Test Solution - From Create table with records to Query - Practical demo
Dr. Parag Shukla
Download
30
View in SQL - Simple View, Complex View, With Read Only View and With Check Option - Practical Demo
Dr. Parag Shukla
Download
31
Sequence in Oracle - Create and Alter Sequences, Insert Record using Sequence, NEXTVAL and CURRVAL
Dr. Parag Shukla
Download
32
SQL Script to Drop All the Created tables in Oracle including parent tables
Dr. Parag Shukla
Download
33
SQL Injection in Oracle with Practical Demo
Dr. Parag Shukla
Download
34
SQL Query to Display Value of Pi with 38 Digit in 20 iteration using Connect & Level - Fun with SQL
Dr. Parag Shukla
Download
35
Pivoting in SQL Oracle - Practical Demo
Dr. Parag Shukla
Download
36
Pivoting in SQL - Part 2 (Practical Demo)
Dr. Parag Shukla
Download
37
Merge Statement in SQL Oracle - Practical Demo of merging two contact tables
Dr. Parag Shukla
Download
38
Get Parts of TimeStamp like (Extract Day, Month, Year, Min, Sec) in Oracle - Practical Demo
Dr. Parag Shukla
Download
39
SQL Query to Swap content of two column using Update Statement
Dr. Parag Shukla
Download