Oracle Database offers market-leading performance, scalability, reliability, and security, both on-premises and in the cloud. Oracle Database 19c is the current long term release, and it provides the highest level of release stability and longest time-frame for support and bug fixes.
Explore the most advanced features and methods for achieving maximum performance, availability, and reliability using core database technologies and features with Oracle database training and certification. Learn how to leverage enhancements in multitenant architecture, manage security, use RMAN, understand general Database Administration functionality, implement big data, and more.
Overview
The Oracle Database 19c: SQL Workshop course offers students an introduction to Oracle Database 19c database technology. In this class students learn the concepts of relational databases and the powerful SQL programming language.
This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.
Skills Covered
- You will learn about all the key elements of a database and the way Oracle systems facilitate their induction in the system.
- You will discover the tools you can use and the strategies you can implement to store, retrieve, compare and organize data according to your requirements.
- You will also learn the process of creating simple to complex reports from existing data.
Prerequisites
Basic computer skills.
Target Audience
- End users
- Business analysts
- Application developers
- Database administrators
Course Contents
1. Introduction
2. Retrieving Data Using the SQL SELECT Statement
3. Restricting and Sorting Data
4. Using Single-Row Functions to Customize Output
5. Using Conversion Functions and Conditional Expressions
6. Reporting Aggregated Data Using the Group Functions
7. Displaying Data from Multiple Tables Using Joins
8. Using Subqueries to Solve Queries
9. Using Set Operators
10. Managing Tables Using DML Statements in Oracle
11. Introduction to Data Definition Language in Oracle
12. Introduction to Data Dictionary Views
13. Creating Sequences, Synonyms, and Indexes
14. Creating Views
15. Managing Schema Objects
16. Retrieving Data by Using Subqueries
17. Manipulating Data by Using Subqueries
18. Controlling User Access
19. Manipulating Data Using Advanced Queries
20. Managing Data in Different Time Zones
21. Conclusion
Dates & Locations
July 13, 2026 - July 17, 2026
July 13, 2026 - July 17, 2026
September 7, 2026 - September 11, 2026
September 7, 2026 - September 11, 2026
November 2, 2026 - November 6, 2026
November 2, 2026 - November 6, 2026
Exam & Certification
Oracle Database 19c: SQL Workshop Certification Training Course.
Training & Certification Guide
Frequently Asked Questions
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631
