Murach's Oracle SQL and PL/SQL : works with all versions through 11g / by Joel Murach

By: Murach, JoelMaterial type: TextTextSeries: Training & referencePublication details: New Delhi : Shroff Publishers & Distributors Pvt. LTD, 2011, 2008cDescription: xviii, 627 p. : ill. ; 25 cmISBN: 9788184045888(pbk)Other title: Murach's Oracle SQL and PL/SQL : works with all versions through 11gSubject(s): SQL (Computer program language)DDC classification: 005.7565
Contents:
An introduction to relational databases and SQL; How to use Oracle SQL Developer and other tools; 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; How to design a database; How to create tables, indexes, and sequences; How to create views; How to manage database security; How to write PL/SQL code; How to manage transactions and locking; How to create stored procedures and functions; How to create triggers; How to work with timestamps and intervals; How to work with large objects; Index.
Summary: Teaches you how to create effective SQL queries to extract and update the data in an Oracle database. This title teaches you how to design and implement a database, giving you insight into
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Call number Status Date due Barcode Item holds
Books Books Namal Library
Computer Science
005.7565 MUR-M 2011 200 (Browse shelf (Opens below)) Available 200
Total holds: 0
Browsing Namal Library shelves, Shelving location: Computer Science Close shelf browser (Hides shelf browser)
005.7565 MCL-M 2013 4002 MySQL workbench : 005.7565 MCL-O 2014 10325 Oracle database 11g PL/SQL programming / 005.7565 MCL-O 2014 10326 Oracle database 11g PL/SQL programming / 005.7565 MUR-M 2011 200 Murach's Oracle SQL and PL/SQL : works with all versions through 11g 005.7565 NAP-M 2001 1789 Microsoft excel 2000 : 005.7565 SCH-B 2012 204 High performance MySQL / 005.75/65 SHE-M 2002 1808 Microsoft Access 2002 :

Index included

An introduction to relational databases and SQL; How to use Oracle SQL Developer and other tools; 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; How to design a database; How to create tables, indexes, and sequences; How to create views; How to manage database security; How to write PL/SQL code; How to manage transactions and locking; How to create stored procedures and functions; How to create triggers; How to work with timestamps and intervals; How to work with large objects; Index.

Teaches you how to create effective SQL queries to extract and update the data in an Oracle database. This title teaches you how to design and implement a database, giving you insight into

There are no comments on this title.

to post a comment.