Ebook: Oracle SQL by Example, Fourth Edition

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!