Database Related Tutorials - LearnPHP.org

Sort byTutorials Per Page
Pages:1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Next| Last
Which database do I use: Postgres or MySQL? This age-old question has plagued developers for, what, at least a couple years now.
March 19, 2010 Today Views: 1 Total Views: 554

MySQL - Introduction

Author: tizag.com  Rating:
MySQL is currently the most popular open source database server in existence. On top of that, it is very commonly used in conjunction with PHP scripts to create powerful and dynamic server-side applications.
March 18, 2010 Today Views: 11 Total Views: 549

Aggregate Functions

Author: ONLamp.com  Rating:
John Paul Ashenfelter looks at a specific class of SQL functions that operate on entire columns of data instead of discrete values -- the aggregate functions.
March 18, 2010 Today Views: 1 Total Views: 399
For small and large database projects, Microsoft Access works wonderfully. If you have a database with hundreds of thousands of records, maybe even connecting to other databases remotely, Access will work just fine.
March 15, 2010 Today Views: 2 Total Views: 821
A beginner tutorial demonstrating a simple form to update administrator privileges for a set of users using checkboxes.
March 12, 2010 Today Views: 3 Total Views: 250

Good Relations

Author: ONLamp.com  Rating:
John Paul Ashenfelter looks at how keys are used to construct relationships between tables in a relational database.
March 9, 2010 Today Views: 4 Total Views: 609
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: 691
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: 537
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: 265

SQL - Datepart()

Author: tizag.com  Rating:
Microsoft's SQL Server takes a little different approach to working with dates.
March 3, 2010 Today Views: 4 Total Views: 2,120
Pages:1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Next| Last