Cengage Learning; 3rd edition
Introduce the latest version of the fundamental SQL language used in all relational databases today with Casteel’s ORACLE 12C: SQL 3rd edition (PDF). Much more than a study guide; this 3rd edition helps those who have only a basic knowledge of databases master the latest Oracle and SQL concepts and techniques. Learners gain a very strong and solid understanding of how to use Oracle 12c SQL 3e most effectively as they prepare for the first exam in the Oracle Developer Certification or Oracle Database Administrator Exam paths. This 3rd edition initially focuses on creating database objects; including constraints; sequences; indexes; tables; and more. The author then explores data query techniques; such as row filtering; single-row functions; joins; subqueries; aggregate functions; and views; as well as advanced query topics. ORACLE 12C: SQL 3rd edition introduces the latest features and enhancements in 12c; from enhanced data types and invisible columns to new OUTER APPLY and CROSS 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 Plus and SQL Developer. 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 developer or administrator.