Author
Released
3/24/2020Skill Level Intermediate
Duration
Views
- [Bob] Oracle Database 19c is a new milestone over its long history of innovation. It can be an autonomous database for both data warehouse and OLTP workloads, which makes the DBA's job easier than before. It lets them work more on the design, development and implementation side of Oracle Database, instead of constantly trying to tune or debug issues when the database is slow. By covering the basics of Oracle Database 19c SQL, from select to truncate, you'll be able to get your data out of your database tables with select, and get data in, modify data, and often delete data with DML statements in the most efficient way possible. Hi, I'm Bob Bryla, and I'm an Oracle Database administrator by day and also by night. I see everyday how Oracle databases help businesses be successful, and with Oracle's cloud-based engineered system like exit data do so cost-effectively. I invite you to join my LinkedIn Learning course on Oracle Database 19c: Basic SQL.
Related Courses
-
Relational Databases Essential Training
with Adam Wilbert2h 12m Intermediate -
Database Foundations: Core Concepts
with Adam Wilbert2h 14m Beginner -
Database Foundations: Administration
with Adam Wilbert1h 14m Beginner
-
Introduction
-
What you should know2m 1s
-
1. Client Tools
-
2. SELECT Statements
-
Data types overview5m 21s
-
SELECT statement clauses2m 53s
-
Column aliases4m 9s
-
Subqueries3m 55s
-
-
3. Data Dictionary
-
4. String Manipulation
-
Literals6m 53s
-
Concatenation3m 38s
-
Alternative quoting4m 15s
-
-
5. Filtering Rows
-
WHERE clause syntax5m 36s
-
-
6. Sorting Rows
-
ORDER BY clauses4m 11s
-
Collation rules4m 5s
-
-
7. Single-Row Functions
-
Numeric functions3m 12s
-
Datetime functions5m 12s
-
Conversion functions5m 26s
-
General functions3m 48s
-
-
8. Aggregation and Multiple-Row Functions
-
GROUP BY clause6m 6s
-
HAVING clause1m 38s
-
Using DISTINCT6m 42s
-
-
9. Joining Tables
-
(INNER) JOIN3m 46s
-
LEFT (OUTER) JOIN4m 41s
-
RIGHT (OUTER) JOIN4m 38s
-
FULL (OUTER) JOIN3m 21s
-
NATURAL JOIN4m 35s
-
CROSS JOIN3m
-
10. Using the Oracle Data Dictionary
-
Querying the data dictionary5m 13s
-
11. DML: INSERT
-
Inserting single rows4m 11s
-
Inserting multiple rows7m 58s
-
UPDATE table rows4m 18s
-
-
12. DDL: Creating Objects
-
Creating tables5m 21s
-
Creating indexes5m 27s
-
-
13. Dropping Objects
-
Dropping tables4m 51s
-
Dropping indexes3m 58s
-
-
Conclusion
-
Next steps41s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Learning Oracle Database SQL: Why 19c?