The
book...has enough depth for even a seasoned professional to pick up
enough tips to pay back the price of the book
many times
over.
Dr.
Paul Dorsey, President, Dulcian, Inc., Oracle Magazine
PL/SQL Developer of the Year 2007, and President
Emeritus, New York Oracle Users
Group
This
is a fascinating guide into the world of Oracle SQL with an
abundance of well-collected examples. Without a doubt, this
book is helpful to beginners and experts
alike who seek alternative ways to resolve advanced
scenarios.Oleg Voskoboynikov, Ph.D., Database
Architect
The
Worlds #1 Hands-On Oracle SQL WorkbookFully Updated
for Oracle 11g
Crafted for
hands-on learning and tested in classrooms worldwide, this book
illuminates in-depth every Oracle SQL technique youll need.
From the simplest query fundamentals to regular expressions and
with newly added coverage of Oracles powerful new SQL
Developer tool, you will focus on the tasks that matter most.
Hundreds of step-by-step, guided lab exercises will systematically
strengthen your expertise in writing effective, high-performance
SQL. Along the way, youll acquire a powerful arsenal of
useful skillsand an extraordinary library of solutions for
your real-world challenges with Oracle SQL.
Coverage
includes
100%
focused on Oracle SQL for Oracle 11g, todays #1
database platformnot generic SQL!
Master all
core SQL techniques including every type of join such as equijoins,
self joins, and outer joins
Understand
Oracle functions in depth, especially character, number, date,
timestamp, interval, conversion, aggregate, regular expressions,
analytical, and more
Practice
all types of subqueries, such as correlated and scalar subqueries,
and learn about set operators and hierarchical queries
Build
effective queries and learn fundamental Oracle SQL Developer and
SQL*Plus skills
Make the
most of the Data Dictionary and create tables, views, indexes, and
sequences
Secure
databases using Oracle privileges, roles, and synonyms
Explore
Oracle 11gs advanced data warehousing features
Learn many
practical tips about performance optimization, security, and
architectural solutions
Avoid
common pitfalls and understand and solve common mistakes
For every database developer,
administrator, designer, or architect, regardless of
experience!