Oracle Database 19c: Basic SQL

Oracle Database 19c: Basic SQL

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 3h 28m | 387 MB

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.

Table of Contents

Introduction
1 Learning Oracle Database SQL Why 19c
2 What you should know

Client Tools
3 SQL Plus
4 SQLcl
5 SQL Developer

SELECT Statements
6 Data types overview
7 SELECT statement clauses
8 Expressions in SELECT and WHERE clauses
9 Column aliases
10 Subqueries

Data Dictionary
11 Using DESCRIBE in SQL Plus
12 Using the DDL command in SQLcl

String Manipulation
13 Literals
14 Concatenation
15 Alternative quoting

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

Sorting Rows
19 ORDER BY clauses
20 Collation rules

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

Aggregation and Multiple-Row Functions
28 GROUP BY clause
29 HAVING clause
30 Using DISTINCT

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

Using the Oracle Data Dictionary
38 Understanding the data dictionary
39 Querying the data dictionary

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

DDL Creating Objects
44 Creating tables
45 Creating indexes

Dropping Objects
46 Dropping tables
47 Dropping indexes

Conclusion
48 Next steps