Database Concepts
- What is the Database?
- Why Oracle Database?
- What is a Table?
- Special Gifts for Our Students
- What is a Relational Database?
- Entity Relationship Logic in Databases
- What is Pluggable Database?
- The Sample (HR) Schema Used in This Course
- What is SQL?
Preparation for SQL Development
- 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 VirtualBox on Mac OS X?
- Option 2: Downloading And Installing the Oracle Database
- Option 2: Unlocking the HR Schema
- Option 2: Configuring and Using Oracle SQL Developer
- Option 3: Using Oracle Live SQL
- Option 3: About Oracle Live SQL Restrictions
Entering the Database!
- Basic SQL Statements
- SQL Coding Tips!
- Let's describe the tables!
- How to Get Data? (Select Statement)
- Aliasing The Columns
- Getting Different Rows - DISTINCT Operator!
- Concatenating The Returning Rows
- Arithmetic Expressions
- What is the NULL Value? Is it dangerous?
Conditional Retrieval
- Getting Data Just We Want - WHERE Clause!
- Comparison Operators
- Between...AND Operators
- IN Operator
- Get Me Something LIKE this
- What If Looking For Something NULL
- Logical Operators - AND, OR, NOT
Converting Data & Conversion Functions
- What is a Function?
- Why to Convert Data?
- Conversion Functions
- Converting to a Character - TO_CHAR Function
- Converting to a Date - TO_DATE Function
- NULL Value Conversion - NVL Function
Ordering The Results
- ORDER BY Clause
- ASC and DESC Operators
Single Row Functions
- About Single Row Functions
- Character Functions
- Number Functions
- Nesting Functions
- Date Functions
- DECODE Function
Grouping the data (Group Functions)
- What are group functions?
- MAX Function
- MIN Function
- Count() Function
- AVG Function
- SUM Function
Grouping the Data
- GROUP BY Clause
- HAVING Clause
Selecting From Multiple Tables (Joins)
- What is join?
- Types of Joins!
- Let's Join Tables!
- Join With USING Clause
- Join with ON Clause
- Join the table with itself!
- Joining Multiple Tables
- What are the Outer Joins?
- What are the Left Joins? (Left Outer Joins)
- What are the Right Joins? (Right Outer Joins)
- Full Outer Joins
- Cross Joins - Cartesian Product
Query inside a Query - Subqueries
- What is a subquery?
- Single Row Subqueries
- Multiple Row Subqueries
- Multiple Columns Subqueries
Combining Queries - SET Operators!
- What are SET Operators and why do we use them?
- Combine with "UNION" and "UNION ALL" Statements
- INTERSECT'ing and EXTRACT'ing Queries
- More in SET Operations
Manipulating and Playing with the Data (DML)
- What is DML and why it is used for?
- INSERTing a New Record!
- UPDATE the existing record!
- DELETE records!
- What are COMMIT and ROLLBACK Statements?
Manipulating Tables - DDL
- How to CREATE a Table With Many Ways and RENAME It?
- How to DROP an Existing Table?
- How to Add a New Column to a Table?
- How to Modify an Existing Column?
- How to Drop an Existing Column of a Table?
