Oracle SQL: a beginner's tutorial

by Darmawikarta, Djoni

Type Book

Rate 0.0 /5

Details

Files

Reviews

Download

Title Statements

Full title :Oracle SQL : a beginner's tutorial / Djoni Darmawikarta.

Summary

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.

Edition Statements

Publication Date:2014.
Edition:First edition

Publication Statements

Publisher(s):Brainy Software Inc
Place of Publication:Brossard, Quebec, Canada
Language:eng
Publication Date:2014.

Notes

Includes index.

The Physical Object

Description:vi, 130 pages : : illustrations ; : 23 cm

Edition Identifiers

ISBN:9780980839647, 0980839645
oclc:ocn861675729
LC Classification:QA76.73.S67
Dewey Decimal:005.13/3

Introduction -- 1. Storing and maintaining data -- 2. Basic queries -- 3. Query output -- 4. Grouping -- 5. Joins -- 6. Subqueries -- 7. Compound queries -- 8. Views -- 9. Built-in funcitons -- 10. PL/SQL -- 11. The data dictionary -- Appendix A: Installing Oracle Database XE -- Appendix B: Oracle built-in data types -- Sppendix C: Indexes.

Subjects

Bases de données -- Conception Bases de données -- Gestion Database design Database management Oracle (Computer file) SQL (Computer program language) SQL (Langage de programmation)