Oracle 19c SQL For Developers,Testers & Analyst

by Tanveer A

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 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

687 pages, Kindle Edition

Published February 5, 2021