Oracle SQL by Example, Fourth Edition

Description

Thebook...has enough depth for even a seasoned professional to pick upenough tips to pay back the price of the bookmany timesover.Dr.Paul Dorsey, President, Dulcian, Inc., Oracle MagazinePL/SQL Developer of the Year 2007, and PresidentEmeritus, New York Oracle UsersGroupThisis a fascinating guide into the world of Oracle SQL with anabundance of well-collected examples. Without a doubt, thisbook is helpful to beginners and expertsalike who seek alternative ways to resolve advancedscenarios.Oleg Voskoboynikov, Ph.D., DatabaseArchitectTheWorlds #1 Hands-On Oracle SQL WorkbookFully Updatedfor Oracle 11gCrafted forhands-on learning and tested in classrooms worldwide, this bookilluminates in-depth every Oracle SQL technique youll need.From the simplest query fundamentals to regular expressions andwith newly added coverage of Oracles powerful new SQLDeveloper tool, you will focus on the tasks that matter most.Hundreds of step-by-step, guided lab exercises will systematicallystrengthen your expertise in writing effective, high-performanceSQL. Along the way, youll acquire a powerful arsenal ofuseful skillsand an extraordinary library of solutions foryour real-world challenges with Oracle SQL.Coverageincludes100%focused on Oracle SQL for Oracle 11g, todays #1database platformnot generic SQL!Master allcore SQL techniques including every type of join such as equijoins,self joins, and outer joinsUnderstandOracle functions in depth, especially character, number, date,timestamp, interval, conversion, aggregate, regular expressions,analytical, and morePracticeall types of subqueries, such as correlated and scalar subqueries,and learn about set operators and hierarchical queriesBuildeffective queries and learn fundamental Oracle SQL Developer andSQL*Plus skillsMake themost of the Data Dictionary and create tables, views, indexes, andsequencesSecuredatabases using Oracle privileges, roles, and synonymsExploreOracle 11gs advanced data warehousing featuresLearn manypractical tips about performance optimization, security, andarchitectural solutionsAvoidcommon pitfalls and understand and solve common mistakesFor every database developer,administrator, designer, or architect, regardless ofexperience!