Concepts\
0:00 What is a Database
7:44 Why Oracle Database
14:45 What is a Table
18:25 UDEMY 101 How to Use Udemy Some Useful Tips (Do not Skip)
23:27 What is a Relational Database (RDBMS)
31:19 Entity Relationship Logic in Databases
35:06 What is Pluggable Database
38:20 Introduction to Database Objects
51:47 The Sample (HR) Schema Used in This Course
59:10 What is SQL
Download & Installation\
1:04:13 About the Database Installation
1:07:15 The Ways to Get a Database
1:22:05 Option 1 Installing VMware and VirtualBox on Windows
1:29:39 Option 1 Downloading Virtual Machine Image
1:33:51 Option 1 Configuring the VMware Virtualization Software
1:42:09 Option 1 Configuring the Oracle VirtualBox Virtualization Software
1:48:55 Option 1 Configuring SQL Developer inside of the Virtual Machine
2:01:58 Option 2 Downloading And Installing Oracle Database
2:20:17 Option 2 Unlocking the HR Schema
2:27:52 Option 2 Configuring and Using the SQL Developer
2:50:06 Option 2 Installing Sample Schemas in Oracle Database
2:57:51 Option 3 Using Oracle Live SQL
3:05:31 SQL Statements Used in This Course
Data\
3:11:01 Oracle Data Types
3:17:55 What is a NULL Value
3:23:06 DESCRIBE Command
3:27:32 INFORMATION Command
3:35:45 SQL Statement Basics
3:49:41 Oracle Error Messages
3:56:32 Using SELECT Statements
4:02:33 Using Column Aliases
4:09:59 Quote (Q) Operator
4:18:53 DISTINCT and UNIQUE Operator
4:26:35 Concatenation Operators
4:34:22 Arithmetic Expressions and NULL Values
Data\
4:44:27 Using WHERE Clause
4:49:09 Comparison Operators
4:55:42 BETWEEN … AND Operator
5:01:30 IN Operator
5:11:24 LIKE Operator
5:22:45 IS NULL Operator
5:28:07 Logical Operators (AND, OR, NOT)
5:42:30 Rules of Precedence
Data\
5:53:12 ORDER BY Clause
6:08:25 ASC and DESC Operators
6:18:20 NULLS FIRST and NULLS LAST Operators
6:22:45 ROWNUM & ROWID in SQL
6:35:31 Oracle FETCH Clause
Substitution Variables\
6:48:33 What is a Substitution Variable
7:04:24 Double Ampersand (&&) and DEFINE & UNDEFINE Commands
7:23:17 ACCEPT and PROMPT Commands
7:31:34 SET VERIFY ON SET VERIFY OFF Commands
Functions\
7:39:42 Single Row Functions
7:52:16 Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios
8:07:28 Character Functions - Character Manipulation Functios (Part 1)
8:21:56 Character Functions - Character Manipulation Functions Part 2 (INSTR Function)
8:33:02 Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions)
8:53:18 Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions)
9:04:56 Numeric Functions
9:21:28 Nested Functions
9:36:53 Date Values & Date Formats in Oracle
9:59:26 Date Functions & Arithmetic Operations on Dates
10:16:10 Date Manipulation Functions in SQL
Functions\
10:35:30 Conversion Functions
10:45:53 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)
11:03:22 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2)
11:19:39 Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions
Expressions\
11:39:26 Oracle Conditional Expressions CASE Expressions
3 views
60
20
2 years ago 00:09:22 1
How I’d Use ChatGPT to Learn to Code (If I Could Start Over)