Oracle 12c: SQL 3rd Edition

Introduce the latest version of the fundamental SQL language used in all relational databases today with Casteel?s ORACLE 12C: SQL, 3E. Much more than a study guide, this edition helps those who have only a basic knowledge of databases master the latest SQL and Oracle concepts and techniques. Learners gain a strong understanding of how to use Oracle 12c SQL most effectively as they prepare for the first exam in the Oracle Database Administrator or Oracle Developer Certification Exam paths. This edition initially focuses on creating database objects, including tables, constraints, indexes, sequences, and more. The author then explores data query techniques, such as row filtering, joins, single-row functions, aggregate functions, subqueries, and views, as well as advanced query topics. ORACLE 12C: SQL, 3E introduces the latest features and enhancements in 12c, from enhanced data types and invisible columns to new CROSS and OUTER APPLY methods for joins. To help readers transition to further studies, appendixes introduce SQL tuning, compare Oracle’s SQL syntax with other databases, and overview Oracle connection interface tools: SQL Developer and SQL Plus. Readers can trust ORACLE 12C: SQL, 3E to provide the knowledge for Oracle certification testing and the solid foundation for pursuing a career as a successful database administrator or developer. Oracle 12c: SQL 3rd Edition is written by Joan Casteel and published by Cengage Learning. ISBNs for Oracle 12c: SQL are 9781305465305, 130546530X and the print ISBNs are 9781305251038, 1305251032. Additional ISBNs include 9781305985520, 9781350251038, 9781305449947.