eBooks-it.org Logo
eBooks-IT.org Inner Image

Oracle Database 11g SQL

Oracle Database 11g SQL Image

Book Details:

Publisher:McGraw-Hill Osborne Media
Series: McGraw Hill
Author:Jason Price
Edition:1
ISBN-10:0071498508
ISBN-13:9780071498500
Pages:656
Published:Nov 05 2007
Posted:Nov 19 2014
Language:English
Book format:PDF
Book size:7.11 MB

Book Description:

Write powerful SQL statements and PL/SQL programsLearn 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 DeveloperUse SQL SELECT, INSERT, UPDATE, and DELETE statementsWrite PL/SQL programsCreate tables, sequences, indexes, views, and triggersWrite advanced queries containing complex analytical functionsCreate database objects and collections to handle abstract dataUse large objects to handle multimedia files containing music and moviesWrite Java programs to access an Oracle Database using JDBCTune your SQL statements to make them execute fasterExplore the XML capabilities of the Oracle DatabaseMaster the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more

Download Link:

Related Books:

OCP Oracle Database 11g

New Features for Administrators Exam Guide
OCP Oracle Database 11g Image
A Fully Integrated Study System for OCP Exam 1Z0-050Prepare for the Oracle Certified Professional Oracle Database 11g New Features for Administrators exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test, and serve as your essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-050, including:Installation and upgradesPartitioning and storageIntelligent infrastructureDiagnostics and fault managementPerformanceOracle Recovery Manager and Oracle FlashbackSecurityOracle SQL Performance AnalyzerSQL plan managementAutomatic S...

OCA Exams1Z0-051 and 1Z0-052

Oracle Database 11g Administrator Certified Associate Study Guide
OCA Exams1Z0-051 and 1Z0-052 Image
Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification-this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple tables, and exploring the Oracle database architecture. Plus, you'll learn how to create and maintain an Oracle database, perform database backups and recovery, move and manipulate data, prepare the database environment, and more.Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook f...

Pro Oracle Database 11g RAC on Linux

Pro Oracle Database 11g RAC on Linux Image
Pro Oracle Database 11g RAC on Linux provides full-life-cycle guidance on implementing Oracle Real Application Clusters in a Linux environment. Real Application Clusters, commonly abbreviated as RAC, is Oracles industry-leading architecture for scalable and fault-tolerant databases. RAC allows you to scale up and down by simply adding and subtracting inexpensive Linux servers. Redundancy provided by those multiple, inexpensive servers is the basis for the failover and other fault-tolerance features that RAC provides.Written by authors well-known for their talent with RAC, Pro Oracle Database 11g RAC on Linux gives you a rock-solid and technically flawless foundation on which to build your RAC-management skills. Authors Julian Dyke and Steve Shaw shar...



2007 - 2021 © eBooks-IT.org