Beginning Oracle SQL for Oracle Database 18c From Novice to Professional
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...
Autor principal: | |
---|---|
Formato: | Libro electrónico |
Idioma: | Inglés |
Publicado: |
Berkeley, CA :
Apress
2019.
|
Edición: | 1st ed. 2019. |
Materias: | |
Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630978306719 |
Tabla de Contenidos:
- 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.