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
Resolve the captcha to access the links!