Overview
- Makes use of Oracle Live SQL, a freely accessible online sandbox for practicing SQL, and Oracle Express Edition, a free version of Oracle Database that is available for download
- Divides the topic into small chunks that can be read and practiced during small breaks during a busy professional’s work day
- Gives attention to tricky issues like nulls, use of aliases, natural joins, and the various join types and syntaxes that are available
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (28 chapters)
-
Setting Up
-
Adding, Updating, Deleting Data
Keywords
About this book
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.
AuthorBen 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.
Authors and Affiliations
About the author
Bibliographic Information
Book Title: Beginning Oracle SQL for Oracle Database 18c
Book Subtitle: From Novice to Professional
Authors: Ben Brumm
DOI: https://doi.org/10.1007/978-1-4842-4430-2
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: Ben Brumm 2019
Softcover ISBN: 978-1-4842-4429-6Published: 06 August 2019
eBook ISBN: 978-1-4842-4430-2Published: 05 August 2019
Edition Number: 1
Number of Pages: XXVI, 431
Number of Illustrations: 138 b/w illustrations
Topics: Database Management