Showing posts with label Databases. Show all posts
Showing posts with label Databases. Show all posts

Aug 17, 2008

SQL Clearly Explained

SQL Clearly Explained
SQL Clearly Explained, Second Edition (The Morgan Kaufmann Series in Data Management Systems)

This is the second edition of the popular practitioner's guide to SQL, the industry-standard database query language. Like most computer languages, SQL can be overwhelming when you first see it, but for years readers have relied on this book to clear the confusion and explain how SQL works and how to use it effectively. Packed with tips, tricks, and good information, SQL Clearly Explained, Second Edition teaches database users and programmers everything they need to know to get their job done including
· formulating SQL queries,
· understanding how queries are processed by the DBMS,
· maximizing performance,
· using SQL to enter, modify, or delete data,
· creating and maintaining database structural elements, and
· embedding SQL in applications.

Features
· Updated and expanded to include changes in the SQL standard (SQL:1999) as well as recently implemented aspects of SQL-92.
· Includes CD with examples from the book as well as MySQL, a popular open-source DBMS, on which the examples are based.
· Web enhanced with extra features available online at www.mkp.com.

* Second edition of classic SQL handbook
* Updated to cover changes in the SQL language standard (SQL:1999)
* Includes CD with MySQL software

DOWNLOAD :
http://rapidshare.com/files/137033355/SQeLL.pdf

Aug 14, 2008

Oracle Applications DBA Field Guide

Oracle Applications DBA Field Guide provides scripts, notes, guidelines, and references to guide you safely through the crucial day-to-day administration tasks that fall within your jurisdiction. This includes configuring, monitoring, performance tuning, troubleshooting, and patching. This book contains tips, techniques, and guidance for administering the highly complex Oracle E-Business Suite running Oracle9i or Oracle10g on UNIX or Linux serversall in an easy reading and quick-to-navigate format.

Even for the experienced database administrator, Oracle Applications are complicated to administer, and most other documentation out there is difficult to find and understand. Whether you're an experienced Oracle Applications DBA or a relative newcomer to Oracle 11i Applications (perhaps migrating from PeopleSoft, JD Edwards, or Siebel), this book will enable you to make a real impact on the ease and efficiency of your day-to-day administrative tasks, and will be relevant for Oracle Applications Release 12 and Fusion.


About the Author
Paul Jackson has over 10 years' experience as a developer and Oracle DBA. Paul is the Program Director for the ATS SIG. He is a very active member of the Oracle community through memberships of Ohio Valley Oracle Applications User Group (OVOAUG), International Oracle User Group (IOUG), and the Oracle RAC SIG.

Elke Phelps is an Oracle Certified Professional with over 12 years' experience administering Oracle products. She is the Founder and presiding President of the Oracle Applications User Group's Middleware SIG&emdash;formerly the ATS SIG&emdash;and is responsible for conducting meetings at the annual OAUG and Oracle Open World conferences. This yields a unique medium for access to the Oracle Applications users and provides name recognition in the user community. Elke is the author of several whitepapers and is a technical presenter at many international conferences.

TITLE : Oracle Applications DBA Field Guide (Paperback)
AUTHOR : Elke Phelps and Paul Jackson
PUBLISHER : Apress
ISBN : 1590596447
EDITION : 1st
PUB DATE : March 31, 2006
LANGUAGE : English
RLS DATE : 08/30/2006

MAKER : BBL
SUPPLIER : BBL
PACKAGER : BBL
FORMAT : PDF
SIZE : 2.88 MB

DOWNLOAD:
http://rapidshare.de/files/31390772/b-044b01.rar
http://www.mytempdir.com/899088

May 6, 2008

Beginning PHP and PostgreSQL E-Commerce

Beginning PHP and PostgreSQL E-Commerce-From Novice to Professional books is divided into three parts consisting of 17 chapters and 2 appendixes. We cover a wide variety of topics, showing you how to Build an online product catalog that can be browsed and searched Implement the catalog administration pages that allow adding, modifying, and remov-ing products, categories, and departments Create your own shopping basket and checkout in PHP Increase sales by implementing product recommendations and product reviews Handle payments using PayPal, DataCash, and Authorize.net Implement a customer accounts system Integrate external functionality through Web Services The following brief roadmap highlights how weíll take you from novice to professional regarding each of the topics in the previous list.


Part 1: Phase I of Development

Chapter 1: Starting an E-Commerce Site
In this chapter, weíll introduce some of the principles of e-commerce in the real world. You see the importance of focusing on short-term revenue and keeping risks down. We look at the three basic ways in which an e-commerce site can make money. We then apply those princi- ples to a three-phase plan that provides a deliverable, usable site at each phase of this book.

Chapter 2: Laying Out the Foundations
The first chapter offered an overview of e-commerce in the real world. Now that youíve decided to develop a web site, we start to look in more detail at laying down the foundations for its future. Weíll talk about what technologies and tools youíll use, and even more impor-tantly, how youíll use them.

Chapter 3: Creating the Product Catalog: Part I
After learning about the three-tier architecture and implementing a bit of your web siteís main page, itís time to continue your work by starting to create the HatShop product catalog.
Because the product catalog is composed of many components, youíll create it over two chapters. In Chapter 3, youíll create the first database table and implement the data access code. By the end of this chapter, youíll have something dynamically generated on your web page.

Chapter 4: Creating the Product Catalog:Part II
The fun isnít over yet! In the previous chapter, you created a selectable list of departments for HatShop. However, a product catalog is much more than a list of departments. In Chapter 4, youíll add the rest of the product catalog features.

Chapter 5: Searching the Catalog
In the preceding two chapters, you will have implemented a functional product catalog for HatShop. However, the site still lacks the all-important search feature. The goal in this chapter is to allow the visitor to search the site for products by entering one or more keywords. Youíll learn how to implement search results rankings and how to browse through the search results page by page. Youíll see how easy it is to add new functionality to a working site by integrating the new components into the existing architecture.

Chapter 6: Receiving Payments Using PayPal
Letís make some money! Your e-commerce web site needs a way to receive payments from customers. The preferred solution for established companies is to open a merchant account, but many small businesses choose to start with a solution thatís simpler to implement, where they donít have to process credit card or payment information themselves.
A number of companies and web sites exist to help individuals or small businesses that donít have the resources to process credit card and wire transactions. These companies can be used to process the payment between companies and their customers. In this chapter, weíll demonstrate some of the functionality provided by one such company, PayPal, as we use it on the HatShop web site in the first two stages of development.

Chapter 7: Catalog Administration
The final detail to take care of before launching a web site is to create its administrative interface. Although this is a part visitors will never see, itís still key to delivering a quality web site to your client.

Part 2: Phase II of Development

Chapter 8:The Shopping Cart
With this chapter, you enter the second phase of development, where you start improving and adding new features to the already existing, fully functional e-commerce site. In Chapter 8, youíll implement the custom shopping cart, which stores its data in the local database. This provides you with more flexibility than the PayPal shopping basket, over which you have no control and which you canít save into your database for further processing and analysis.

Chapter 9:Dealing with Customer Orders
The good news is that the brand new shopping cart implemented in Chapter 8 looks good and is fully functional. The bad news is that it doesnít allow the visitor to actually place an order, making it totally useless in the context of a production system. As you have probably already guessed, youíll deal with that problem in this chapter, in two separate stages. In the first part of the chapter, youíll implement the client-side part of the order-placing mechanism. In the second part of the chapter, youíll implement a simple orders administration page where the site administrator can view and handle pending orders.

Chapter 10:Product Recommendations
One of the best advantages of an Internet store compared to a brick-and-mortar store is the capability to customize the web site for each visitor based on his or her preferences, or based on data gathered from other visitors with similar preferences. If your web site knows how to suggest additional products to your visitor in a clever way, he or she might end up buying more than initially planned. In Chapter 10, youíll learn how to implement a dynamic product recommendation system.

Part 3:Phase III of Development

Chapter 11: Managing Customer Details
In the first two stages of development, youíve built a basic (but functional) site and have hooked it into PayPal for taking payments and confirming orders. In the third section of the book, youíll take things a little further. By cutting out PayPal from the ordering process, you can gain better control as well as reduce overhead. This isnít as complicated as you might think, but you must be careful to do things right. Chapter 11 lays the groundwork by implementing a customer account system, as well as looking into the security aspects of exchanging and storing customer and credit card details.

Chapter 12: Storing Customer Orders
In this chapter, youíll make the modifications required for customers to place orders that are associated with their user profiles. The main modification here is that the customer associated with an order will be identified by a new piece of information in the orderstable, and much of the rest of the modifications will be made to use this information.
Also in this chapter, youíll take a look at dealing with another common feature of e-commerce sites: tax and shipping charges. Many options are available for implementing this functionality, but weíll just examine a simple way of doing things and lay the groundwork for your own further development.

Chapter 13: Implementing the Order Pipeline:Part I
The HatShop e-commerce application is shaping up nicely. Youíve added customer account functionality, and youíre keeping track of customer addresses and credit card information, which is stored in a secure way. However, youíre not currently using this informationóyouíre delegating responsibility for this to PayPal. In this and the next chapter, youíll build your own order-processing pipeline that deals with authorizing credit cards, stock checking, shipping, providing email notifications, and so on. Weíll leave the credit card processing specifics until Chapter 15, but weíll show you where this process fits in before then.

Chapter 14: Implementing the Order Pipeline:Part II
In this chapter, youíll add the required pipeline sections so that you can process orders from start to finish, although you wonít be adding full credit card transaction functionality until the next chapter. Weíll also look at the web administration of orders by modifying the order admin pages added earlier in the book to take into account the new order-processing system.

Chapter 15: Credit Card Transactions
The last thing you need to do before launching the e-commerce site is enable credit card processing. In this chapter, weíll look at how you can build this into the pipeline you created in Chapters 13 and 14. Youíll see how to use two popular credit card gateways to do this: Data Cash and Authorize.net. By the end of this chapter, HatShop will be a fully functioning, secure, and usable e-commerce application.

Chapter 16: Product Reviews
At this point, you have a complete and functional e-commerce web site. However, this doesnít stop you from adding even more features to it, making it more useful and pleasant for visitors. By adding a product reviews system to your web site, you increase the chances that visitors will get back to your site, either to write a review for a product they bought or to see what other people think about that product.

Chapter 17: Connecting to Web Services
In the dynamic world of the Internet, sometimes it isnít enough to just have an important web presence; you also need to interact with functionality provided by third parties to achieve your goals. So far in this book, you already saw how to integrate external functionality to process payments from your customers. In Chapter 17, youíll learn how to use Amazon.com functionality from and through Web Services. A Web Service is exposed through a web interface using standard Internet protocols such as HTTP. The messages exchanged by the client and the server are encoded using an XML-based protocol named SOAP (Simple Object Access Protocol), or by using REST (Representational State Transfer). These messages are sent over HTTP.
Youíll learn more about these technologies in this chapter.


DOWNLOAD THIS BOOKS

May 3, 2008

PHP & MySQL For Dummies 3rd edition

This books (PHP & MySQL Tutorial) is divided into six parts, with several chapters in each part. The content ranges from an introduction to PHP and MySQL to installing to creating and using databases to writing PHP programs.


Part I: Developing a Web Database
Application Using PHP and MySQL
Part I provides an overview of using PHP and MySQL to create a Web database application. It describes and gives the advantages of PHP, of MySQL, andof their use together. You find out how to get started, including what you need, how to get access to PHP and MySQL, and how to test your software. You then find out about the process of developing the application.

Part II: MySQL Database
In Part II you find out the details of working with MySQL databases. You create a database, change a database, and move data into and out of a database.

Part III: PHP
Part III provides the details of writing PHP programs that enable your Web pages to insert new information, update existing information, or remove information from a MySQL database. You find out how to use the PHP features that are used for database interaction and forms processing.

Part IV: Applications
Part IV describes the Web database application as a whole. You find out how to organize the PHP programs into a functioning application that interacts with the database. Two complete sample applications are provided, described, and explained.

Part V: The Part of Tens
Part V provides some useful lists of important things to do and not to do when developing a Web database application.

Part VI: Appendixes
The final part, Part VI, provides instructions for installing PHP and MySQL for those who need to install the software themselves. Appendix C discusses the installation of the Apache Web server for those who need to install and administer the Web server themselves.

DOWNLOAD THIS EBOOKS

Apr 18, 2008

Microsoft Access Tutorial: Advanced

Part 1 Tutorial : Create Database

1. Start MS Access
From the Start menu click on
> Programs
> Microsoft Office
> Microsoft Access 2003
2. Note the Getting Started task pane on the right side of your screen.
3. Click on Create a new file.
4. The New File task pane will appear. Under New, click on Blank Database.
5. Name the database contact_management and choose Desktop as the location. Click the Create button.

A. Create Table in Design View
1. The contact_management : Database window opens. Double click the Create table in design view item. The Table1 : Table opens.
2. Begin entering field names starting with Call_ID.
Click in the Data Type box and from the pull down menu select AutoNumber.
3. Click the Primary Key button on the Table Design toolbar. Each table MUST have a Primary Key.
4. A Foreign Key field must be included to establish a relationship. A foreign key field is a primary key taken from a foreign table (for example, the customer_ID field from the Customers table would establish the relationship between the Customers table and the Calls table). Give it a Number Data Type.
5. Continue adding field names from your preliminary field list until all are added.
6. Click the Save button. The Save As window opens. Name the table Calls. Click the OK button.
You have created the table structure for the Calls table from scratch. Let’s take a look.
7. From the Table Design toolbar, select the Datasheet View icon.
The table datasheet window opens. Check your list of fields for accuracy.
8. Close the table by clicking the X in the upper right corner.
9. You now see the contact_management : Database window. Now you will create tables by
importing data from a Microsoft Excel spreadsheet

read more and download

Microsoft Access Tutorial: The Basics


Part 1 Tutorial:

1. Start MS Access
From the Start menu click on
> Programs
> Microsoft Office
> Microsoft Office Access 2003

2. Note the Getting Started task pane on the right side of your screen.
3. Click on Create a new file.
4. The New File task pane will appear.
Under Templates, click On my computer, to open the Templates window. Also notice the online templates.

5. Click on the Databases tab.
Notice that there are templates for all types of databases.
Double click on the Contact Management icon. The File New
Database window will appear. Select Desktop, use the default name and then click the Create button. The .mdb extension will automatically be added.

6. In a moment, the Database Wizard window will guide you through the process.
• In the first window, click Next.
• In the second window, you can
select optional fields to be included in your Contact Information table.
• Scroll to the bottom of the right hand column to view the optional fields. Notice the other two tables in the left hand column. They include different fields.
• Click Next and choose Standard style for your screen displays. You can preview other styles by clicking on each name.

read more download this tutorial