Oracle SQL, A Beginners Tutorial, Second Edition

by Djoni Darmawikarta

Overview

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.

Product Details

BN ID:	2940157679361
Publisher:	Brainy Software
Publication date:	01/12/2016
Sold by:	Barnes & Noble
Format:	eBook
Pages:	148
File size:	3 MB

About the Author

Djoni Darmawikarta specializes in database, data modeling, data warehousing, and data analysis. He is a former systems engineer, consultant, customer support manager, and country computing center head at IBM. Djoni is currently a senior data analyst at a Toronto-based insurance company.