Oracle 19c SQL For Developers,Testers & Analyst

Oracle SQL is one of the most widely used database management system around the world. It’s well suited to power primarily commercial and enterprise applications, and is particularly popular at large companies with mission-critical databases. Mastering Oracle SQL is therefore guaranteed to open exciting opportunities. In this book, you will get a complete introduction to Oracle SQL solving business problems. By the end of this course, you will understand how Oracle processes SQL queries and will have a solid foundation in Oracle SQL.

Table Of Contents:

Introduction to Oracle SQL
Basic Elements of Oracle SQL
Data Types
Data Type Comparison Rules
Literals
Nulls
Comments
Database Objects
Pseudocolumns
Operators
Expressions
Conditions
Functions
Common SQL DDL Clauses
SQL Queries and Subqueries
Joins
Types of SQL Statements
Data Definition Language (DDL) Statements
TABLE
VIEW
MATERIALIZED VIEW
DIMENSION
INDEX
SYNONYM
SEQUENCE
FUNCTION
PROCEDURE
PACKAGE
TYPE
CONTEXT
LIBRARY
TRIGGER
EDITION
JAVA
GRANT
REVOKE
PURGE
RENAME
TRUNCATE
Data Manipulation Language (DML) Statements
INSERT
SELECT
UPDATE
DELETE
LOCK TABLE
MERGE
Transaction Control Statements
COMMIT
ROLLBACK
SAVEPOINT
SET TRANSACTION
SET CONSTRAINT[S]
Session Control Statements
ALTER SESSION
SET ROLE
Using XML in SQL Statements