This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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
Lesson 8 - SELECT Statements
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock