Oracle 12c: SQL, 3rd Edition

Now you can master the latest version of the fundamental SQL language used in all relational databases today with ORACLE 12C: SQL, 3E. Much more than a study guide, this edition helps you transform a basic knowledge of databases into proficiency with the latest SQL and Oracle concepts and techniques. You learn to use Oracle 12c SQL most effectively as you 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, manipulating data, and more. The author then explores both basic data query techniques as well as advanced query topics using a proven hands-on approach. 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 you transition to further studies and even more advanced books in this series, appendixes introduce SQL tuning, compare Oracle’s SQL syntax with other databases, and overview Oracle connection interface tools: SQL Developer and SQL Plus. Trust ORACLE 12C: SQL, 3E to provide the knowledge you need for Oracle certification testing and the solid foundation for pursuing a career as a database administrator or developer.

Table of Contents

Ch 1: Overview of Database Concepts
Ch 2: Basic SQL SELECT Statements
Ch 3: Table Creation and Management
Ch 4: Constraints
Ch 5: Data Manipulation and Transaction Control
Ch 6: Additional Database Objects
Ch 7: User Creation and Management
Ch 8: Restricting Rows and Sorting Data
Ch 9: Joining Data from Multiple Tables
Ch 10: Selected Single-Row Functions
Ch 11: Group Functions
Ch 12: Subqueries and MERGE Statements
Ch 13: Views
Appendix A: Tables for the JustLee Books Database
Appendix B: SQL*Plus and SQL Developer Overview
Appendix C: Oracle Resources
Appendix D: SQL*Loader
Appendix E: SQL Tuning Topics
Appendix F: SQL in Various Databases