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

Expressions\ 1:50 Oracle Conditional Expressions DECODE Function Functions\ 11:11 Group Functions 18:52 AVG Function 28:24 COUNT Function 34:30 MAX Function 39:05 MIN Function 43:22 SUM Function 47:03 LISTAGG Function 56:59 Overview Of Group Functions Data\ 1:00:48 GROUP BY Clause (Part 1) 1:16:19 GROUP BY Clause (Part 2) 1:28:14 HAVING Clause 1:37:20 Nested Group Functions Multiple Tables\ 1:41:49 What is a Join & Oracle SQL Join Types 1:49:13 Creating a Join 1:52:14 Natural Join 2:02:33 Join with the USING Clause 2:08:16 Handling Ambiguous Column Names 2:18:43 Inner Join & Join with the ON Clause 2:26:04 Multiple Join Operations 2:38:23 Restricting Joins 2:41:54 Self Join 2:47:55 Non-Equijoins (Joining Unequal Tables) 3:01:10 OUTER JOINS 3:09:43 LEFT OUTER JOIN (LEFT JOIN) 3:23:03 RIGHT OUTER JOIN (RIGHT JOIN) 3:32:45 FULL OUTER JOIN (FULL JOIN) 3:36:50 Cross Join (Cartesian Product Cross Product) 3:54:06 Oracle’s Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1) 4:08:28 Oracle’s Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2) 4:25:01 Oracle’s Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3) 4:34:55 The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins 4:49:20 Which Join Type Should You Use 4:53:01 Entity-Relationship Models in DBMS - How to Use Them with Joins Subqueries\ 5:10:19 Using Subqueries 5:18:26 Single Row Subqueries 5:33:49 Multiple Row Subqueries 5:52:13 Multiple Column Subqueries 6:10:03 Using Subqueries as a Table 6:18:30 SCALAR Subqueries 6:34:32 Correlated Subqueries 6:51:07 EXISTS Operator & Semijoins 7:02:24 NOT EXISTS Operator with the Oracle SET Operators\ 7:08:59 Introduction to SET Operators in Oracle SQL 7:23:57 UNION and UNION ALL Operators 7:38:44 INTERSECT Operator 7:41:37 MINUS Operator 7:46:04 Matching Unmatched Queries in SET Operations 7:52:24 Using the ORDER BY Clause with SET Operators 8:00:36 Combining Multiple Queries Using the SET Operators Definition Language (DDL) Statements\ 8:07:04 Data Definition Language (DDL) 8:11:27 Naming Rules & Naming Conventions in Oracle 8:22:43 CREATE TABLE Statement 8:32:18 CREATE TABLE AS SELECT (CTAS) Statement in Oracle 8:46:08 ALTER TABLE Statement 9:05:34 Marking Columns Unused (Using The SET UNUSED Clause) 9:14:55 READ-ONLY Tables in SQL 9:22:03 DROP TABLE Statement 9:30:22 TRUNCATE TABLE Statement 9:40:44 COMMENT Statement 9:50:21 RENAME Statement Manipulation Language (DML) Statements\ 9:55:58 Data Manipulation Language (DML) 10:01:15 INSERT Statement (Part 1) 10:16:00 INSERT Statement (Part 2) 10:35:50 Multitable Insert Statements 10:38:48 Unconditional Insert Statements (INSERT ALL Statements) 10:50:03 Conditional INSERT ALL Statements 11:04:12 Conditional INSERT FIRST Statements 11:11:10 Pivoting Insert 11:21:15 UPDATE Statement 11:33:31 DELETE Statement 11:38:53 MERGE Statement 11:59:48 (TCL) Transaction Control Language & TCL Commands