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

0. Introduction

01 - Learning Oracle Database SQL - Why 19c
02 - What you should know

1. Client Tools

03 - SQL Plus
04 - SQLcl
05 - SQL Developer

2. SELECT Statements

06 - Data types overview
07 - SELECT statement clauses
08 - Expressions in SELECT and WHERE clauses
09 - Column aliases
10 - Subqueries

3. Data Dictionary

11 - Using DESCRIBE in SQL Plus
12 - Using the DDL command in SQLcl

4. String Manipulation

13 - Literals
14 - Concatenation
15 - Alternative quoting

5. Filtering Rows

16 - WHERE clause syntax
17 - Subqueries in the WHERE clause
18 - How table joins work and filter rows in the result set

6. Sorting Rows

19 - ORDER BY clauses
20 - Collation rules

7. Single-Row Functions

21 - Numeric functions
22 - Character functions returning character values
23 - Character functions returning numeric values
24 - Datetime functions
25 - Conversion functions
26 - General functions
27 - Listing functions with SQL Developer

8. Aggregation and Multiple-Row Functions

28 - GROUP BY clause
29 - HAVING clause
30 - Using DISTINCT

9. Joining Tables

31 - ANSI joins versus Oracle join syntax
32 - (INNER) JOIN
33 - LEFT (OUTER) JOIN
34 - RIGHT (OUTER) JOIN
35 - FULL (OUTER) JOIN
36 - NATURAL JOIN
37 - CROSS JOIN

10. Using the Oracle Data Dictionary

38 - Understanding the data dictionary
39 - Querying the data dictionary

11. DML - INSERT

40 - Inserting single rows
41 - Inserting multiple rows
42 - UPDATE table rows
43 - DELETE rows with or without WHERE

12. DDL - Creating Objects

44 - Creating tables
45 - Creating indexes
46 - Create Oracle specific tables

13. Dropping Objects

47 - Dropping tables
48 - Dropping indexes
49 - Drop Oracle specific tables

Conclusion

50 - Next steps