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.

Comments

Amazing Books

Developer's Guide to Microsoft Enterprise Library, C# Edition

Microsoft Press, 2010

Welcome to the era of software reuse! Microsoft Enterprise Library helps accelerate development by providing reusable components and guidance on proven practices. If you build applications that run on the Microsoft .NET Framework, whether they are enterprise-level business applications or even relatively modest Windows® Forms,...

Sams Teach Yourself Macromedia Flash MX 2004 in 24 Hours

Sams Publishing, 2003

Since its introduction in 1996, Macromedia Flash has become the standard for delivering high impact, vector-based graphics to the Web. Flash is deceptively simple at first, yet has great depth and flexibility.Sams Teach Yourself Macromedia Flash 5 in 24 Hours offers a clearly written, well-organized introduction to this powerful product, and gives...

The Concept of Capitalism

Springer, 2009

A single system of economic governance – capitalism – prevails in the world today, both in theory and in practice. Yet there is neither a standard definition of capitalism nor a theory of how it works. Moreover, the most common conception of capitalism is that of a one-level system governed by markets, i.e., supply and demand, where...

C# 6.0 Pocket Reference: Instant Help for C# 6.0 Programmers

O'Reilly, 2015

When you need answers for programming with C# 6.0, this practical and tightly focused book tells you exactly what you need to know—without long introductions or bloated samples. Easy to browse, it’s ideal as a quick reference or as a guide to get you rapidly up to speed if you already know Java, C++, or an earlier version...

Multidimensional Databases and Data Warehousing (Synthesis Lectures on Data Management)

Morgan and Claypool Publishers, 2010

The present book's subject is multidimensional data models and data modeling concepts as they are applied in real data warehouses. The book aims to present the most important concepts within this subject in a precise and understandable manner. The book's coverage of fundamental concepts includes data cubes and their elements, such as...

Beginning XML with C# 2008: From Novice to Professional (Expert's Voice in .Net)

Apress, 2008

Beginning XML with C# 2008 focuses on XML and how it is used within .NET 3.5. As you’d expect of a modern application framework, .NET 3.5 has extensive support for XML in everything from data access to configuration, from raw parsing to code documentation. This book demystifies all of this. It explains the basics of XML as well as...