Beginning Oracle SQL for Oracle Database 18c From Novice to Professional /

• Κύριος συγγραφέας: Brumm, Ben (Συγγραφέας, http://id.loc.gov/vocabulary/relators/aut)
• Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
• Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
• Γλώσσα: English
• Έκδοση: Berkeley, CA : Apress : Imprint: Apress, 2019.
• Έκδοση: 1st ed. 2019.
• Θέματα: Database management.; Database Management.

Start 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 ex...

Πίνακας περιεχομένων:

• 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.