Oracle Database 19c: Basic SQL
3h 36mIntermediate2023-12-21
Authors
Bob Bryla
30 years of experience in the database business
Course details
Mastering SQL is an essential skill for any Oracle professional and the first step in becoming a true Oracle expert. In this course, Bob Bryla covers the basics required to code using SQL in an Oracle 19c Database environment. Bob covers what you need to know to get data in and out of your database tables, as well as how to modify data. He explains how to leverage SELECT statements, filter and sort rows, use both single- and multiple-row functions, and join tables. He delves into the Oracle data dictionary—a set of tables that provide information about a database—and shows how to query it. Plus, he demonstrates how to efficiently delete data using DML statements. Upon wrapping up this course, you'll have the fundamental skills you need to work with SQL in this popular relational database management system.
Skills covered
Database AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsSoftware DevelopmentDeep Dive (X:Y)
Concepts
Introduction
- Learning Oracle Database SQL - Why 19c
- What you should know
Client Tools
- SQL Plus
- SQLcl
- SQL Developer
SELECT Statements
- Data types overview
- SELECT statement clauses
- Expressions in SELECT and WHERE clauses
- Column aliases
- Subqueries
Data Dictionary
- Using DESCRIBE in SQL Plus
- Using the DDL command in SQLcl
String Manipulation
- Literals
- Concatenation
- Alternative quoting
Filtering Rows
- WHERE clause syntax
- Subqueries in the WHERE clause
- How table joins work and filter rows in the result set
Sorting Rows
- ORDER BY clauses
- Collation rules
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
Aggregation and Multiple-Row Functions
- GROUP BY clause
- HAVING clause
- Using DISTINCT
Joining Tables
- ANSI joins versus Oracle join syntax
- (INNER) JOIN
- LEFT (OUTER) JOIN
- RIGHT (OUTER) JOIN
- FULL (OUTER) JOIN
- NATURAL JOIN
- CROSS JOIN
Using the Oracle Data Dictionary
- Understanding the data dictionary
- Querying the data dictionary
DML - INSERT
- Inserting single rows
- Inserting multiple rows
- UPDATE table rows
- DELETE rows with or without WHERE
DDL - Creating Objects
- Creating tables
- Creating indexes
- Create Oracle specific tables
Dropping Objects
- Dropping tables
- Dropping indexes
- Drop Oracle specific tables
Conclusion
- Next steps