Beginning Oracle SQL: for Oracle Database 12c. (3 ed.)

Автор: DeHaan L. et al.
Издательство: Apress

Год: 2014
Страниц: 428
Язык: английский
Формат: pdf



 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.

Who this book is for (для кого эта книга)

Beginning Oracle SQL is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed.

Contents (содержание книги):

  • Relational Database Systems and Oracle
  • Introduction to SQL and SQL*Plus, and SQL Developer
  • Data Definition, Part I
  • Retrieval: The Basics
  • Retrieval: Functions
  • Data Manipulation
  • Data Definition, Part II
  • Retrieval: Joins and Grouping
  • Retrieval: Advanced Features
  • Views
  • Automating
  • Object-Relational Features
  • Appendix A - Case Tables
  • Appendix B - Exercise Solutions


Скачать книгу из интернета:

Вас заинтересует / Intresting for you:

Oracle Database PL/SQL. Рекоме...
Oracle Database PL/SQL. Рекоме... 1701 просмотров Алексей Вятский Mon, 05 Aug 2019, 12:21:49
Oracle PL/SQL 101
Oracle PL/SQL 101 737 просмотров Алексей Вятский Sun, 04 Aug 2019, 11:57:44
Big Data Fundamentals
Big Data Fundamentals 946 просмотров Алексей Вятский Tue, 21 Nov 2017, 13:23:18
Ethical Reasoning in Big Data
Ethical Reasoning in Big Data 635 просмотров Алексей Вятский Tue, 21 Nov 2017, 13:23:18
Войдите чтобы комментировать

anders7777 аватар
anders7777 ответил в теме #7980 25 янв 2017 14:40
Отличная книга для начинающих изучать СУБД Oracle. Ну при знании английского языка, конечно...