Murach's Oracle SQL and PL/SQL for developers: training & reference

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 : training & reference / 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

Includes index.

The Physical Object

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

Edition Identifiers

ISBN:9781890774806, 1890774804
oclc:on1089535069
LC Classification:QA76.73.S67
Dewey Decimal:005.75 MUR

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