Database Concepts
  • What is a Database?
  • Why Oracle Database?
  • What is a Table?
  • UDEMY 101: How to Use Udemy? +Some Useful Tips (Do not Skip)
  • Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples)
  • What is a Relational Database (RDBMS)?
  • Entity Relationship Logic in Databases
  • What is Pluggable Database?
  • Introduction to Database Objects
  • The Sample (HR) Schema Used in This Course
  • What is SQL?
  • Section 1 : Quiz
Software Download & Installation
  • About the Database Installation
  • Which Option to Choose to Have a Database?
  • Option 1: Having the Database with the Oracle Virtual Box
  • Option 1: How to Install the Virtual Box on Mac OS X?
  • Option 2: Downloading And Installing Oracle Database
  • Option 2: Unlocking the HR Schema
  • Option 2: Configuring and Using the SQL Developer
  • Option 3 : Using Oracle Live SQL
  • Option 3: Warning About Oracle Live SQL Limitations
  • SQL Statements Used in This Course
  • The Working Document
  • Don't Forget to Leave a Rating!
Retrieving Data
  • Oracle Data Types
  • What is a NULL Value?
  • DESCRIBE Command
  • INFORMATION Command
  • SQL Statement Basics
  • Oracle Error Messages
  • Using SELECT Statements
  • CODE: Using SELECT Statements
  • Using Column Aliases
  • CODE: Using Column Aliases
  • Quote (Q) Operator
  • DISTINCT and UNIQUE Operator
  • Concatenation Operators
  • Arithmetic Expressions and NULL Values
  • Section 2 : Quiz
Restricting Data
  • Using WHERE Clause
  • Comparison Operators
  • BETWEEN … AND Operator
  • IN Operator
  • LIKE Operator
  • IS NULL Operator
  • Logical Operators (AND, OR, NOT)
  • Rules of Precedence
  • Quiz
  • Section 3 : Quiz
Sorting Data
  • ORDER BY Clause
  • ASC and DESC Operators
  • NULLS FIRST and NULLS LAST Operators
  • ROWNUM & ROWID in SQL
  • Oracle FETCH Clause
  • Section 4 : Quiz
Using Substitution Variables
  • What is a Substitution Variable?
  • Double Ampersand (&&) and DEFINE & UNDEFINE Commands
  • ACCEPT and PROMPT Commands
  • SET VERIFY ON / SET VERIFY OFF Commands
Single-Row Functions
  • Single Row Functions
  • Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios
  • Character Functions - Character Manipulation Functios (Part 1)
  • Character Functions - Character Manipulation Functions Part 2 (INSTR Function)
  • Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions)
  • Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions)
  • Numeric Functions
  • Nested Functions
  • Date Values & Date Formats in Oracle
  • Date Functions & Arithmetic Operations on Dates
  • Date Manipulation Functions in SQL
  • Section 5 : Quiz
Conversion Functions
  • Conversion Functions
  • TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)
  • TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2)
  • Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions
  • Section 6 : Quiz
Conditional Expressions
  • Oracle Conditional Expressions: CASE Expressions
  • Oracle Conditional Expressions: DECODE Function
  • Section 7 : Quiz
Group Functions
  • Group Functions
  • AVG Function
  • COUNT Function
  • MAX Function
  • MIN Function
  • SUM Function
  • LISTAGG Function
  • Overview Of Group Functions
  • Section 8 : Quiz
Grouping Data
  • GROUP BY Clause (Part 1)