Oracle Database SQL 19c

Oracle Database SQL 19c

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.

Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle database. Application programs and Oracle tools often allow users access to the database without using SQL directly, but these applications in turn must use SQL when executing the user’s request.

---

Key Learnings:

• Master SQL syntax and logic using Oracle 19c

• Retrieve and analyze data using joins and subqueries

• Manage schema objects, users, and constraints

• Gain practical skills to query complex data sets

• Prepare for Oracle SQL certification

---

 Course Content:

Module 1: Introduction to Oracle SQL

• What is SQL and RDBMS?

• Overview of Oracle Database Architecture

• SQL Developer and other Oracle tools

• Writing SQL statements – Syntax rules

Module 2: Basic SQL SELECT Statements

• SELECT statements and column aliases

• Arithmetic expressions and null values

• Using the WHERE clause to filter rows

• ORDER BY clause for sorting

Module 3: Using Single-Row Functions

• Character, number, date functions

• Conversion functions (TO_DATE, TO_CHAR, etc.)

• General functions: NVL, COALESCE, NULLIF

Module 4: Using Conversion Functions and Conditional Expressions

• Data type conversions

• DECODE and CASE statements

Module 5: Aggregating Data Using Group Functions

• AVG, SUM, COUNT, MIN, MAX

• GROUP BY and HAVING clause

• Nested group functions

Module 6: Displaying Data from Multiple Tables

• Introduction to JOINS

• INNER JOIN, OUTER JOIN (LEFT, RIGHT), CROSS JOIN

• Using table aliases

Module 7: Subqueries

• Single-row and multiple-row subqueries

• Correlated subqueries

• EXISTS and NOT EXISTS

• Subqueries in FROM and SELECT clause

Module 8: Data Manipulation Language (DML)

• INSERT, UPDATE, DELETE statements

• MERGE statement

• Transaction control: COMMIT, ROLLBACK, SAVEPOINT

Module 9: Data Definition Language (DDL)

• Creating tables and defining constraints

• ALTER and DROP statements

• Creating and using sequences and synonyms

Module 10: Views and Indexes

• Creating, replacing, and dropping views

• Simple and complex views

• Creating and managing indexes

Module 11: Schema Objects and Constraints

• Constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, CHECK

• DEFAULT and virtual columns

• Using data dictionary views

Module 12: Advanced SQL Features

• Set operators: UNION, INTERSECT, MINUS

• Inline views and WITH clause

---

Module13: Final Project

---

 

Download Oracle Database 19c

Get the best performance for your most demanding analytical and operational workloads. Learn more about upgrading to Oracle Database 19c.

---

Oracle 19c DBA Certification Exams

Oracle Database Administration I 1Z0-082 | Exam Price: $ 245 | Duration: 150 Minutes | Passing Score: 60%

Oracle Database Administration II 1Z0-083 | Exam Price: $ 245 | Duration: 150 Minutes | Passing Score: 57%

Certification Exam FAQ

---

International Student Training Fee : 500$

---

Find Oracle ERP Job (click on URL)

• Oracle DBA Jobs in Dubai / Saudia
• Oracle ERP Jobs in Saudia or UAE
• Oracle Fusion Cloud Jobs in Dubai
• Oracle Fusion Cloud Jobs in Saudi Arabia 

---

Oracle Fusion Cloud Job Interview Preparation

• • Oracle DBA Interview Questions and Answers
  • Oracle Fusion Cloud Technical Interview Questions
  • Oracle Fusion Cloud Techno Functional Interview Questions
  • Oracle Fusion Financials Cloud Interview Questions

---

---

Similar Courses 

Oracle Database 19c Administration (DBA Complete Course)

Oracle Database 11g/12c Admin-I DBA Training Course
Oracle Database 11g/12c Admin-II DBA Training Course
Oracle Database SQL Course -1Z0-071
Oracle Database PL/SQL Developer Certified Professional Course (1Z0-149)

Oracle APEX – Application Express

Oracle DBA 12c – Complete Course 

Oracle ERP Implantation & Support Services 

Need Oracle ERP E-Business Suite | Fusion Cloud Implementation Services
Need Oracle ERP Healthcheck or Database Support Services

 

[/vc_column_text]

[/vc_column][/vc_row]