Free Downloads

Oracle Database 11g SQL (Oracle Press)

Write powerful SQL statements and PL/SQL programs Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL. Explore SQL Plus and SQL Developer Use SQL SELECT, INSERT, UPDATE, and DELETE statements Write PL/SQL programs Create tables, sequences, indexes, views, and triggers Write advanced queries containing complex analytical functions Create database objects and collections to handle abstract data Use large objects to handle multimedia files containing music and movies Write Java programs to access an Oracle Database using JDBC Tune your SQL statements to make them execute faster Explore the XML capabilities of the Oracle Database Master the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more

File Size: 19021 KB

Print Length: 688 pages

Simultaneous Device Usage: Up to 4 simultaneous devices, per publisher limits

Publisher: McGraw-Hill Education; 1 edition (November 26, 2007)

Publication Date: November 26, 2007

Sold by:  Digital Services LLC

Language: English

ASIN: B00122I24G

Text-to-Speech: Enabled

X-Ray: Not Enabled

Word Wise: Not Enabled

Lending: Not Enabled

Enhanced Typesetting: Enabled

Best Sellers Rank: #759,940 Paid in Kindle Store (See Top 100 Paid in Kindle Store) #54 in Books > Computers & Technology > Digital Audio, Video & Photography > Adobe > Adobe Flash #76 in Books > Computers & Technology > Databases & Big Data > Relational Databases #308 in Books > Computers & Technology > Databases & Big Data > Oracle

An experienced hand is probably going to find this book a little sparse, but such a person really doesn't need this book, they should be using any of the excellent Oracle manuals that can be had for free just by asking.For the new student or the old student reacquainting themselves with Oracle SQL after a few years away from it, the pace is about right and the info load perfect for the careful reader.I see people complaining that the text is not clear and not easily understood but I have to question that judgement. Perhaps a little less multi-tasking during the book sessions would help (I speak as an easily distracted student myself). I don't know. All I can say is that the text is not dense, the explanations are adequate especially when used as examples for self-study at the computer (i.e. vamping on the theme for a few minutes in the example database that can be downloaded from the address printed on the book cover) and the pacing seems good - if you are a really bright student you can always speed read the bits you "get" but I'd be careful when deciding to do that. There is a large amount of information to be found there and sometimes your assumptions may hide a nifty feature Oracle built in.That said, the book is missing one important piece of information necessary if the student is using a database with schemas other than the test one supplied in the download - the "ALTER SESSION SET CURRENT_SCHEMA = store;" command, which will be needed to get the syntax in the book to work seamlessly. There's also a referential integrity issue that can get in the way of testing the earliest example DELETE command, but that might usefully be seen as a debugging lab after reading on a little.Will the reader benefit from other sources? Of course.

SQL: Learn SQL In A DAY! - The Ultimate Crash Course to Learning the Basics of SQL In No Time (SQL, SQL Course, SQL Development, SQL Books, SQL for Beginners) Oracle Database 11g SQL (Oracle Press) SQL: Beginner's Guide for Coding SQL (database programming, computer programming, how to program, sql for dummies, java, mysql, The Oracle, python, PHP, ... (HTML, Programming, Coding, CSS Book 7) Oracle Database 11g & MySQL 5.6 Developer Handbook (Oracle Press) OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052, 1Z0-053 (Oracle Press) Oracle Database 11g New Features (Oracle Press) SQL: QuickStart Guide - The Simplified Beginner's Guide To SQL (SQL, SQL Server, Structured Query Language) OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press) Beginning Oracle Database 11g Administration: From Novice to Professional (Expert's Voice in Oracle) Oracle RMAN 11g Backup and Recovery (Oracle Press) Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution (Oracle Press) Oracle 11G: SQL Oracle Database 11g A Beginner's Guide ORACLE PL/SQL 101 (Oracle Press) Oracle Database 12c The Complete Reference (Oracle Press) Oracle Database 12c DBA Handbook (Oracle Press) Oracle Database 12c Install, Configure & Maintain Like a Professional (Oracle Press) Oracle Database Ajax & PHP Web Application Development (Oracle Press) Oracle Database 10g PL/SQL Programming Oracle Database 12c PL/SQL Programming