Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Oracle Database 11g SQL

Buy
Oracle Database 11g SQL, 9780071498500 (0071498508), McGraw-Hill, 2007
Today’s database management systems are accessed using a standard language known as Structured Query Language, or SQL. Among other things, SQL allows you to retrieve, add, update, and delete information in a database. In this book, you’ll learn how to master SQL, and you’ll find a wealth of practical examples. You can also get all the scripts and programs featured in this book online (see the last section, “Retrieving the Examples,” for details).

With this book, you will
  • Master standard SQL, as well as the extensions developed by Oracle Corporation for use with the specific features of the Oracle database.
  • Explore PL/SQL (Procedural Language/SQL), which is built on top of SQL and enables you to write programs that contain SQL statements.
  • Use SQL*Plus to execute SQL statements, scripts, and reports; SQL*Plus is a tool that allows you to interact with the database.
  • Execute queries, inserts, updates, and deletes against a database.
  • Create database tables, sequences, indexes, views, and users.
  • Perform transactions containing multiple SQL statements.
  • Define database object types and create object tables to handle advanced data.
  • Use large objects to handle multimedia files containing images, music, and movies.
  • Perform complex calculations using analytic functions.
  • Use all the very latest Oracle Database 11g features such as PIVOT and UNPIVOT, flashback archives, and much more.
  • Implement high-performance tuning techniques to make your SQL statements really fly.
(HTML tags aren't allowed.)

Reviews in Modern Astronomy, Cosmic Matter (Volume 20)
Reviews in Modern Astronomy, Cosmic Matter (Volume 20)
This 20th volume in the series contains 16 invited reviews and highlight contributions presented during the 2007 International Scientific Conference of the German Astronomical Society on the topic of "Cosmic Matter", held in Würzburg, Germany.

The papers published here discuss a wide range of hot topics, including cosmology,...

Intellectual Property Rights in Agricultural Biotechnology (Biotechnology in Agriculture Series)
Intellectual Property Rights in Agricultural Biotechnology (Biotechnology in Agriculture Series)
The successful application of biotechnology tools has had and is having dramatic effects in some areas of agriculture. These effects are being felt throughout the world in academic, government and industrial communities. The result is the rapid development of a multi-million dollar industry. This work has been going on for more than two decades...
The Clinical Practice of Complementary, Alternative, and Western Medicine
The Clinical Practice of Complementary, Alternative, and Western Medicine

"Western Medicine", "Alternative Medicine", "Complementary Medicine", "Holistic Medicine", and "Natural Medicine." There is really only one "medicine" that heals and puts the whole patient, not the disease, at the center of care: Integrated Medicine. This practice integrates all...


Making Things Move DIY Mechanisms for Inventors, Hobbyists, and Artists
Making Things Move DIY Mechanisms for Inventors, Hobbyists, and Artists

A unique guide to practical mechanical design principles and their applications
In Making Things Move, you'll learn how to build moving mechanisms through non-technical explanations, examples, and do-it-yourself projects--from art installations to toys to labor-saving devices. The projects include a drawing machine,
...

Fundamentals in Information Theory and Coding
Fundamentals in Information Theory and Coding

This book represents my 30 years continuing education courses for graduate and master degree students at the Electronics and Telecommunications Faculty from the Technical University of Cluj Napoca, Romania and partially my research activity too. The presented topics are useful for engineers, M.Sc. and PhD students who need basics in...

How to Feed Friends and Influence People: The Carnegie Deli...A Giant Sandwich, a Little Deli, a Huge Success
How to Feed Friends and Influence People: The Carnegie Deli...A Giant Sandwich, a Little Deli, a Huge Success
the show--and the deli--must go on
In the early morning hours of February 7th, the Carnegie Deli experienced its most unusual takeout order: armed robbers wanted the cash.
The deli always stayed open until 4 a.m. and then re-opened its doors at 6 a.m. The seven robbers must have canvassed the place or received an inside tip about the
...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy