"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 World's #1 Hands-On
Oracle SQL Workbook-Fully Updated for Oracle 11g Crafted for
hands-on learning and tested in classrooms worldwide, this book
illuminates in-depth every Oracle SQL technique you'll need. From
the simplest query fundamentals to regular expressions and with
newly added coverage of Oracle's 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, you'll acquire a powerful arsenal of useful skills-and an
extraordinary library of solutions for your real-world challenges
with Oracle SQL. Coverage includes 100% focused on Oracle SQL for
Oracle 11 g, today's #1 database platform-not "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 11 g's 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!
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!