Oracle 12c: SQL

Author:   Joan Casteel (Tidewater Community College) ,  Larbi Oukada
Publisher:   Cengage Learning, Inc
Edition:   3rd edition
ISBN:  

9781305251038


Pages:   608
Publication Date:   11 September 2015
Format:   Paperback
Availability:   Available To Order   Availability explained
We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately.

Our Price $329.87 Quantity:  
Add to Cart

Share |

Oracle 12c: SQL


Add your own review!

Overview

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.

Full Product Details

Author:   Joan Casteel (Tidewater Community College) ,  Larbi Oukada
Publisher:   Cengage Learning, Inc
Imprint:   Course Technology Inc
Edition:   3rd edition
Dimensions:   Width: 19.00cm , Height: 3.20cm , Length: 23.10cm
Weight:   1.043kg
ISBN:  

9781305251038


ISBN 10:   1305251032
Pages:   608
Publication Date:   11 September 2015
Audience:   College/higher education ,  Tertiary & Higher Education
Format:   Paperback
Publisher's Status:   Active
Availability:   Available To Order   Availability explained
We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately.

Table of Contents

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.

Reviews

Author Information

Joan E. Casteel combines more than 15 years of hands-on experience in application development in various business environments with strong teaching skills to clarify important application and software concepts for today's readers. An award-winning instructor, Ms. Casteel serves as associate professor of information technology and business at Tidewater Community College, where she has been an integral part of the Database Specialist curriculum. She has joined a newly formed team at the college in charge of building a campus ID card program to encompass four campuses, using a recently deployed Oracle-based system. In addition the team is developing new Oracle APEX applications to improve college-wide financial services support. Ms. Casteel has been recognized by her colleagues for her professional accomplishments, including creating an Oracle virtual machine image for students and handling recruitment efforts for database specialist career studies. Ms. Casteel is the author of two successful books on Oracle from Course Technology, part of Cengage Learning, covering SQL and PL/SQL which serve as the introductory course sequence in the college’s database career path.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions
Latest Reading Guide

MRG2025CC

 

Shopping Cart
Your cart is empty
Shopping cart
Mailing List