Oracle SQL: a beginner's tutorial

✍ Scribed by Darmawikarta, Djoni

• Publisher: BrainySoftware; Brainy Software
• Year: 2014
• Tongue: English
• Leaves: 136
• Edition: First edition
• Category: Library

✦ Synopsis

This introduction to SQL for the Oracle database begins by discussing exactly how data is stored and maintained in a relational database, familiarizing readers with SQL INSERT, UPDATE, and DELETE statements. The guide then discusses how to construct basic queries, choose an appropriate output, and how to create and use groups. Readers will also learn how to use joins to query data from multiple tables, how to create predefined views that can be stored in a database, and how to utilize the metadata of a database. Appendices round out the book, covering the various indexing techniques available in the Oracle database and discussing how to install Oracle Database Express Edition and list the Oracle built-in data types.

✦ Table of Contents

Table of Contents......Page 3
Introduction......Page 7
Chapter 1 Storing and Maintaining Data......Page 11
Chapter 2 Basic Queries......Page 19
Chapter 3 Query Output......Page 31
Chapter 4 Grouping......Page 47
Chapter 5 Joins......Page 53
Chapter 6 Subqueries......Page 69
Chapter 7 Compound Queries......Page 79
Chapter 8 Views......Page 85
Chapter 9 Built-in Functions......Page 91
Chapter 10 PL/SQL......Page 103
Chapter 11 The Data Dictionary......Page 113
Appendix A Installing Oracle Database XE......Page 119
Appendix B Oracle Built-in Data Types......Page 127
Appendix C Indexes......Page 129
Index......Page 133