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