Beginning Oracle Sql For Oracle Database 18C - Brumm Ben | Libro Apress 08/2019 -

home libri books ebook dvd e film top ten sconti 0 Carrello

Torna Indietro

brumm ben - beginning oracle sql for oracle database 18c

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

Disponibilità: Normalmente disponibile in 10 giorni

34,40 €
32,68 €

Questo prodotto usufruisce delle SPEDIZIONI GRATIS
selezionando l'opzione Corriere Veloce in fase di ordine.

Pagabile anche con App18 Bonus Cultura e Carta Docenti

Facebook Twitter Aggiungi commento

Spese Gratis


Lingua: Inglese


Pubblicazione: 08/2019
Edizione: 1st ed.



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
28. Understanding the Alternative Join Syntax

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


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 experience with databases is required to get started. Examples in the book are built around Oracle Live SQL, a freely available, online sandbox for practicing and experimenting with SQL statements, and Oracle Express Edition, a free version of Oracle Database that is available for download.

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. 


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.

Altre Informazioni



Condizione: Nuovo
Dimensioni: 254 x 178 mm Ø 868 gr
Formato: Brossura
Illustration Notes:138 Illustrations, black and white
Pagine Arabe: 431
Pagine Romane: xxvi

Utilizziamo i cookie di profilazione, anche di terze parti, per migliorare la navigazione, per fornire servizi e proporti pubblicità in linea con le tue preferenze. Se vuoi saperne di più o negare il consenso a tutti o ad alcuni cookie clicca qui. Chiudendo questo banner o proseguendo nella navigazione acconsenti all’uso dei cookie.