udemy-the-complete-oracle-sql-bootcamp-2022-2022-4-0

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