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

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.)

Project 2016 For Dummies
Project 2016 For Dummies

The easy way to take control of project timelines, resources, budgets, and details

Project manager, meet your new assistant! Once you discover Project 2016 you'll be amazed at how efficient and effective the project management process can be. Written by an expert author who knows project management processes backward and...

Practical RF Handbook, Fourth Edition (EDN Series for Design Engineers)
Practical RF Handbook, Fourth Edition (EDN Series for Design Engineers)

Radio Frequency (RF) is the fundamental technology behind a huge range of modern consumer electronics and wireless communication devices, and this book provides a comprehensive and methodical guide to RF for engineers, technicians, enthusiasts and hobbyists with an interest in the electronics behind radio frequency communications.

Fedora 11 and Red Hat Enterprise Linux Bible
Fedora 11 and Red Hat Enterprise Linux Bible
The leading Fedora book-over a quarter of a million copies sold of previous editions!

What better way to learn Fedora 11 than with the leading Fedora book from the best-selling Linux author, Christopher Negus with Eric Foster Johnson? Whether you're new to Linux or an advanced user, this power-packed guide is loaded with...

Principles of Nanophotonics (Optics and Optoelectronics)
Principles of Nanophotonics (Optics and Optoelectronics)
The Theory and Applications of Nanophotonics Devices, Fabrication, and Systems

Coauthored by the developer of nanophotonics, Principles of Nanophotonics outlines physically intuitive concepts of the subject using a novel theoretical framework that differs from conventional wave optics. It probes far-reaching physical...

Handbook of Atopic Eczema
Handbook of Atopic Eczema
Atopic eczema is one of the most frequent inflammatory skin diseases and its prevalence is rising. It presentsmajor problems for patients and physicians as well as for researchers all over the world. Few diseases are discussed as heatedly. Atopic eczema seems to be in the midst of debates regarding scientificmedicine versus...
Inside the Box: Leading With Corporate Values to Drive Sustained Business Success
Inside the Box: Leading With Corporate Values to Drive Sustained Business Success

How to turn company values into competitive advantage

We are inclined, for whatever reason, to treat values like works of art. We view them as nice to hang on the wall, and beautiful to look at, but we don’t act as though they truly mean much to us in the real world. In fact, the opposite is true. The best...

©2021 LearnIT (support@pdfchm.net) - Privacy Policy