Understanding SQL’s underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. On the other hand, if you’re not well versed in the theory, you can fall into several traps. In SQL and Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL. With numerous examples and clear explanations of the reasoning behind them, you’ll learn how to deal with common SQL dilemmas, such as:
Should database access granted be through views instead of base tables?
Nulls in your database are causing you to get wrong answers. Why? What can you do about it? (more…)

PL/SQL, Oracle’s programming language for stored procedures, delivers a world of possibilities for your database programs. PL/SQL supplements the standard relational database language, SQL, with a wide range of procedural features, including loops, IF-THEN statements, advanced data structures, and rich transactional control–all closely integrated with the Oracle database server. Learning Oracle PL/SQL offers the guidance you need to come up to speed on PL/SQL, whether you’re a beginner or already experienced with another programming language.Topics include:
Meticulously crafted with all-new, downloadable examples the book includes language features available in all versions from Oracle7 through Oracle9i. Written (more…)

Learn PL/SQL hands-on, through practical exercises, self-review questions and real-world answers. This book teaches all the Oracle PL/SQL skills you need, through hands-on, real-world labs, exercises, projects, and our great Web-based training site! Coverage includes every key Oracle PL/SQL concept, including: the basics of structured programming; PL/SQL structure and syntax; iterative control; scoping and anchored datatypes; SQL within PL/SQL; for update cursors and subprograms; stored code, triggers, security, tables, even advanced-level package and parameter passing techniques. A free Web-based training module includes a Virtual Study Lounge where readers can interact with the author. As Oracle’s premier tool for building store procedures, PL/SQL (more…)

If you’re using PHP 4, then chances are good that an upgrade to PHP 5 is in your future. The more you’ve heard about the exciting new features in PHP 5, the sooner that upgrade is probably going to be. Although an in-depth, soup-to-nuts reference guide to the language is good to have on hand, it’s not the book an experienced PHP programmer needs to get started with the latest release. What you need is a lean and focused guide that answers your most pressing questions: what’s new with the technology, what’s different, and how do I make the best use of it? In other words, you need a copy of Upgrading to PHP 5. This book is targeted toward PHP developers who are (more…)

Over the past three years PHP has evolved from being a niche language used to add dynamic functionality to small sites to a powerful tool making strong inroads into large-scale, business-critical Web systems.

The rapid maturation of PHP has created a skeptical population of users from more traditional “enterprise” languages who question the readiness and ability of PHP to scale, as well as a large population of PHP developers without formal computer science backgrounds who have learned through the hands-on experimentation while developing small and midsize applications in PHP. (more…)

ilverlight is Microsoft’s new web-based User Interface (UI) technology, based on Windows Presentation Foundation (WPF), which is introducing many revolutionary concepts in the world of UI development. Silverlight uses XAML, with tools like Expression Design and Expression Blend, to create astonishing UI effects (such as gradients, compositions, and animations.) In addition to the richness of the UI elements, Silverlight 2 allows the use of C# or VB in addition to JavaScript to automate web pages. With Silverlight, you have the power of .NET on multiple platforms (IE and Firefox on Windows, Firefox and Safari on Macintosh, and Firefox on Linux). The author brings you up to speed very quickly with numerous hands-on examples. (more…)

Microsoft .NET Architect Evangelist, Jit Ghosh, presents a practical companion guide to developing rich, interactive web applications with Silverlight 2. Common problems, issues, and every–day scenarios are tackled with a detailed discussion of the solution and ready–made code recipes that will save you hours of coding time. The recipes included in Silverlight 2 Recipes: A Problem-Solution Approach have been carefully selected and tested with the professional developer in mind. You’ll find clearly and succinctly stated problems, well–architected solutions, and ample discussion of the code and context so you can see immediately how the solution will support your project. Enjoy practical coverage of Silverlight development in many projects (more…)

Silverlight is a lightweight browser plug–in that frees your code from the traditional confines of the browser. It’s a rules–changing, groundbreaking technology that allows you to run rich client applications right inside the browser. Even more impressively, it’s able to host true .NET applications in non–Microsoft browsers (like Firefox) and on non–Microsoft platforms (like Mac OS X). Silverlight is still new and evolving fast, and you need a reliable guidebook to make sense of it. With four–color graphics and screenshots throughout, Pro Silverlight 2 in C# 2008 is the perfect reference: you’ll learn about the features that put Silverlight in direct competition with Adobe Flash, such as rich support for 2D drawing, animations, and media playback, and best of all, you’ll (more…)

Silverlight is a lightweight browser plug–in that frees your code from the traditional confines of the browser. It is a rules–changing, groundbreaking technology that allows you to run rich client applications right inside the browser. Even more impressively, it is able to host true .NET applications in non–Microsoft browsers (like Firefox) and on non–Microsoft platforms (like Mac OS X). Silverlight is still new and evolving fast, and you need a reliable guidebook to make sense of it.

Download Here

ashups are big; everybody and their dog are creating new and interesting ways of combining information on the Web. But if all the talk of APIs and complex code leaves you cold, you’ll be pleased to meet Microsoft Popfly. Popfly was created as a tool for designers to build mashups in a visual manner, rapidly, without needing to know any code. By simply dragging out “blocks” that represent services such as Flickr onto your workspace and then drawing connection lines between them, you can create a mashup. It’s as easy as that! Get Popfly and Silverlight up and running on your computer, and then learn how to use the Popfly Mashup Creator and Popfly Web Page Creator to share your mashups with the world. Author Eric Griffin will introduce you to Popfly and show you everything you need to start creating your own hybrid web (more…)