Cengage Learning; 3rd edition
Casteel's ORACLE 12C: SQL 3rd edition provides an introduction to the most recent version of the core SQL language that is used in all relational databases today (PDF). This third edition is much more than a study guide; it assists individuals who have only a fundamental understanding of databases in mastering the most recent concepts and approaches offered by Oracle and SQL. As part of their preparation for the first exam in either the Oracle Developer Certification or Oracle Database Administrator Exam routes, students acquire a profound and profound comprehension of how to use Oracle 12c SQL 3e in the most effective manner possible. This third edition begins with an emphasis on the creation of database objects, which may include constraints, sequences, indexes, tables, and other data structures. After that, the author delves into data query methods, such as row filtering, single-row functions, joins, subqueries, aggregate functions, and views, in addition to advanced query subjects. ORACLE 12C: SQL 3rd edition presents the most recent features and upgrades that were added to 12c. These include upgraded data types and invisible columns, as well as new OUTER APPLY and CROSS methods for joining data sets. Appendixes introduce SQL tuning, compare Oracle's SQL syntax with the syntax of other databases, and provide an overview of Oracle connection interface tools such SQL Plus and SQL Developer. This is done to assist readers in making the transition to future study. Oracle 12C: SQL 3e is a reliable resource that will equip readers with the information necessary to pass Oracle certification exams and lay a strong foundation for those who wish to pursue a career as a successful database developer or administrator.