studybooks

Test

2008-08-21T04:06:00.000-07:00

4pak

Adobe Photoshop CS3: Top 100 Simplified Tips & Tricks

2008-06-23T02:47:00.000-07:00

Information:

Quote:

You already know Photoshop CS3 basics. Now you'd like to go beyond with shortcuts, tricks, and tips that let you work smarter and faster. And because you learn more easily when someone shows you how, this is the book for you. Inside, you'll find clear, illustrated instructions for 100 tasks that reveal cool secrets, teach timesaving tricks, and explain great tips guaranteed to make you more productive with Photoshop CS3.

1. Minimal text and maximum illustrations
2. Task-oriented, step-by-step approach
3. Navigational aids connect instructions to illustrations
4. Self-contained, two-page lessons
5. Uniform layout makes it easy to read less, learn more
How easy is it?
Look for these symbols marking the difficulty of each task.

* Demonstrates a new spin on a common task
* Introduces a new skill or a new task
* Combines multiple skills requiring in-depth knowledge
* Requires extensive skill and may involve other technologies

source

Photoshop CS3 Restoration And Retouching Bible

2008-06-23T02:38:00.000-07:00

Language: English
Author: Mark Fitzgerald
Released by: Wiley
Date: March 2008
File type: PDF, 30MB
RAR size: 24MB

The Photoshop CS3 Restoration and Retouching Bible is a full-color comprehensive reference to retouching and restoring photographs using Adobe Photoshop CS3.
Written by an Adobe Certified Expert and Adobe Certified Instructor in Photoshop CS & CS2, Mark Fitzgerald, the Photoshop CS3 Restoration and Retouching Bible provides training, tips, and techniques for amateur to professional photographers who want to complete expert quality photo restorations and retouchings.
The book begins by reviewing the fundamentals of working with digital images - covering adjusting image brightness and contrast, working with color, understanding RAW and high-bit files, working with layers, and getting organized.
Fitzgerald guides readers through all of the relevant Photoshop tools and techniques including a full chapter on creating flexibility with layer masks.
A robust four-chapter section on rescuing damaged photos enables readers to bring their damaged images back to life.
The final section of the book focuses on adding the final touches to images - retouching, with hands-on examples of retouching portraits and architectural projects.

Part I: Digital Image Fundamentals.
Chapter 1: Adjusting Image Brightness and Contrast.
Chapter 2: Working with Color.
Chapter 3: Understanding Raw and High-Bit Files.
Chapter 4: Working with Layers.
Chapter 5: Getting Organized.

Part II: Photoshop Tools and Techniques.
Chapter 6: Using Photoshop’s Main Retouching Tools.
Chapter 7: Working with Selections.
Chapter 8: Creating Flexibility with Layer Masks.

Part III: Restoration—Rescuing Damaged Photos.
Chapter 9: Starting with the Scan.
Chapter 10: Solving Typical Repair Problems.
Chapter 11: Finishing Touches.
Chapter 12: Hands-on Restoration Project: The Complete Workflow.

Part IV: Retouching—Taking Images to the Next Level.
Chapter 13: Using Strategies for Success.
Chapter 14: Solving Special Portrait Retouching Problems.
Chapter 15: Hands-on Portrait Retouching Project: The Complete Workflow.
Chapter 16: Hands-on Architectural Retouching Project.

http://rapidshare.com/files/123665089/rebible.rar

www.warezscene.org

source

2008-06-03T07:56:00.001-07:00

You've played plenty of games. Now it's time to create your own! "Game Programming for Teens, Second Edition" helps you develop the skills you need to create every element of your first video game - from graphics and animation to sound and music. You'll even learn how to incorporate artificial intelligence. You don't have to have any programming experience to get started. You'll learn everything you need to know along the way using BlitzPlus, an easy-to-learn programming language that the author will teach you. By the end of the book, you will have created your first computer game. Game programming doesn't have to be difficult. With a copy of this book and your own curiosity, you're off to the perfect start!

Download:rapidshare.com
Download:depositfiles.com

2008-06-03T07:54:00.000-07:00

IF EVIL'S YOUR NAME, THEN THESE ARE YOUR GAMES!

Always wanted to be a genius game creator? This Evil Genius guide goes far beyond a typical programming class or text to reveal insider tips for breaking the rules and constructing wickedly fun games that you can tweak and customize to suit your needs!

In Programming Video Games for the Evil Genius, programming wunderkind Ian Cinnamon gives you everything you need to create and control 57 gaming projects. You'll find easy-to-follow plans featuring Java, the most universal programming language, that run on any PC, Mac, or Linux computer.

*Illustrated instructions and plans for an awesome mix of racing, board, shoot 'em up, strategy, retro, and puzzle games
*Gaming projects that vary in difficulty-starting with simple programs and progressing to sophisticated projects for programmers with advanced skills
*An interactive companion website featuring a free Java compiler, where you can share your projects with Evil Geniuses around the globe
*Removes the frustration-factor-all the parts you need are listed, along with sources

Regardless of your skill level, Programming Video Games for the Evil Genius provides you with all the strategies, code, and insider programming advice you need to build and test your games with ease, such as:

*Radical Racing
*Screen Skier
*Whack an Evil Genius
*Tic-Tac-Toe Boxing
*Snake Pit
*Space Destroyers
*Bomb Diffuser
*Trapper
*Oiram
*Java Man
*Memory
*Ian Says

Download:rapidshare.com

Download:depositfiles.com

2008-06-03T07:52:00.000-07:00

Would you like to create your own games, but never have the time to dig into the details of multimedia programming? Now you donбпt have to! XNA makes it simple to create your own games, which will run on your PC and Xbox 360 console. Even if you donбпt know how to program at all, Beginning XNA 2.0 Game Programming: From Novice to Professional will teach you the basics of C# 2005 programming along the way. Donбпt get overwhelmed with details you donбпt need to knowбк just learn what you need to start creating your own games right now!The fast and Cpaced introduction to XNA and the C# language provides professional developers a quick-start guide to creating a commercial product using XNA, as well as offering home enthusiasts or hobbyists everything they need to begin putting together games in their spare time. Youбпll discover and understand all the key concepts required to create smooth, professionalиClooking results in a range of gaming genres. Every reader will come away with a firm foundation onto which they can build more advanced ideas. What youбпll learn
*An introduction to the C# language
*Basics of game programming
*XNA basics
*Xbox 360 controller and keyboard input
*Fully worked examples of how to create 2D and 3D games

Download:rapidshare.com

Download:depositfiles.com

2008-06-02T14:06:00.000-07:00

FileMaker 8 Functions and Scripts Desk Reference is the only book on the market expressly focused on describing each calculation formula and how and when to use each one. With this book's real-world, concrete examples of how to use each function, you will go far beyond FileMaker 8's help system. Just as a dictionary helps supplement one's memory, this book is an invaluable companion to users working to develop solutions to their every day software problems.

Download:rapidshare.com

2008-06-02T14:05:00.000-07:00

FileMaker Pro8 Bible has been updated to reflect Version 8, the latest version of FileMaker Pro workgroup database. The book is applicable to both the Mac and Windows versions of FileMaker Pro and has comprehensive coverage of FileMaker Pro, providing step-by-step procedures for virtually all FileMaker Pro tasks and features. It shows readers how to create and work with databases and includes detailed ScriptMaker (scripting) explanations for automating FileMaker. Other topics covered include calculations and computations; data exchange; creating and using templates; linking databases; using FileMaker in workgroups; Web publishing; plug-ins; and advanced database connectivity. In this revision, major examples will be updated to employ any relevant features new to FileMaker Pro 8. Other examples will be expanded and clarified.

Download:rapidshare.com

2008-06-02T14:04:00.002-07:00

If youбпre looking for the inside scoop on the latest version of FileMaker, youбпve come to the right place. Authors Scott Love and Steve Lane are FileMaker experts who were involved in the development of FileMaker 8, and they bring that knowledge to you in Special Edition Using FileMaker 8. Frequent tips, case studies, and thorough examples show you how to avoid mistakes and save time in developing databases with FileMaker 8. This is the comprehensive reference that every database developer needs on their shelf.

Download:rapidshare.com

2008-06-02T14:04:00.001-07:00

If you want to make a great-looking, practical database fast but don't want to get bogged down with the details, then you need a Visual QuickProject Guide! If you've never created a database before, the task can be daunting. Recognizing that you don't necessarily want or need to know about every FileMaker Pro 8 feature, this low-priced, compact guide is the quickest route to creating a functional, organized database. Whether you're a small business owner looking for a better way to track inventory and invoices, someone just looking for a streamlined way to keep track of your contacts, or your boss simply needs a a project database, this book covers the FileMaker Pro 8 basics with full-color illustrations and step-by-step instructions to help you get your project done quickly. The guide also includes a companion Web site with downloadable graphic buttons, custom forms and templates, and more.

Download:rapidshare.com

2008-06-02T14:03:00.002-07:00

Need to learn FileMaker Pro fast? Try a Visual QuickStart Guide!

If you've recently upgraded to FileMaker Pro 8, teach yourself this powerful database software the quick and easy way! Using pictures rather than lengthy explanations, this Visual QuickStart Guide takes you from working with records and files to creating and designing databases, printing and networking with FileMaker, and Web publishing with FileMaker in no time. Step-by-step tasks show you how to use new features like PDF and Excel makers; fast match, fast send, layout alignment, email merge, and table import tools; and popular features like digital image management to organize digital photos with minimal effort and XML support to easily share and integrate data with other applications--even those not running FileMaker. This affordably priced, reference style book also includes a companion Web site with excerpts, tips, related links, and more. You'll be up and running in no time!

Download:rapidshare.com

2008-06-02T14:03:00.001-07:00

For database software, FileMaker Pro has always been almost shockingly easy to use. However, somewhere along the way it also became incredibly powerful-so much so, in fact, that's it's no longer about just creating small-scale relational databases. If you're ready to move beyond the basics and take advantage of FileMaker Pro 7's advanced features, this task-based guide provides the key. By applying the same visual approach, step-by-step instructions, and concise explanations employed by the popular Visual QuickStart Guides to complex topics like creating and managing links between fields in multiple tables and employing the advanced security features to define which fields are editable by different user categories, this handy guide represents the most efficient way for experienced FileMaker users to take their skills to the next level. By the end of the volume, you'll be creating custom databases, using advanced querying features, and managing huge volumes of complex data (text, video, images, audio, PDFs, and more) with FileMaker Pro 7!

Download:rapidshare.com

2008-06-02T14:02:00.000-07:00

FileMaker Pro 8.5 Bible provides step-by-step procedures for using virtually all FileMaker Pro features and performing all tasks. This best-selling volume has been updated to reflect Version 8.5, the latest version of FileMaker Pro workgroup database. Applicable to both the Mac and Windows versions of FileMaker Pro, this Bible shows readers how to create and work with databases and includes detailed ScriptMaker (scripting) explanations for automating FileMaker. Other topics covered include calculations and computations; data exchange; creating and using templates; linking databases; using FileMaker in workgroups; Web publishing; plug-ins; and advanced database connectivity.

Download:rapidshare.com

2008-06-02T14:01:00.000-07:00

Whether you are a FileMaker developer who is new to web publishing, a web developer who is new to FileMaker, or a complete beginner looking to put your data online, this book is for you.

In Part I, you learn the basics of how web publishing works and how to write your own HTML and PHP. In Part II, you learn how to build a FileMaker database and install and configure the FileMaker Server to host the database. In Part III, you learn how to put it all together to create web pages that talk to your database and allow people to view the data and, if you like, modify it. Throughout the book, publishing a FileMaker Product Catalog to the web is used as an example. Each chapter builds on the previous chapter. When you are done, you will have a working website!

Detailed information on how toбн
*Master web publishing
*Read and write basic HTML
*Read and write basic PHP
*Build a FileMaker database
*Install and configure FileMaker Server
*Publish your FileMaker data to the web
*Work with portals and container fields
*Repurpose your FileMaker layouts on the web

Download:rapidshare.com

Download:rapidshare.com

2008-06-02T14:00:00.002-07:00

FileMaker Web Publishing offers an unparalleled development strategy for database managers, web designers, and programmers who are interested in getting the most out of FileMaker databases on the web. As the book covers both introductory web publishing and advanced database programming on the web, it is ideal for all skill levels.

Download:rapidshare.com

Download:depositfiles.com

2008-06-02T14:00:00.001-07:00

With this new version of the software, FileMaker Pro expands the dramatically new and efficient approach to database management that gives users exceptional flexibility. This book explores the features of the product--both new and old--and identifies situ

Download:rapidshare.com

Download:depositfiles.com

2008-06-02T13:57:00.001-07:00

This book will look at Structured Query Language, or SQL as itбпs usually abbreviated. SQL works with adatabase to create the database and to insert and extract data. Therefore, itбпs essential to understand the theory and concepts behind database systems. Hence, this book also covers database theory and database design, so that youбпre equipped to create an effective database.

The SQL code in this book reflects the modern SQL standards set by organizations such as the American National Standards Institute (ANSI) and the International Standards Organization (ISO). However,while standards are great, whatбпs available for practical use is what really counts. This book, then, concentrates on the sort of SQL supported by most modern database systems. You should that find most of the code runs with little or no modification on most database systems released within the last six or seven years.

Download:rapidshare.com

2008-06-02T13:56:00.000-07:00

Gives programmers two-in-one coverage, with both a ""how-to"" on SQL functions and a complete SQL functions reference SQL is the standard language for database queries; this book's advanced coverage helps programmers write their own SQL functions Covers both the internationally standardized SQL 99 functions and the hundreds of additional functions introduced by vendors, including the subtle variations required to successfully migrate or interoperate between vendor products Covers the latest versions of the major relational database management system (RDMS) applications: Microsoft SQL Server, Oracle, IBM DB2, and MySQL

Download:rapidshare.com

2008-06-02T13:54:00.000-07:00

Here, in one definitive volume, is all the information you need to understand and use SQL and its implementations in accordance with the established SQL99 standard. Whether you want to learn database programming from scratch, youбпd like to sharpen your SQL skills, or you need to know more about programming for a heterogeneous database environment, this book provides the complete menu. Tutorials and code examples in each chapter make it an indispensable reference for every level of expertise.

Inside, youбпll find complete coverage of SQL
*Understand the definition and characteristics of relational databases and SQLбпs role within RDBMS
*Recognize vendor-specific implementation variations among Oracle, IBM DB2 UDB, and MS SQL Server
*Create and modify RDBMS objects like tables, views, indexes, synonyms, sequences, and schemas using Data Definition Language (DDL)
*Comprehend Data Manipulation Language (DML) from different vendorsбп perspectives
*Master single-table select statements and multitable queries from the ground up
*Explore in-depth SQL functions, operators, and data types for major RDBMS implementations
*Discover new SQL developments including XML, OLAP, Web services, and object-oriented features

Download:rapidshare.com

2008-06-02T13:53:00.002-07:00

The Microsoft SQL Server 2000implementation of SQL is called Transact-SQL (T-SQL). It encompasses boththese 4GL features plus 3GL programming features, which include IF-ELSE andlooping and other constructs. Except for Chapter 1, which is provided in tutorial form as a quick RDBMSreview, and Appendix B, which covers some Advanced Queries, this material iswritten as a reference, assuming previous exposure to SQL concepts. The book isintended to answer the question of "How exactly do I write a statement to do acertain job?" as well as "What is the full syntax with examples?"It is also essential that the reader refer to the documentation on Web sites and the knowledge base there. Clearly this book contains much information derived from Microsoft SQLServer Books Online, an excellent resource and one which should be used frequently.This book contains less of some detail than the 1000-plus page BooksOnline but has more explanation of what I consider to be core features and moreexamples of useful applications of these features. Together this book and BooksOnline make a powerful combination. Additionally, this book gives information about standard ANSI SQL and willcomment on which MSS SQL statements do not abide by the standard so that yourSQL code may maximize portability to other relational database management systems(RDBMSs).

Download:rapidshare.com

2008-06-02T13:53:00.001-07:00

Designed to exploit Oracle 10g's SQL, this book is a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. In addition, the book covers ollection/object-oriented structures and introduces new Oracle 10g topics like SQL, XML, and statistical functions

Download:rapidshare.com

2008-06-02T13:52:00.000-07:00

You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level.

Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT FROM WHERE . But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:

*Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out
*Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function
*Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set
*Bucketization, and why you should never use that term in Brooklyn.
*How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques
*The technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string

Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.

Download:rapidshare.com

2008-06-02T13:51:00.002-07:00

Anyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly.

If you're new to databases, or need a SQL refresher, Learning SQL on SQL Server 2005 is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft's SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don't need prior database knowledge, or even prior computer knowledge.

Based on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, Learning SQL on SQL Server 2005 starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005. With this book, you'll learn:

*Beginning SQL commands, such as how and where to type an SQL query, and how to create, populate, alter and delete tables
*ow to customize SQL Server 2005's settings and about SQL Server 2005's functions
*bout joins, a common database mechanism for combining tables
*uery development, the use of views and other derived structures, and simple set operations
*ubqueries, aggregate functions and correlated subqueries, as well as indexes and constraints that can be added to tables in SQL Server 2005

Download:rapidshare.com

2008-06-02T13:51:00.001-07:00

Transact-SQL is a powerful implementation of the ANSI standard SQL database query language. In order to build effective database applications, you must gain a thorough understanding of these features. This book provides you with a comprehensive introduction to the T-SQL language and shows you how it can be used to work with both the SQL Server 2000 and 2005 releases.

Beginning with an overview of the SQL Server query operations and tools that are used with T-SQL, the author goes on to explain how to design and build applications of increasing complexity. By gaining an understanding of the power of the T-SQL language, you'll be prepared to meet the ever-increasing demands of programming.

What you will learn from this book
* How T-SQL provides you with the means to create tools for managing hundreds of databases
* Various programming techniques that use views and stored procedures
* Ways to optimize query performance
* How to create databases that will be an essential foundation to applications you develop later

Download:rapidshare.com

2008-06-02T13:50:00.000-07:00

The Practical SQL Handbook begins with a step-by-step introduction to SQL basics and examines the issues involved in designing SQL-based database applications. It fully explores SQL's most popular implementations from industry leaders, Oracle, Microsoft, Sybase, and Informix.

Highlights include:
*Detailed coverage of SQL commands for creating databases, tables, and indexes, and for adding, changing, and deleting data
*Using the SELECT command to retrieve specific data
*Handling NULL values (missing information) in a relational database
*Joining tables, including self joins and outer joins (ANSI and WHERE-clause syntax)
*Working with nested queries (subqueries) to get data from multiple tables
*Creating views (virtual tables) to provide customized access to data
*Using SQL functions

Download:rapidshare.com

2008-06-02T13:49:00.000-07:00

Written by the world's top SQL programmers, this eBook utilizes their substantial knowledge in SQL database programming. With combined experience of over a century, these experts share their secrets for programming with SQL. This is an advanced eBook that explores topics such as using advanced SQL constructs and writing programs that utilize complex SQL queries. Not for the beginner, this eBook explore complex time-based SQL queries, managing set operations in SQL, and relational algebra with SQ...

Download:rapidshare.com

2008-06-02T13:48:00.000-07:00

In The Art of SQL, author and SQL expert Stephane Faroult argues that this "safe approach" only leads to disaster. His insightful book, named after Art of War by Sun Tzu, contends that writing quick inefficient code is sweeping the dirt under the rug. SQL code may run for 5 to 10 years, surviving several major releases of the database management system and on several generations of hardware. The code must be fast and sound from the start, and that requires a firm understanding of SQL and relational theory.

The Art of SQL offers best practices that teach experienced SQL users to focus on strategy rather than specifics. Faroult's approach takes a page from Sun Tzu's classic treatise by viewing database design as a military campaign. You need knowledge, skills, and talent. Talent can't be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others. They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL

Download:rapidshare.com

2008-06-02T13:47:00.000-07:00

SQL--the core technology behind enterprise from Oracle, Informix, Sybase, IBM, Microsoft, and others--the backbone of a $5 billion industry. Comprehensive coverage includes current enhancements and extensions to SQL, the JDBC interface, data warehousing, and more. Robust CD contains the entire book online with hyperlinks, all source code, the sample database from the book, and a self-study quiz.

Download:rapidshare.com

2008-06-02T13:46:00.000-07:00

Would the basics of SQL querying be useful to you, but you dont want to start at the very beginning? Do you wish you had an easy way to ramp up quickly to get a basic understanding of key features and capability? Then you need this book! Without a ton of conceptual information or general programming basics you already know, this book is a quick guide for computing professionals and programmers to learn the basics--and more--in an easily digestible way.

*Provides tutorial-based instruction for the main features of SQL for programmers and other technical professionals in need of a brief but really good introduction to SQL.
*The approach is vendor-neutralso very adaptable and flexiblebut the books Web site includes information about DBMS-specific peculiarities.
*The focus is on teaching concepts by walking through concrete examples and explanations, and self-review exercises are included at the end of each chapter.
*Coverage is on the key features of the language that are required to understand SQL and begin using it effectively.
*SQL 2003-compliant.

Download:rapidshare.com

2008-06-02T13:45:00.002-07:00

No Screenshot

SQLite is a small, fast, embeddable database. What makes it popular is the combination of the database engine and interface into a single library as well as the ability to store all the data in a single file. Its functionality lies between MySQL and PostgreSQL, however it is faster than both databases.

In SQLite, author Chris Newman provides a thorough, practical guide to using, administering and programming this up-and-coming database. If you want to learn about SQLite or about its use in conjunction with PHP this is the book for you.

Download:rapidshare.com

2008-06-02T13:45:00.001-07:00

See how SQL interfaces with today's environments
Start building and using relational databases with SQL's newest features

The database may be the twenty-first century filing cabinet, but building one is a little more complex than sliding drawers into a metal box. With this book to guide you through all the newest features of SQL, you'll soon be whipping up relational databases, using SQL with XML to power data-driven Web sites, and more!

Discover how to
*Use SQL in a client/server system
*Build a multitable relational database
*Construct nested and recursive queries
*Set up database security
*Use SQL within applications
*Map SQL to XML

Download:rapidshare.com

2008-06-02T13:44:00.001-07:00

A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next step for SQL developers and database administrators who want to extend their SQL tuning expertise and get the most from their database applications. There are two basic issues to focus on when tuning SQL: how to find and interpret the execution plan of an SQL statement and how to change SQL to get a specific alternate execution plan. SQL Tuning provides answers to these questions and addresses a third issue that's even more important: how to find the optimal execution plan for the query to use. Author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book include exercises to reinforce the concepts you've learned. SQL Tuning concludes by addressing special concerns and unique solutions to "unsolvable problems." Whether you are a programmer who develops SQL-based applications or a database administrator or other who troubleshoots poorly tuned applications, SQL Tuning will arm you with a reliable and deterministic method for tuning your SQL queries to gain optimal performance

Download:rapidshare.com

2008-06-02T13:43:00.002-07:00

Are you an SQL programmer that, like many, came to SQL after learning and writing procedural or object-oriented code? Or have switched jobs to where a different brand of SQL is being used, or maybe even been told to learn SQL yourself?

If even one answer is yes, then you need this book. A "Manual of Style" for the SQL programmer, this book is a collection of heuristics and rules, tips, and tricks that will help you improve SQL programming style and proficiency, and for formatting and writing portable, readable, maintainable SQL code. Based on many years of experience consulting in SQL shops, and gathering questions and resolving his students SQL style issues, Joe Celko can help you become an even better SQL programmer.

* Help you write Standard SQL without an accent or a dialect that is used in another programming language or a specific flavor of SQL, code that can be maintained and used by other people.
* Enable you to give your group a coding standard for internal use, to enable programmers to use a consistent style.
* Give you the mental tools to approach a new problem with SQL as your tool, rather than another programming languageone that someone else might not know!

Download:rapidshare.com

2008-06-02T13:43:00.001-07:00

SQL was, is and always will be the database language for relational database systems such as Oracle, DB2, Sybase, Informix and Microsoft SQL Server. Introduction to SQL describes in depth the full capacity of SQL as it is implemented by the commercial databases, without neglecting the most recent changes to the standard, bringing the book up to date and fully compliant with SQL3. Unique in the extent of its coverage, this book takes you from the beginning to the end of SQL, the concepts to the practice, the apprentice to the master.

Learn how to: * Query data * Update data * Create tables and views * Specify primary and foreign keys * Use indexes * Secure your data * Develop stored procedures and triggers * Develop applications with embedded SQL and ODBC * Carry out transactions * Optimize statements * Deal with object-relational concepts such as subtables, references, sets and user-defined data types.

NEW section devoted to stored procedures and triggers NEW coverage of object-oriented concepts NEW information on application development with pre-programmed SQL NEW chapter on using SQL in combination with ODBC

Download:rapidshare.com

2008-06-02T13:42:00.000-07:00

No ScreenShot

The Programmer's Guide to SQL provides an in-depth yet concise tutorial on the use of Structured Query Language (SQL), the standard that defines how to create and manipulate databases and the data that they store. Once you've mastered the fundamentals, the book serves as a handy desktop reference on SQL usage, covering all the major SQL statements that you're likely to need when programming databases, with example code for five major database systems: SQL Server, Oracle, DB2, MySQL, and Access. In each case, it demonstrates how the SQL standard is implemented, and in some cases extended, by each database system vendor. It discusses:

- Querying, modifying and summarizing data using SQL
- SQL Functions
- Complex nested queries and joins
- Programming database stores procedures, triggers and views
- Creating tables, indexes and other database objects
- How to write transaction-safe SQL
- How to implement basic database security

The book covers the very latest version of the SQL standard, SQL-99, and includes two complete case studies, showing how to create and query the underlying database for a fully featured web site, and how to implement role-based security in your applications. As such, it is ideal for any programmer, analyst, or database administrator in search of an SQL reference that also demonstrates how to use SQL to solve real business problems.

Download:rapidshare.com

2008-06-02T13:41:00.001-07:00

Find tips for creating efficient PL/SQL code
If you know a bit about SQL, this book will make PL/SQL programming painless!

The Oracle has spoken бк you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book! You'll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more.

Discover how to
*Write efficient, easy-to-maintain code
*Test and debug PL/SQL routines
*Integrate SQL and PL/SQL
*Apply PL/SQL best practices
*Use new features introduced in Oracle 9i and 10g

Download:rapidshare.com PassWord:www.ITeBookHome.com

2008-06-02T13:40:00.000-07:00

This unique cookbook contains a wealth of solutions to problems that SQL programmers face all the time. The recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra. Authors Ales Spetic and Jonathan Gennick, two authorities with extensive database and SQL programming experience, include a discussion with each recipe to explain the logic and concepts underlying the solution. SQL (Structured Query Language) is the closest thing to a standard query language that currently exists, and Transact-SQL -- a full-featured programming language that dramatically extends the power of SQL -- is the procedural language of choice for both Microsoft SQL Server and Sybase SQL Server systems. The Transact-SQL Cookbook is designed so you can use the recipes directly, as a source of ideas, or as a way to learn a little more about SQL and what you can do with it. Topics covered include:

*Audit logging. In addition to recipes for implementing an audit log, this chapter also includes recipes for: improving performance where large log tables are involved; supporting multiple-languages; and simulating server push.
*Hierarchies. Recipes show you how to manipulate hierarchical data using Transact-SQL. Importing data. This chapter introduces concepts like normalization and recipes useful for working with imported data tables.
*Sets. Recipes demonstrate different operations, such as how to find common elements, summarize the data in a set, and find the element in a set that represents an extreme.
*Statistics. This chapter?s recipes show you how to effectively use SQL for common statistical operations from means and standard deviations to weighted moving averages.
*Temporal data. Recipes demonstrate how to construct queries against time-based data.
*Data Structures. This chapter shows how to manipulate data structures like stacks, queues, matrices, and arrays.

With an abundance of recipes to help you get your job done more efficiently, the Transact-SQL Cookbook is sure to become an essential part of your library.

Download:rapidshare.com PassWord:www.ITeBookHome.com

2008-06-02T13:39:00.002-07:00

This comprehensive text explains how to use the latest Oracle Database 10g features, how to perform complex calculations using analytic functions, and how to use large objects to store character and binary data.

Download:rapidshare.com

Download:rapidshare.com

2008-06-02T13:39:00.001-07:00

Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. The book offers 100 hacks -- unique tips and tools -- that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You'll find practical techniques to address complex data manipulation problems. Learn how to:

*Wrangle data in the most efficient way possible
*Aggregate and organize your data for meaningful and accurate reporting
*Make the most of subqueries, joins, and unions
*Stay on top of the performance of your queries and the server that runs them
*Avoid common SQL security pitfalls, including the dreaded SQL injection attack

Let SQL Hacks serve as your toolbox for digging up and manipulating data. If you love to tinker and optimize, SQL is the perfect technology and SQL Hacks is the must-have book for you.

Download:file2upload.com

Download:rapidshare.com

2008-06-02T13:38:00.000-07:00

Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL. * Each of the hundreds of SQL code examples was tested on a working Oracle 10g database * Invaluable everyday tool that provides an absolute plethora of properly tested examples of Oracle SQL code * Authors have four decades of commercial experience between them as developers and database administrators

Download:rapidshare.com

2008-06-02T13:37:00.002-07:00

Many database management system (DBMS) tools run on a variety of hardware platforms. The differences among the tools can be many, but all serious products have one thing in common: They support data access and manipulation in SQL, the industry-standard language specifically designed to enable people to create and manage databases. If you know SQL, you can build relational databases and get useful information out of them. Relational database management systems are vital to many organizations. People often think that creating and maintaining these systems are extremely complex activities иC the domain of database gurus who possess enlightenment beyond that of ordinary mortals.

sweeps away the database mystique. Written in easy-to-understand terms and updated with the latest information on SQL, this handy reference shows you step-by-step how to make your database designs a reality using SQL:2003. But you don't have to be a database newbie to find value

Download:rapidshare.com

Download:depositfiles.com

2008-06-02T13:37:00.001-07:00

Master queries for any SQL database!
Your one-stop guide to building and maintaining relational databases with SQL

If you're looking for a good general reference on SQL, look no further. This all-in-one guide delivers the goods on all major SQL topics, from basic concepts to the latest XML data-handling functions. Whether you're a database developer or DBA, you'll find fast answers to your SQL questions and savvy tips on building databases that are robust, secure, and efficient.

*Tackle a database development project
*Formulate SQL queries
*Build database applications
*Secure your database
*Handle XML data
*Tune and optimize a database

Download:rapidshare.com

Download:depositfiles.com

2008-06-02T13:35:00.000-07:00

In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzlesand then helps solve them with a variety of solutions and explanations. Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but help develop the mindset needed to solve the many difficult SQL puzzles you face every day. Of course, part of the fun is to see whether or not you can write better solutions than Joes.

* A great collection of tricky SQL puzzles with a variety of solutions and explanations.
* Uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems - many of which will help users solve their own problems.

Download:rapidshare.com

Download:depositfiles.com

2008-06-02T13:34:00.000-07:00

SQL Performance Tuning is a handbook of practical solutions for busy database professionals charged with managing an organization's critically important data. Covering today's most popular and widely installed database environments, this book is an indispensable resource for managing and tuning SQL across multiple platforms.

Packed with tips, techniques, and best practices, this hands-on guide covers SQL commands and queries over a wide range of conditions and environments. Every facet of the SQL environment is covered, from concurrency control to optimizationâАб▒and every issue in between. The book includes an overview of each of the most widely used database management systems (DBMS) and provides tuning tips for common day-to-day situations.

Topics covered include:
*General and specific tuning
*General sort considerations and options
*Joins and subqueries
*Columns and tables
*Indexes, including B-trees and bitmaps
*Constraints and stored procedures
*ODBC and JDBC
*Data changes and concurrency control (locking)
*Clients, servers, and middleware

Download:rapidshare.com

Download:depositfiles.com

2008-06-02T13:33:00.000-07:00

Discusses creating, using, and managing user-defined functions and system user-defined functions. Covers the three types of UDFs and how to create and use them, how to debug UDFs, and more

Download:rapidshare.com

Download:depositfiles.com

2008-06-02T13:32:00.002-07:00

Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in applying the SQL language. Forta's examples are clear and his writing style is crisp and concise. As with earlier editions, this revision includes coverage of current versions of all major commercial SQL platforms. New this time around is coverage of MySQL, and PostgreSQL. All examples have been tested against each SQL platform, with incompatibilities or platform distinctives called out and explained.
Download:rapidshare.com
Download:depositfiles.com

2008-06-02T13:32:00.001-07:00

SQL in a Nutshell applies the eminently useful "Nutshell" format to Structured Query Language (SQL), the elegant--but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products. SQL in a Nutshell is a lean, focused, and thoroughly comprehensive reference for those who live in a deadline-driven world. This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format that covers the SQL syntax of no less than 4 different databases. When you need fast, accurate, detailed, and up-to-date SQL information, SQL in a Nutshell, Second Edition will be the quick reference you'll reach for every time. SQL in a Nutshell is small enough to keep by your keyboard, and concise (as well as clearly organized) enough that you can look up the syntax you need quickly without having to wade through a lot of useless fluff. You won't want to work on a project involving SQL without it.

Download:rapidshare.com

Download:depositfiles.com

2008-06-02T13:31:00.000-07:00

As dynamic, database-driven Web sites become the standard, more and more nonprogrammers just like yourself are being forced to work with database information and create and edit database objects. With SQL and this task-based guide to it, you can do it too--no programming experience required!

After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily launches into the tasks that will get you comfortable with SQL fast. In addition to explaining SQL basics, this updated reference covers the ANSI SQL:2003 standard and contains a wealth of brand-new information, including a new chapter on set operations and common tasks, well-placed optimization tips to make your queries run fast, sidebars on advanced topics, and added IBM DB2 coverage.

Best of all, the book's examples were tested on the latest versions of Microsoft Access, Microsoft SQL Server, Oracle, IBM DB2, MySQL, and PostgreSQL. On the companion Web site, you can download the SQL scripts and sample database for all these systems and put your knowledge to work immediately on a real database..

Download:rapidshare.com

Download:depositfiles.com

2008-06-02T13:30:00.000-07:00

Owning this reference, which covers everything from the components of a table to performing batch updates, is a must! Beginning with tips for the person who is programming with SQL for the first time, SQL Tips and Techniques grows with your skills. You can start with Tip 1, "Understanding the Definition of a Database," and by the last tip, "Displaying Image Data Stored Within a SQL Table," you will have covered all aspects of SQL. Or, you can simply keep this book as a comprehensive reference for answering specific SQL questions quickly. However you read it, this invaluable reference will be the only SQL book you need on your shelf!
Download:rapidshare.com
Download:depositfiles.com

2008-06-02T13:29:00.000-07:00

Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioners guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topics that should be of interest to the working database programmer. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more. This book covers SQL-92 and SQL:1999.

*Includes graph theory and programming techniques.
*Running examples throughout the book help illustrate and tie concepts together.

Download:rapidshare.com

Download:depositfiles.com

2008-06-02T13:27:00.002-07:00

Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales' extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features.

Author Don Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule -- cover what's most needed and used by PL/SQL professionals and avoid what's not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.

Discover the 20% of PL/SQL that gives you 80% of the bang--key topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.

Learn how to write production-level, object-oriented PL/SQL--you'll explore relational PL/SQL, but unlike most other books on the subject, Don Bales emphasizes the use of PL/SQL's object-oriented features as well.

Work through real examples of using of PL/SQL--you'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.

What you'll learn
*How important SQL is in PL/SQL
*How to use PL/SQL in both a relational and object-relational setting
*How to create maintainable, modular, and reusable PL/SQL program units
*The importance of testing as you go, and of building a permanent test plan for each module
*The importance of building debugging capabilities into your code and building a permanent debug facility for each module
*The importance of documenting as you go, and in the process building a permanent documentation set for your reusable modules
*How to apply modular PL/SQL to solve real-world problems

Download:rapidshare.com

Download:depositfiles.com

2008-06-02T13:27:00.001-07:00

SQL Queries for Mere Mortals provides a step-by-step, easy-to-read introduction to writing SQL queries. It includes hundreds of examples with detailed explanations. This book provides the tools you need to understand, modify, and create SQL queries

Download:rapidshare.com

2008-06-02T13:26:00.001-07:00

Joe Celko has looked deep into the code of novice SQL programmers and found a consistent and troubling pattern. These programmers have not changed their approach from writing code for a procedural language, like C, to a declarative language--which is what SQL is. As a result they are not fully using the power and capability inherent in SQL and that translates into writing more code than they need to write, more complex code than is needed, and ultimately lower productivity.

Thinking in sets reveals the conceptual shift these programmers need to make. Through detailed examples and clear explanations, Joe enables readers to concepualize database problems as rooted in sets and solvable through declarative programming techniques. The book focuses on three main table-based SQL techniques that not only demonstrate this set characteristic of SQL but also dramatically simplify application development. For each table type--auxillary, temporal and virrual--Joe teaches not only the new kind of thinking required to use them effectively but also how to choose the right table technique to apply and why.

* Joe brings you comprehensive treatment of SQL programming techniques that make use of tables rather than procedural code.
* The focus on real world examples and Joe's creative teaching style enable SQL programmers to conquer a common weak spot, while learning these new tools.
* A unique contribution, many techniques which are novel and unavailable elsewhere.

Download:rapidshare.com

Download:depositfiles.com

2008-06-02T13:24:00.000-07:00

Head First SQL: Your Brain on SQL -- A Learner's Guide

Download:rapidshare.com

2008-06-02T13:21:00.000-07:00

Beginning SQL Queries is your guide to mastering the lingua franca of the database industry: the SQL language. Good knowledge of SQL is crucial to anyone working with databases, because it is with SQL that you retrieve data, manipulate data, and generate business results. Knowing how to write good queries is the foundation for all work done in SQL, and it is a foundation that Clare lays well in her book.

*Does not bore with syntax!
*Helps you learn the underlying concepts involved in querying a database, and from there the syntax is easy
*Provides exceptionally clear examples and explanations
*Is academically sound while being practical and approachable
What youбпll learn
*Write simple queries to extract data from a single table.
*Understand relational algebra and calculus and why they are important.
*Combine data from many tables into one business result.
*Avoid pitfalls and traps such as Cartesian products and difficulties with null values.
*Summarize large amounts of data for reporting purposes.
*Apply set theory to the problems of manipulating data and generating reports.

Download:rapidshare.com

Download:depositfiles.com

Download:rapidshare.com

1590599853 Pro Web 2.0 Application Development with GWT

2008-05-28T12:43:00.000-07:00

Jeff Dwyer, "Pro Web 2.0 Application Development with GWT"
Apress | ISBN: 1590599853 | May 7, 2008 | 480 pages | PDF | 3.8MB

“

The main focus of Pro Web 2.0 Application Development with GWT is a case study of a real Web 2.0 application called ToCollege.net.

Download from Depositfiles

Download from Easy-Share

Download from FileFactory

”

0596521782 Windows PowerShell Pocket Reference

2008-05-28T12:40:00.000-07:00

Lee Holmes, "Windows PowerShell Pocket Reference"
O'Reilly Media, Inc. | ISBN: 0596521782 | May 20, 2008 | 174 pages | CHM | ~1MB

“

This portable reference to Windows PowerShell summarizes both the command shell and scripting language, and provides a concise reference to the major tasks that make PowerShell so successful. It's an ideal on-the-job tool for Windows administrators who don't have time to plow through huge books or search online.
Written by Microsoft PowerShell team member Lee Holmes, and excerpted from his Windows PowerShell Cookbook, Windows PowerShell Pocket Reference offers up-to-date coverage of PowerShell's 1.0 release. You'll find information on .NET classes and legacy management tools that you need to manage your system, along with chapters on how to write scripts, manage errors, format output, and much more.

Download from Easy-Share

Download from FileFactory

Visit my AH Blog

Visit my COMICS BLOG

0470187425 Mastering Microsoft Visual Basic 2008

2008-05-28T12:02:00.000-07:00

Evangelos Petroutsos “Mastering Microsoft Visual Basic 2008"
Sybex | 2008-03-04 | ISBN: 0470187425 | 1118 pages | PDF | 10,6 Mb

Mastering Microsoft Visual Basic 2008 continues the approach of its previous editions by providing thorough, expert coverage of VB 2008, from the core of the language and user interface design to developing data-driven applications and Web applications. The material is aimed at beginners with some programming background to experienced programmers, with emphasis on intermediate and advanced development topics. The book will contain numerous example programs that readers can use as starting points for building their own applications, and each chapter ends with review exercises to help readers solidify their knowledge.

Download ebook + source code:
rapidshare.com/files/118250156/0470187425s.rar
depositfiles.com/files/5656219