Oracle SQL By Example

Oracle SQL By Example

<P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px" align=left text-align="left">€œThe book...has enough depth for even a seasoned professional to pick up enough tips to pay back the price of the book</P> <P style="MARGIN: 0px" align=left text-align="left">many times over.€</P> <P style="MARGIN: 0px" align=left text-align="left">€“Dr. Paul Dorsey, President, Dulcian, Inc., <I>Oracle </I>Magazine PL/SQL Developer of the Year 2007, and President</P> <P style="MARGIN: 0px">Emeritus, New York Oracle Users Group<I> </I> </P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px" align=left text-align="left">€œThis is a fascinating guide into the world of Oracle SQL with an abundance of well-collected examples. Without a doubt, this</P> <P style="MARGIN: 0px">book is helpful to beginners and experts alike who seek alternative ways to resolve advanced scenarios.€€“Oleg Voskoboynikov, Ph.D., Database Architect</P> <P style="MARGIN: 0px" align=left text-align="left"> </P> <B> <P style="MARGIN: 0px" align=left text-align="left">The World€s #1 Hands-On Oracle SQL Workbook€“Fully Updated for Oracle 11<I>g</P> </B> </I> <P style="MARGIN: 0px" align=left text-align="left"> </P> <P style="MARGIN: 0px" align=left text-align="left">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.</P> <P style="MARGIN: 0px" align=left text-align="left"> </P> <P style="MARGIN: 0px" align=left text-align="left">Coverage includes </P> <P style="MARGIN: 0px" align=left text-align="left"> </P> <UL> <LI> <DIV style="MARGIN: 0px" align=left text-align="left">100% focused on Oracle SQL for Oracle 11<I>g</I>, today€s #1 database platform€“not €œgeneric€ SQL!</DIV> </LI> <LI> <DIV style="MARGIN: 0px" align=left text-align="left">Master all core SQL techniques including every type of join such as equijoins, self joins, and outer joins</DIV> </LI> <LI> <DIV style="MARGIN: 0px" align=left text-align="left">Understand Oracle functions in depth, especially character, number, date, timestamp, interval, conversion, aggregate, regular expressions, analytical, and more</DIV> </LI> <LI> <DIV style="MARGIN: 0px" align=left text-align="left">Practice all types of subqueries, such as correlated and scalar subqueries, and learn about set operators and hierarchical queries</DIV> </LI> <LI> <DIV style="MARGIN: 0px" align=left text-align="left">Build effective queries and learn fundamental Oracle SQL Developer and SQL*Plus skills</DIV> </LI> <LI> <DIV style="MARGIN: 0px" align=left text-align="left">Make the most of the Data Dictionary and create tables, views, indexes, and sequences</DIV> </LI> <LI> <DIV style="MARGIN: 0px" align=left text-align="left">Secure databases using Oracle privileges, roles, and synonyms</DIV> </LI> <LI> <DIV style="MARGIN: 0px" align=left text-align="left">Explore Oracle 11<I>g€</I>s advanced data warehousing features</DIV> </LI> <LI> <DIV style="MARGIN: 0px" align=left text-align="left">Learn many practical tips about performance optimization, security, and architectural solutions</DIV> </LI> <LI> <DIV style="MARGIN: 0px" align=left text-align="left">Avoid common pitfalls and understand and solve common mistakes</DIV> </LI> <LI> <DIV style="MARGIN: 0px"> <B>For every database developer, administrator, designer, or architect, <I>regardless of experience!</I> </B> </DIV> </LI> </UL>