Database Related Tutorials - LearnPHP.org
Database Related Tutorials perform a function of an educational resource, that will help you to learn more about your possibilities connected with database, all manipulations with it and all those changes that will meet your demands and requires and can be easily done in a short period of time and in a proper way. Tutorials will explain you in the easiest way all principles of the working process you are going to start, simplifying your laborious task and thus making the best of your time, giving you a chance to pay more attention to other important details.Database Related Tutorials will become your irreplaceable assistant in improving and increasing your knowledge with practical usage in future.
John Paul Ashenfelter looks at how keys are used to construct relationships between tables in a relational database.
March 9,
2010
Today Views:
1 Total Views:
992
You have a web site with pages accessing a database. You want to use PHPLIB, but do not want to change your existing database to suit. Here is the answer to your dreams. PHPLIB and multiple databases.
March 9,
2010
Today Views:
1 Total Views:
1,322
Suppose you need to calculate constantly-changing information based on constantly-updated information in one or more tables. Are you stuck doing everything in multiple expensive queries? By no means.
March 5,
2010
Today Views:
1 Total Views:
1,111
Developing web applications using a static data store where data must be updated, stored and manipulated frequently can be a cumbersome task. However this article will introduce you to the world of relational databases allowing you to maximise your data's potential.
March 4,
2010
Today Views:
1 Total Views:
664
Microsoft's SQL Server takes a little different approach to working with dates.
March 3,
2010
Today Views:
2 Total Views:
3,184
Maintenance is a very common task that is necessary for keeping MySQL tables current. From time to time, you may even need to delete items from your database.
February 26,
2010
Today Views:
1 Total Views:
1,906
Luminaries from the open source communities of Perl, Python, PHP, MySQL, Apache, and Linux each presented their take on the current state of their technology and where it is headed.
February 26,
2010
Today Views:
1 Total Views:
1,067
This tutorial explains the basics of setting up OpenBSD as a database server using MySQL/PostgreSQL and PHP.
February 25,
2010
Today Views:
2 Total Views:
1,049
Application upgrades aren't always easier. Throw in a database backend and a schema change, and you're in for a world of hurt -- unless you've planned well. Russell Dyer explores techniques for taking the pain out of upgrading database-backed applications.
February 23,
2010
Today Views:
1 Total Views:
1,057
The most common types of aggregate functions let you find out things like the minimum, maximum and even the average of a "grouped" set of data. The trick to understanding aggregate functions is often understanding what kind of data is being grouped and analyzed.
February 19,
2010
Today Views:
1 Total Views:
1,666
