Solution Manual for Oracle 12c: SQL, 3rd Edition, Joan Casteel

Product details:

• ISBN-10 ‏ : ‎ 1305251032
• ISBN-13 ‏ : ‎ 978-1305251038
• Author: Joan E. Casteel

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.

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.

People also search:

oracle 12c sql 3rd edition pdf free download

oracle 12c sql 3rd edition

oracle 12c sql 3rd edition pdf

joan casteel. 2015. oracle 12c sql 3rd edition

number(12 3) in oracle