Design Feature-Rich PL/SQL Applications

Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You’ll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance.

• Create, debug, and manage Oracle-driven PL/SQL programs
• Use PL/SQL structures, delimiters, operators, variables, and statements
• Identify and eliminate errors using PLSQL_WARNINGS and exception handlers
• Work with functions, procedures, packages, collections, and triggers
• Define and deploy varray, nested table, and associative array data types
• Handle external routines, object types, large objects, and secure files
• Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE
• Call external procedures through Oracle Net Services and PL/SQL wrappers
• Integrate internal and server-side Java class libraries using Oracle JVM
• Develop robust Web applications using PL/SQL Gateway and Web Toolkit

See Details

Audio producer Jeff Sobel is your guide to the only professional audio post-production application designed specifically for the Final Cut editor: Soundtrack Pro 3. Working seamlessly between Final Cut Pro and Soundtrack Pro, you’ll master audio restoration and clean-up, build and edit multitrack projects, record and edit voice-overs and narration, and experiment with advanced mixing and effects.

Using footage from the hit TNT show Leverage and the gorgeous HD documentary OneSixRight, this step-by-step, Apple-certified guide starts with sound editing and mixing basics in Final Cut Pro, and moves on to the fine points of fixing audio files, working with the frequency spectrum, recording and editing dialogue, and spotting sound effects in Soundtrack Pro. Finally, you’ll score a sophisticated multitrack montage sequence, and mix and conform it to professional standards. Whether you’re a seasoned editor or just getting started, this book shows you how to use Final Cut Studio as an integrated package to produce superb audio and sound design.

• DVD-ROM includes lesson and media files

• Focused lessons take you step by step through real-world projects

• Accessible writing style puts expert instructors at your side

• Ample illustrations help you master techniques fast

• Lesson goals and time estimates help you plan your time

• Chapter review questions summarize what you’ve learned and help you prepare for the Apple Pro certification exam

See Details

Tackle the toughest set-based querying and query tuning problems guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals and gain practical approaches and advanced techniques to optimize your code’s performance. Discover how to: Move from procedural programming to the language of sets and logic Optimize query tuning with a top-down methodology Assess algorithmic complexity to predict performance Compare data-aggregation techniques, including new grouping sets Manage data modification insert, delete, update, merge for performance Write more efficient queries against partitioned tables Work with graphs, trees, hierarchies, and recursive queries Plus Use pure-logic puzzles to sharpen your problem-solving skills

See Details

The exciting new book on the exciting new Blender 2.5!

If you want to design 3D animation, here’s your chance to jump in with both feet, free software, and a friendly guide at your side! Blender For Dummies, 2^nd Edition is the perfect introduction to the popular, open-source, Blender 3D animation software, specifically the revolutionary new Blender 2.5. Find out what all the buzz is about with this easy-access guide. Even if you’re just beginning, you’ll learn all the Blender 2.5 ropes, get the latest tips, and soon start creating 3D animation that dazzles.

• Walks you through what you need to know to start creating eye-catching 3D animations with Blender 2.5, the latest update to the top open-source 3D animation program
• Shows you how to get the very most out of Blender 2.5’s new multi-window unblocking interface, new event system, and other exciting new features
• Covers how to create 3D objects with meshes, curves, surfaces, and 3D text; add color, texture, shades, reflections and transparency; set your objects in motion with animations and rigging; render your objects and animations; and create scenes with lighting and cameras

If you want to start creating your own 3D animations with Blender, Blender For Dummies, 2^nd Edition is where you need to start!

See Details

The definitive iLife reference, completely updated and revised!

The Macintosh iLife ‘09 is a lavishly illustrated handbook packed with easy-to-follow instructions, essential technical background, and tips for iLife users of all levels.

Each two-page spread is a self-contained tutorial or set of tips. Everything you need is at your fingertips, and every page is updated for iLife ‘09, including coverage of the Faces feature in iPhoto that allows users to organize their photos based on who’s in them, the new Animated Travel Maps in iMovie that enhances vacation movies with eye-catching animations and much more!

• Organize your photos using iPhoto’s new Faces facial-recognition and Places geotagging technologies
• Share your photos on Flickr and Facebook
• Create spectacular slide shows using iPhoto’s new slide show themes
• Master the spectacular new features iMovie ‘09, including the precision editor, motion stabilization, video effects, and motion- graphics themes
• Improve your photography and video-shooting techniques
• Assemble a video library with the all-new iMovie-and create animated Travel Maps in your scenes
• Produce spectacular slide shows, photo books, calendars, and greeting cards
• Record and arrange your own music with GarageBand
• Create and publish your own Web sites, blogs, and podcasts
• Preserve the past: digitize old records, photos, and movies

Get updates, tips, and much more at this book’s companion Web site, www.macilife.com.

See Details