
Beginning Oracle SQL
For Oracle Database 12c
APress
3rd Edition
Published on 10. March 2014
Book
Paperback/Softback
XXII, 440 pages
978-1-4302-6556-6 (ISBN)
Description
Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creating scripts to automate routine tasks. SQL Developer is a powerful, graphical environment for developing and debugging queries.
Oracle's is possibly the most valuable dialect of SQL from a career standpoint. Oracle's database engine is widely used in corporate environments worldwide. It is also found in many government applications. Oracle SQL implements many features not found in competing products. No developer or DBA working with Oracle can afford to be without knowledge of these features and how they work, because of the performance and expressiveness they bring to the table.
Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle Database.
Takes an example-based approach, with clear and authoritative explanations
Introduces both SQL and the query tools used to execute SQL statements
Shows how to create tables, populate them with data, and then query that data to generate business results
More details
Edition
Third Edition
Language
English
Place of publication
Berkeley
United States
Target group
Popular/general
Edition type
Revised edition
Illustrations
89 s/w Abbildungen
XXII, 440 p. 89 illus.
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 24 mm
Weight
816 gr
ISBN-13
978-1-4302-6556-6 (9781430265566)
DOI
10.1007/978-1-4302-6557-3
Schweitzer Classification
Other editions
Additional editions

E-Book
03/2014
3rd Edition
APress
€79.99
Available for download
Persons
Tim Gorman began his information technology career in 1984 as a C programmer on UNIX and VMS systems, working on medical and financial systems as an application developer, systems programmer, and systems administrator. He joined Oracle Corporation in 1990 as a consultant, then became an independent consultant in 1998, and has worked for SageLogix since 2000. Gorman is the coauthor of Essential Oracle8i Data Warehousing and Oracle8 Data Warehousing. He specializes in performance tuning applications, databases, and systems, as well as data warehouse design and implementation, backup and recovery, architecture and infrastructure, and database administration. Gorman still considers himself a pretty good coder, although the market for C programs has dried up somewhat lately.
Content
1. Relational Database Systems and Oracle 2. Introduction to SQL and SQL*Plus, and SQL Developer 3. Data Definition, Part I 4. Retrieval: The Basics 5. Retrieval: Functions 6. Data Manipulation 7. Data Definition, Part II 8. Retrieval: Joins and Grouping 9. Retrieval: Advanced Features 10. Views 11. Automating 12. Object-Relational Features 13. Appendix A -- Case Tables 14. Appendix B -- Exercise Solutions