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.
Product Identifiers
Publisher
Cengage Learning
ISBN-10
1305251032
ISBN-13
9781305251038
eBay Product ID (ePID)
219679508
Product Key Features
Number of Pages
608 Pages
Language
English
Publication Name
Oracle 12 C: Sql
Publication Year
2015
Subject
Management Information Systems, Desktop Applications / Databases, Programming Languages / Sql, General, Information Technology
Features
Revised
Type
Textbook
Subject Area
Computers
Author
Joan Casteel
Format
Trade Paperback
Dimensions
Item Height
1.3 in
Item Weight
36.9 Oz
Item Length
9.1 in
Item Width
7.5 in
Additional Product Features
Edition Number
3
Illustrated
Yes
Edition Description
Revised Edition
Lc Classification Number
Qa76.9.D3c3828 2016
Table of Content
1. Overview of Database Concepts.2. Basic SQL SELECT Statements.3. Table Creation and Management.4. Constraints.5. Data Manipulation and Transaction Control.6. Additional Database Objects.7. User Creation and Management.8. Restricting Rows and Sorting Data.9. Joining Data from Multiple Tables.10. Selected Single-Row Functions.11. Group Functions.12. Subqueries and MERGE Statements.13. Views.Appendix A: Tables for the Just Lee 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.