Overview
-
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.
Syllabus
-
Introduction
- Learning Oracle Database SQL: Why 19c?
- What you should know
- SQL*Plus
- SQLcl
- SQL Developer
- Data types overview
- SELECT statement clauses
- Expressions in SELECT and WHERE clauses
- Column aliases
- Subqueries
- Using DESCRIBE in SQL*Plus
- Using the DDL command in SQLcl
- Literals
- Concatenation
- Alternative quoting
- WHERE clause syntax
- Subqueries in the WHERE clause
- How table joins work and filter rows in the result set
- ORDER BY clauses
- Collation rules
- Numeric functions
- Character functions returning character values
- Character functions returning numeric values
- Datetime functions
- Conversion functions
- General functions
- Listing functions with SQL Developer
- GROUP BY clause
- HAVING clause
- Using DISTINCT
- ANSI joins versus Oracle join syntax
- (INNER) JOIN
- LEFT (OUTER) JOIN
- RIGHT (OUTER) JOIN
- FULL (OUTER) JOIN
- NATURAL JOIN
- CROSS JOIN
- Understanding the data dictionary
- Querying the data dictionary
- Inserting single rows
- Inserting multiple rows
- UPDATE table rows
- DELETE rows with or without WHERE
- Creating tables
- Creating indexes
- Dropping tables
- Dropping indexes
- Next steps
