Subscribe to the course to read this lesson
Subscribe
0 / 60
Miles
0 / 60
Assignments
0 / 60
Exams
📖 Course Miles: Passed Failed Pending Not Attempted Scroll to see all miles (60)
Mile 17: Data Type (Introduction)
Assign:
Exam:
Mile 18: Data Type (Character)
Assign:
Exam:
Mile 19: Data Type (Number)
Assign:
Exam:
Mile 20: Data Type (Date)
Assign:
Exam:
Mile 21: Data Type (Lobs and XML)
Assign:
Exam:
Mile 22: DDL (Introduction)
Assign:
Exam:
Mile 23: DDL (Create)
Assign:
Exam:
Mile 24: DDL (Alter)
Assign:
Exam:
Mile 25: DDL (Drop and Truncate)
Assign:
Exam:
Mile 26: DDL (View)
Assign:
Exam:
Mile 27: DDL (Synonym)
Assign:
Exam:
Mile 28: DDL (Sequence)
Assign:
Exam:
Mile 29: DML (Introduction)
Assign:
Exam:
Mile 30: DML(Insert)
Assign:
Exam:
Mile 31: DML(Update)
Assign:
Exam:
Mile 32: DML(Delete)
Assign:
Exam:
Mile 33: DML(Merge)
Assign:
Exam:
Mile 34: DDL vs DML
Assign:
Exam:
Mile 35: Delete vs Truncate
Assign:
Exam:
Mile 36: DCL (Introduction)
Assign:
Exam:
Mile 37: DCL (Commands)
Assign:
Exam:
Mile 38: TCL (Introduction)
Assign:
Exam:
Mile 39: TCL (Commands)
Assign:
Exam:
Mile 40: Single Row Function (Substr)
Assign:
Exam:
Mile 41: Single Row Function (Instr)
Assign:
Exam:
Mile 42: Single Row Function (Length)
Assign:
Exam:
Mile 43: Single Row Function (Replace)
Assign:
Exam:
Mile 44: Single Row Function (Translate)
Assign:
Exam:
Mile 45: Single Row Function (Concat)
Assign:
Exam:
Mile 46: Single Row Function (ABS)
Assign:
Exam:
Mile 47: Single Row Function (Round)
Assign:
Exam:
Mile 48: Single Row Function (Trunc)
Assign:
Exam:
Mile 49: Single Row Function (Mod)
Assign:
Exam:
Mile 50: Single Row Function (Ceil)
Assign:
Exam:
Mile 51: Single Row Function (Floor)
Assign:
Exam:
Mile 52: Single Row Function (NVL)
Assign:
Exam:
Mile 53: Single Row Function (Coalesce)
Assign:
Exam:
Mile 54: Single Row Function (NULLIF)
Assign:
Exam:
Mile 55: Single Row Function (NVL2)
Assign:
Exam:
Mile 56: Single Row Function (Decode)
Assign:
Exam:
Mile 57: Single Row Function (Case)
Assign:
Exam:
Mile 58: Single Row Function (ADD_MONTHS)
Assign:
Exam:
Mile 59: Single Row Function (MONTHS_BETWEEN)
Assign:
Exam:
Mile 60: Single Row Function (LAST_DAY)
Assign:
Exam:
Mile 61: Single Row Function (TO_CHAR)
Assign:
Exam:
Mile 62: Single Row Function (TO_NUMBER)
Assign:
Exam:
Mile 63: Single Row Function (TO_DATE)
Assign:
Exam:
Mile 65: Join (Introduction)
Assign:
Exam:
Mile 66: Join (Syntax)
Assign:
Exam:
Mile 67: Join (Practice)
Assign:
Exam:
Mile 68: Join (Advance)
Assign:
Exam:
Mile 69: Join (OLD Syntax)
Assign:
Exam:
Mile 70: Join (OLD Syntax practice)
Assign:
Exam:
Mile 71: Join Advance (Multi join)
Assign:
Exam:
Mile 72: Aggregate - Introduction
Assign:
Exam:
Mile 73: Aggregate - Syntax
Assign:
Exam:
Mile 74: Aggregate - Practice 1
Assign:
Exam:
Mile 75: Aggregate - Practice 2
Assign:
Exam:
Mile 76: Road Test -2
Assign:
Exam:
🎬 YouTube Videos
No YouTube videos available
Check back later for new YouTube content.
📹 Library Videos
📚 Content
SECTION 1 ABOUT SQL JOURNEY
SECTION 2 ABOUT TODAY'S JOURNEY
Subscribe to the course to read this lesson
Subscribe
SECTION 3 NVL
Subscribe to the course to read this lesson
Subscribe
SECTION 4 SYNTAX
Subscribe to the course to read this lesson
Subscribe
SECTION 5 EXAMPLE
Subscribe to the course to read this lesson
Subscribe
📝 Assignment
Available Assignments
| Assignment | Pass Mark | Duration | Actions |
|---|---|---|---|
|
Single Row Function (NVL)
|
70% | 01:00:00 |
📊 Exam
Available Exams
| Exam | Pass Mark | Duration | Questions | Actions |
|---|---|---|---|---|
|
Single Row Function (NVL)
|
70% | 00:30:00 | All |
💬 Comments & Discussion
Subscribe to the course to read comments for this mile.