Description
Book SynopsisStart developing with Oracle SQL. This book is a one-stop introduction to everything you need to know about getting started developing an Oracle Database. You''ll learn about foundational concepts, setting up a simple schema, adding data, reading data from the database, and making changes. No experience with databases is required to get started. Examples in the book are built around Oracle Live SQL, a freely available, online sandbox for practicing and experimenting with SQL statements, and Oracle Express Edition, a free version of Oracle Database that is available for download.
A marquee feature of Beginning Oracle SQL for Oracle Database 18c is the small chapter size. Content is divided into easily digestible chunks that can be read and practiced in very short intervals of time, making this the ideal book for a busy professional to learn from. Even just a 15-20 minute block of free time can be put to good use.
Autho
Table of ContentsIntroduction
Part I. Setting Up1. What Is A Database?2. Setting Up
Part II. Viewing Data3. Retrieving Data4. Selecting Specific Columns5. Restricting the Results6. Comparing Data7. Applying Multiple Filters8. Working with NULLs9. Removing Duplicate Results10. Applying Filters on Lists and Ranges of Values11. Ordering Your Data12. Applying Table and Column Aliases
Part III. Adding, Updating, Deleting Data13. Understanding the Data Types14. Creating A Table15. Adding Data to A Table16. Updating and Removing Data17. Updating or Deleting A Table
Part IV. Joining Tables18. Inner Join19. Outer Join20. Other Join Types21. Joining Many Tables28. Understanding the Alternative Join Syntax
Part V. Functions22. Using Functions in SQL23. Writing Conditional Logic24. Understanding Aggregate Functions25. Grouping Your Results 26. What Are Indexes?
Part VI. Command Line27. Using the Command Line
Part VII. Appendixes28. Appendix. How to Find and Navigate the Oracle SQL Reference
