Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Developer in 30 days
30 Days Action Plan
30 Days Action Plan
Day 1
Lesson 1 - Introduction about Oracle (6:16)
Lesson 2 - Oracle 12c Architecture (6:33)
Quize - Introduction
3.1 - Local Installation on Windows
3.2 - Live Installation
3.3 - Connecting to Oracle 12c Data Base in Windows
Day 2
Lesson 4 - Entity Relationship Diagram (ERD) Diagram (7:47)
Lesson 5 - Data Definition Language (DDL) Statements (16:00)
Quiz - DDL
Oracle_12c Scripts
Day 3
Lesson 6 -Data Types (15:57)
Quiz - Data Types
Day 4
Lesson 7 - Data Manipulation Language (DML) Statments (16:33)
Quiz - DML Statements
Lesson 8 - SELECT Statements (7:27)
Lesson 9 - Capabilities of Select Statements (2:42)
Lesson 9 a - Constraints in Oracle-Part 1 (52:10)
Lesson 9 b - Constraints in Oracle - Part 2 (48:51)
Quiz - SELECT Statements
Day 5
Lesson 10 -Where Clause (19:56)
Lesson 11 - Boolean Operator (15:01)
Limit the rows -Quiz
Day 6
Lesson 12 - Order by Clause (25:55)
Order by -Quiz
Day 7
Lesson 13 - Single, Double Ambersamp (8:08)
Lesson 14 - Define Undefine (6:57)
Quiz - Substitution Variable
Lesson 15 - Fetch Clause (10:22)
Quiz - FETCH CLAUSE
Day 8
Lesson 16 - What is Single Row Function? (1:05)
Lesson 17 - Lpad and Rpad (8:08)
Lesson 18 - Character Single Row Function (Part 1) (UPPER, LOWER, INITCAP, CONCAT, LENGTH,) (9:41)
Lesson 19 - Character Single Row Function (Part 2) (INSTR SUBSTR) (17:50)
Day 9
Lesson 20- Number Single Row Function (12:04)
Lesson 21 - Date Single Row function Part 1 (16:34)
Lesson 22 - Date Single row part 2 (11:21)
Day 10
Lesson 23 - Time Stamp Functions (4:29)
Lesson 24- Time Zone functions (10:25)
Lesson 25 - Timesstamp Extraction (4:50)
Lesson 26 - TimeZone Conversion (6:09)
Lesson 27 - At Timezone (5:11)
Day 11
Lesson 28- Nesting Function (11:22)
Lesson 29 - Other Functions (17:43)
Quiz - Single Row Function
Day 12
Lesson 30 - Group Function Part 1 (15:39)
Lesson 31 - Group Function Part 2 (18:27)
Quiz - Multiple Row function
Day 13 - Retrieving Datas from more than One Table
Lesson 32 - Joins (18:29)
Lesson 33 - LEFT and RIGHT JOIN (10:53)
Day 14
Lesson 34 - Full Outer Joins (2:06)
Lesson 35 - Using Clause (0:52)
Lesson 36 - Multi Table Join (6:01)
Lesson 37 - Non Equi Join (7:18)
Quiz- JOINS
Day 15 Exam
Exam
Day 16
Lesson 38 - Sub Quiries (3:10)
Lesson 39 - Single Row Sub Query (4:54)
Lesson 40 - Multiple Row subquery (4:03)
Lesson 41 - Multiple Column Subquery (2:34)
Lesson 42 - Scalar SubQuery (4:08)
Day 17
Lesson 43 - Correlated Subsquery (13:41)
Lesson 44 - Exist and Non Exist (4:32)
Lesson 45 - With Clause (9:10)
Quiz-Subqueries
Day 18 Creating Other Schema Objects
Lesson 46 - views (4:25)
Lesson 47 - Creation of Views (18:27)
Lesson 48 - Synonyms (6:22)
Day 19
Lesson 49 - Indexes (14:08)
Lesson 50 - Sequences (14:04)
Creating Other Schema objects -Quiz
Day 20 Managing Schema Objects
Lesson 51 - Adding the Column 1 (4:10)
Lesson 52 - Adding the Column with constraint (3:34)
Lesson 53 - Dropping the Column (11:14)
Lesson 54 - Dropping the Column with Constraint (7:35)
Day 21
Lesson 55 - Dropping Constraints (5:56)
Lesson 56 - Set the Column Unused (7:14)
Lesson 57 - Enable and Disable th econstraint (11:04)
Day 22
Lesson 58 - On Delete Cascade and Set Null (7:15)
Lesson 59 - Deferrable and Immediate (5:35)
Lesson 60 - Rename the Column and Constraints (2:25)
Managing Schema Objects -Quiz
Day 23 Set Operators
Lesson 61 - Set Operators Intro (1:05)
Lesson 62 - UNION (6:37)
Lesson 63 - UNION ALL (2:05)
Lesson 64 - INTERESECT (2:32)
Lesson 65 - MINUS (2:54)
Lesson 66 - Set Operators_Order by Clause (5:22)
Lesson 67 - Set Operators_Column Alias (4:53)
Quiz - Set Operators
Day 24 Data Dictionary Views
Lesson 68 - Data Dictionery Views (5:39)
Lesson 69 - Adding comments for tables and columns (5:27)
Lesson 70 - USER_CATALOGUE AND USER_OBJECTS (3:06)
Lesson 71 -USER_CONSTRAINTS USER_CONS_COLUMNS FINDING TABLE WITH (5:07)
Data dictionary view -Quiz
Day 25 - Manipulating Large Data Sets
Lesson 72 - CTAS Command (10:07)
Lesson 73 - Insert Statement with sub Query (3:59)
Lesson 74 - Correlated Sub Quries (12:46)
Day 26
Lesson 75 - Unconditional Multi Table Inserts (8:48)
Lesson 76 - Conditional Multi Table Insert (6:48)
Lesson 77 - Merge Statements (7:39)
Manipulating Large Data sets -Quiz
Day 27 - Controlling User Access
Lesson 78 - Introduction about system and object privileges (4:47)
Lesson 79 - System Privileges (13:27)
Lesson 80 - System Privileges with Admin Opition (4:42)
Day 28
Lesson 81 - Object Privileges (14:01)
Lesson 82 - Roles (6:36)
Lesson 83 - Distinguish between Privileges and Roles (5:03)
Controlling User Access -Quiz
Bonus - Most Recommended
DUMPS - MOST RECOMMENDED
Bonus - SQL Interview Questions and Answers
Day 29 - Exam 15 to 21 Chapters
Exam 15 to 21 Chapters
Day 30 - Final Exam
Final Exam
SQL_projects_exercise
SQL_Projects
30 Days Action Plan
Complete and Continue