Murach's Oracle SQL and PL/SQL for developers

by Murach, Joel

Type Book

Rate 0.0 /5

Details

Files

Reviews

Download

Title Statements

Full title :Murach's Oracle SQL and PL/SQL for developers / Joel Murach.

Edition Statements

Publication Date:©2014
Edition:2nd edition

Publication Statements

Publisher(s):Mike Murach & Associates, Inc
Place of Publication:Fresno, CA
Language:eng
Publication Date:©2014

Notes

At head of title: Training & reference

Includes index.

The Physical Object

Description:xvi, 630 pages : : illustrations ; : 26 cm.

Edition Identifiers

ISBN:9781890774806, 1890774804
oclc:ocn890181468
LC Classification:QA76.9.D32
Dewey Decimal:005.7565

An introduction to SQL. An intorduction to relational databases and SQL ; How to use Oracle SQL Developer and other tools -- The essential SQL skills. How to retrieve data from a single table ; How to retrieve data from two or more tables ; How to code summary queries ; How to code subqueries ; How to insert, update, and delete data ; How to work with data types and functions -- Database design and implementation. How to design a database ; How to create tables, indexes, and sequences ; How to create views ; How to manage database security -- The essential PL/SQL skills. How to write PL/SQL code ; How to manage transactions and locking ; How to create stored procedures and functions ; How to create triggers -- Advanced data types. How to work with time stamps and intervals ; How to work with large objects.

Subjects