Description
Introduction
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
Author: Ben Brumm
Publisher: Apress
Published: 08/06/2019
Pages: 431
Binding Type: Paperback
Weight: 1.74lbs
Size: 10.00h x 7.00w x 0.93d
ISBN13: 9781484244296
ISBN10: 148424429X
BISAC Categories:
- Computers | Database Administration & Management
- Computers | System Administration | Storage & Retrieval
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
Author: Ben Brumm
Publisher: Apress
Published: 08/06/2019
Pages: 431
Binding Type: Paperback
Weight: 1.74lbs
Size: 10.00h x 7.00w x 0.93d
ISBN13: 9781484244296
ISBN10: 148424429X
BISAC Categories:
- Computers | Database Administration & Management
- Computers | System Administration | Storage & Retrieval
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.