Oracle Database 19c: Basic SQL

Introduction

• Learning Oracle Database SQL: Why 19c?
• What you should know

1. Client Tools

• SQL*Plus
• SQLcl
• SQL Developer

2. SELECT Statements

• Data types overview
• SELECT statement clauses
• Expressions in SELECT and WHERE clauses
• Column aliases
• Subqueries

3. Data Dictionary

• Using DESCRIBE in SQL*Plus
• Using the DDL command in SQLcl

4. String Manipulation

• Literals
• Concatenation
• Alternative quoting

5. Filtering Rows

• WHERE clause syntax
• Subqueries in the WHERE clause
• How table joins work and filter rows in the result set

6. Sorting Rows

• ORDER BY clauses
• Collation rules

7. Single-Row Functions

• Numeric functions
• Character functions returning character values
• Character functions returning numeric values
• Datetime functions
• Conversion functions
• General functions
• Listing functions with SQL Developer

8. Aggregation and Multiple-Row Functions

• GROUP BY clause
• HAVING clause
• Using DISTINCT

9. Joining Tables

• ANSI joins versus Oracle join syntax
• (INNER) JOIN
• LEFT (OUTER) JOIN
• RIGHT (OUTER) JOIN
• FULL (OUTER) JOIN
• NATURAL JOIN
• CROSS JOIN

10. Using the Oracle Data Dictionary

• Understanding the data dictionary
• Querying the data dictionary

11. DML: INSERT

• Inserting single rows
• Inserting multiple rows
• UPDATE table rows
• DELETE rows with or without WHERE

12. DDL: Creating Objects

• Creating tables
• Creating indexes
• Create Oracle specific tables

13. Dropping Objects

• Dropping tables
• Dropping indexes
• Drop Oracle specific tables

Conclusion

• Next steps