Oracle Database 19c: Basic SQL

Learn the basics of how to code using SQL in an Oracle 19c Database environment. Learn how to get data in and out of tables, modify data, delete data, and more.

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