Table of Contents

Introduction.- Part I. Setting Up.- 1. What Is A Database?.- 2. Setting Up.- .- Part II. Viewing Data.- 3. Retrieving Data.- 4. Selecting Specific Columns.- 5. Restricting the Results.- 6. Comparing Data.- 7. Applying Multiple Filters.- 8. Working with NULLs.- 9. Removing Duplicate Results.- 10. Applying Filters on Lists and Ranges of Values.- 11. Ordering Your Data.- 12. Applying Table and Column Aliases.- Part III. Adding, Updating, Deleting Data.- 13. Understanding the Data Types.- 14. Creating A Table.- 15. Adding Data to A Table.- 16. Updating and Removing Data.- 17. Updating or Deleting a Table.- Part IV. Joining Tables.- 18. Inner Join.- 19. Outer Join.- 20. Other Join Types.- 21. Joining Many Tables.- Part V. Functions.- 22. Using Functions in SQL.- 23. Writing Conditional Logic.- 24. Understanding Aggregate Functions.- 25. Grouping Your Results.- 26. What Are Indexes?.- Part VI. Command Line.- 27. Using the Command Line.- Part VII. Appendixes.- 28. Appendix. How to Find and Navigate the Oracle SQL Reference.

About the Author

​Ben Brumm is a software developer and business analyst with over 11 years of experience. Based in Melbourne, Australia, he has been working with databases and SQL both during his full-time job, and as the founder of the DatabaseStar dot com site where he teaches Oracle database topics. His passion for software and databases began when he started computer classes in high school in the late 1990s and it has only grown since then.