0 Item

Oracle SQL

Jumpstart with Examples

By: Gavin JT Powell, Carol McCullough-Dieter

Write A Review

Paperback | 1 November 2004

At a Glance

Paperback
688 Pages

Dimensions(cm)
23.5 x 19.1 x 3.68

Paperback

$313.25

or 4 interest-free payments of $78.31 with

Aims to ship in 10 to 15 business days

When will this arrive by?
Enter delivery postcode to estimate

Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL.

* Each of the hundreds of SQL code examples was tested on a working Oracle 10g database
* Invaluable everyday tool that provides an absolute plethora of properly tested examples of Oracle SQL code
* Authors have four decades of commercial experience between them as developers and database administrators

Industry Reviews

"As a consultant with more than 12 years of experience working with Oracle databases on a daily basis, reviewing this book was a unique and enjoyable experience. The SQL language is without doubt one of the most critical database skills and it is best learned by example. This book addresses that crucial need. Mr. Powell does an excellent job of clarifying the concepts by using meaningful and easy to understand examples. Frankly, I have not come across any other book on SQL that is as good a compilation of SQL concepts in a single source as this book. One comes across very few books that make a significant difference in your fundamental understanding of the subject. This is one such book if you want to understand a core database skill - SQL. This book deserves a place in your library and you will find it a great reference not only for learning SQL but also for learning data relationships, data organization, data analysis possibilities and so forth. I feel that the title, Oracle SQL: Jumpstart with Examples, might be too simplistic to describe the content. Read on, you will find the real value hidden inside this book." -- Ravi Sharma, Senior Principal Consultant

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Database Programming Databases Database Software Oracle

Foreword	p. xix
Preface	p. xxi
Acknowledgements	p. xxix
Introduction to Oracle SQL	p. 1
A Little History	p. 1
The Basics of Relational Data Modeling	p. 8
Structured Query Language (SQL)	p. 14
Software Useful for Reading this Book	p. 16
Syntax Conventions Used in This Book	p. 17
SQL Tools	p. 19
The MUSIC Schema	p. 34
New Features of Oracle SQL	p. 39
New Features in Oracle Database 10g	p. 39
New Features in Oracle Database 9i	p. 46
Oracle Database Architecture	p. 51
The Basic Concepts	p. 51
The Oracle Instance	p. 58
Oracle Database Physical Architecture	p. 60
Database Startup and Shutdown	p. 65
Enhancing the Physical Architecture	p. 67
The SELECT Statement	p. 73
The Basic SELECT Statement	p. 73
Types of SELECT Queries	p. 81
Other Aspects of the SELECT Statement	p. 88
Filtering Rows	p. 97
WHERE Clause Syntax	p. 97
WHERE Clause Expression Conditions	p. 101
Logical Operators in the WHERE Clause	p. 105
Top-N Queries	p. 105
Sorting Rows	p. 109
ORDER BY Clause Syntax	p. 109
Sorting and Null Values	p. 113
Sorting Methods	p. 117
Operators, Conditions, and Pseudocolumns	p. 123
Precedence	p. 124
Operators	p. 124
Conditions	p. 131
Pseudocolumns	p. 134
Using SQL*Plus	p. 137
Environmental Settings	p. 137
Using Scripts and Variables	p. 148
Formatting Query Output in SQL*Plus	p. 153
Using iSQL*Plus	p. 165
Single-Row Functions	p. 175
Types of Functions	p. 176
Single-Row Functions	p. 176
Combining Functions	p. 196
Joining Tables	p. 205
Join Formats	p. 206
Types of Joins	p. 207
Examining Different Types of Joins	p. 210
Grouping and Summarizing Data	p. 235
GROUP BY Clause Syntax	p. 235
Types of Group Functions	p. 237
Special Grouping Function Behavior	p. 245
Using the GROUP BY Clause	p. 249
The SPREADSHEET (MODEL) Clause	p. 260
Subqueries	p. 267
Types of Subqueries	p. 267
Where Can Subqueries Be Used?	p. 269
Comparison Conditions and Subqueries	p. 269
Demonstrating Subqueries	p. 270
Unusual Query Types	p. 285
Composite Queries	p. 285
Hierarchical Queries	p. 289
Flashback and Versions Queries	p. 292
Parallel Queries	p. 297
Expressions	p. 301
Types of Expressions	p. 302
Regular Expressions	p. 305
Oracle Expression Filter	p. 309
Data Manipulation Language (DML)	p. 315
What Is DML?	p. 315
Transaction Control	p. 317
Adding Data (INSERT)	p. 324
Changing Data (UPDATE)	p. 330
Deleting Data (DELETE)	p. 334
Merging New and Old Data (MERGE)	p. 336
Datatypes and Collections	p. 339
Simple Datatypes	p. 339
Complex and Object Datatypes	p. 342
Special Datatypes	p. 355
XML in Oracle	p. 357
What Is XML?	p. 357
Using XML in Oracle	p. 360
Metadata Views	p. 380
Tables	p. 383
What Is a Table?	p. 383
CREATE TABLE Syntax	p. 387
Creating Different Table Types	p. 388
Changing Table Structure	p. 407
Dropping a Table	p. 414
Adding Comments to Tables	p. 416
The Recycle Bin	p. 420
Metadata Views	p. 421
Views	p. 425
What Is a View?	p. 425
Types and Uses of Views	p. 426
CREATE VIEW Syntax	p. 427
Changing and Dropping Views	p. 433
Working with Views	p. 435
Metadata Views	p. 441
Data Dictionary Views (Metadata)	p. 442
Constraints	p. 447
What Are Constraints?	p. 448
Managing Constraints	p. 449
Adding, Modifying, and Dropping Constraints	p. 460
Metadata Views	p. 469
Indexes and Clusters	p. 471
Indexes	p. 471
Clusters	p. 484
Metadata Views	p. 487
Sequences and Synonyms	p. 489
Sequences	p. 489
Synonyms	p. 498
Metadata Views	p. 501
Security	p. 503
Users	p. 503
Privileges	p. 511
Grouping Privileges Using Roles	p. 522
Metadata Views	p. 530
Basic PL/SQL	p. 531
What is PL/SQL?	p. 531
Why Is PL/SQL a Programming Language?	p. 532
Variables and Datatypes in PL/SQL	p. 541
Retrieving Data in PL/SQL	p. 543
Changing Data in PL/SQL	p. 549
Dynamic SQL	p. 550
Control Structures	p. 553
Objects and Methods	p. 567
Oracle-Provided Packages	p. 567
Metadata Views	p. 568
Schema Scripting	p. 569
Utility Scripts	p. 623
Sources of Information	p. 625
Index	p. 627
Table of Contents provided by Ingram. All Rights Reserved.

Oracle SQL

Jumpstart with Examples

At a Glance

Paperback

Industry Reviews

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Databases

Microsoft 365 Access For Dummies

SPSS Survival Manual

7th Edition - A step by step guide to data analysis using IBM SPSS

Python All-in-One For Dummies

3rd Edition

Big Data, IoT, and Machine Learning

Tools and Applications

Intelligent Manufacturing

Exploring AI, Blockchain, and Smart Technologies in Industry 4.0

The Art of Data Science

A Practitioner's Guide

The Art of Explanation

How to Communicate with Clarity and Confidence

Fundamentals of Data Science

Database Management System

An Evolutionary Approach

Big Data Applications in Industry 4.0

Machine Learning for Healthcare

Handling and Managing Data

Citizen Empowerment through Digital Transformation in Government

Bioinformatics

A Practical Guide to NCBI Databases and Sequence Alignments

The Art of Data Science

A Practitioner's Guide

Theoretical Computer Science

42nd National Conference, NCTCS 2024, Qingdao, China, July 19-21, 2024, Revised Selected Papers

Data Science from Scratch

First Principles with Python

Deciphering Data Architectures

Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh

R for Data Science

Import, Tidy, Transform, Visualize, and Model Data

Think Stats

Exploratory Data Analysis

Designing Data-Intensive Applications

Big Ideas Behind Reliable, Scalable, and Maintainable Systems

The Digital Humanities Coursebook

An Introduction to Digital Methods for Research and Scholarship

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

Python for Data Analysis 3e

Data Wrangling with pandas, NumPy, and Jupyter

Social Research Methods

4th Edition

This product is categorised by