{"product_id":"9781430265573","title":"Beginning Oracle SQL: For Oracle Database 12c","description":"\u003cp\u003e    \u003cem\u003eBeginning Oracle SQL\u003c\/em\u003e 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. \u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  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.\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  Written in an easygoing and example-based style, \u003cem\u003eBeginning Oracle SQL\u003c\/em\u003e is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle Database. \u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cul\u003e  \u003cli\u003eTakes an example-based approach, with clear and authoritative explanations \u003c\/li\u003e  \u003cli\u003eIntroduces both SQL and the query tools used to execute SQL statements \u003c\/li\u003e  \u003cli\u003eShows how to create tables, populate them with data, and then query that data to generate business results \u003c\/li\u003e  \u003c\/ul\u003e           What you’ll learn\u003cul\u003e  \u003cli\u003eCreate database tables and define their relationships. \u003c\/li\u003e  \u003cli\u003eAdd data to your tables. Then change and delete that data. \u003c\/li\u003e  \u003cli\u003eWrite database queries that generate accurate results. \u003c\/li\u003e  \u003cli\u003eAvoid common traps and pitfalls in writing SQL queries, especially from nulls. \u003c\/li\u003e  \u003cli\u003eReap the performance and expressiveness of analytic and window functions. \u003c\/li\u003e  \u003cli\u003eMake use of Oracle Database's support for object types. \u003c\/li\u003e  \u003cli\u003eWrite recursive queries to query hierarchical data. \u003c\/li\u003e  \u003c\/ul\u003e  Who this book is for      \u003cp\u003e     \u003cem\u003eBeginning Oracle SQL\u003c\/em\u003e 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.         \u003c\/p\u003e     Table of Contents\u003cp\u003e1. Relational Database Systems and Oracle\u003c\/p\u003e\u003cp\u003e2. Introduction to SQL and SQL*Plus, and SQL Developer\u003c\/p\u003e\u003cp\u003e3. Data Definition, Part I\u003c\/p\u003e\u003cp\u003e4. Retrieval: The Basics\u003c\/p\u003e\u003cp\u003e5. Retrieval: Functions\u003c\/p\u003e\u003cp\u003e6. Data Manipulation\u003c\/p\u003e\u003cp\u003e7. Data Definition, Part II\u003c\/p\u003e\u003cp\u003e8. Retrieval: Joins and Grouping\u003c\/p\u003e\u003cp\u003e9. Retrieval: Advanced Features\u003c\/p\u003e\u003cp\u003e10. Views\u003c\/p\u003e\u003cp\u003e11. Automating\u003c\/p\u003e\u003cp\u003e12. Object-Relational Features\u003c\/p\u003e\u003cp\u003e13. Appendix A – Case Tables\u003c\/p\u003e\u003cp\u003e14. Appendix B – Exercise Solutions\u003c\/p\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47181572178160,"sku":"9781430265573","price":39.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430265573_p0.jpg?v=1763749437","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430265573","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}