Beginning Oracle SQL
Год: 2014
Автор: Lex De Haan, Tim Gorman, Inger Jørgensen, Melanie Caffrey
Издательство: Apress
ISBN: 978-1-4302-6557-3
Серия: The Expert's Voice in Oracle
Язык: Английский
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 429
Описание: 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
What you’ll learn
- Create database tables and define their relationships.
- Add data to your tables. Then change and delete that data.
- Write database queries that generate accurate results.
- Avoid common traps and pitfalls in writing SQL queries, especially from nulls.
- Reap the performance and expressiveness of analytic and window functions.
- Make use of Oracle Database's support for object types.
- Write recursive queries to query hierarchical data.
Примеры страниц Оглавление
About the Authors xvii
About the Technical Reviewer xix
Acknowledgments xxi
Introduction xxiii
Chapter 1: Relational Database Systems and Oracle 1
Chapter 2: Introduction to SQL and SQL Developer 23
Chapter 3: Data Definition, Part I 59
Chapter 4: Retrieval: The Basics 69
Chapter 5: Retrieval: Functions 101
Chapter 6: Data Manipulation 129
Chapter 7: Data Definition, Part II 147
Chapter 8: Retrieval: Multiple Tables and Aggregation 177
Chapter 9: Retrieval: Some Advanced Features 213
Chapter 10: Views 245
Chapter 11: SQL*Plus Basics and Scripting 267
Chapter 12: Object-Relational Features 323
Appendix A: The Seven Case Tables 341
Appendix B: Answers to the Exercises 351
Index 395
Опубликовано группой

If you like the topic, please click share to help develop our site.

To download the file disable ad blocking, and reload the page.

disable adblock How to disable ad blocking?

Download by magnet link 19 MB Download Torrent

Login using:

Current time is: 25-May 11:51 :: All times are UTC + 3