Advertisement

Beginning Oracle SQL for Oracle Database 18c

From Novice to Professional

  • Ben Brumm
Book

Table of contents

  1. Front Matter
    Pages i-xxvi
  2. Setting Up

    1. Front Matter
      Pages 1-1
    2. Ben Brumm
      Pages 3-7
    3. Ben Brumm
      Pages 9-49
  3. Viewing Data

    1. Front Matter
      Pages 51-51
    2. Ben Brumm
      Pages 53-64
    3. Ben Brumm
      Pages 65-76
    4. Ben Brumm
      Pages 77-88
    5. Ben Brumm
      Pages 89-97
    6. Ben Brumm
      Pages 99-108
    7. Ben Brumm
      Pages 109-125
    8. Ben Brumm
      Pages 127-135
    9. Ben Brumm
      Pages 151-162
    10. Ben Brumm
      Pages 163-179
  4. Adding, Updating, Deleting Data

    1. Front Matter
      Pages 181-181
    2. Ben Brumm
      Pages 183-195
    3. Ben Brumm
      Pages 197-212
    4. Ben Brumm
      Pages 213-224
    5. Ben Brumm
      Pages 225-238
    6. Ben Brumm
      Pages 239-250
  5. Joining Tables

    1. Front Matter
      Pages 251-251
    2. Ben Brumm
      Pages 253-262
    3. Ben Brumm
      Pages 263-273
    4. Ben Brumm
      Pages 275-289
    5. Ben Brumm
      Pages 291-299
  6. Functions

    1. Front Matter
      Pages 301-301
    2. Ben Brumm
      Pages 303-330
    3. Ben Brumm
      Pages 331-345
    4. Ben Brumm
      Pages 347-364
    5. Ben Brumm
      Pages 365-378
    6. Ben Brumm
      Pages 379-389
  7. Command Line

    1. Front Matter
      Pages 391-391
    2. Ben Brumm
      Pages 393-410
  8. Appendixes

    1. Front Matter
      Pages 411-411
  9. Back Matter
    Pages 423-431

About this book

Introduction

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

Keywords

Live SQL Queries Query Structured Query Language SQL Query Language Standard Query Language Nulls Schemas Indexes Indexing Tables SQL Developer SQL*Plus

Authors and affiliations

  • Ben Brumm
    • 1
  1. 1.MelbourneAustralia

Bibliographic information