
Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional
Ben Brumm
Résumé
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.
Author Ben Brumm begins by helping you understand what a database is, and getting you set up with a sandbox in which to practice the SQL that you are learning. From there, easily digestible chapters cover, point-by-point, the different aspects of writing queries to get data out of a database. You'll also learn about creating tables and getting data into the database. Crucial topics such as working with nulls and writing analytic queries are given the attention they deserve, helping you to avoid pitfalls when writing queries for production use.
What You'll Learn
- Create, update, and delete tables in an Oracle database
- Add, update, delete data from those database tables
- Query and view data stored in your database
- Manipulate and transform data using in-built database functions and features
- Correctly choose when to use Oracle-specific syntax and features
Who This Book Is For
Those new to Oracle who are planning to develop software using Oracle as the back-end data store. The book is also for those who are getting started in software development and realize they need to learn some kind of database language. Those who are learning software development on the side of their normal job, or learning it as a college student, who are ready to learn what a database is and how to use it also will find this book useful.
Part I. Setting Up 1. What Is A Database?2. Setting Up
Part II. Viewing Data 3. 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 Data 13. Understanding the Data Types14. Creating A Table15. Adding Data to A Table16. Updating and Removing Data17. Updating or Deleting A Table
Part IV. Joining Tables 18. Inner Join19. Outer Join20. Other Join Types21. Joining Many Tables28. Understanding the Alternative Join Syntax
Part V. Functions 22. Using Functions in SQL23. Writing Conditional Logic24. Understanding Aggregate Functions25. 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
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Apress |
Auteur(s) | Ben Brumm |
Parution | 05/08/2019 |
Nb. de pages | 431 |
EAN13 | 9781484244296 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse