Menu
SQL (Structured Query Language)

Introduction to SQL Database Design
A Database is the storage of data in what are called tables. Without knowing what kind of data you are planning on storing, you will not know how to create the tables. More ...

The Entity-Relationship Model
After you have a data model that meets the organizations business requirements, the easiest way to transform that model into a relational database is to first transform that model into an entity-relationship model. More ...

Run PHP From Flash Key With Server2go
Do you want to learn (or teach) PHP and / or MySQL, but don't want to install a web server + PHP + database on your PC? Server2go is a neat little application that you can put on a USB flash drive and run your PHP MySQL webpages from there. More ...

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide
This book teaches how to develop dynamic Web sites with PHP and MySQL. The information is presented in a step-by-step approach. The focus is on real-world, practical examples. More ...

Use Perfmon and SQL Profiler Together to Troubleshoot SQL Server Performance Issues
A great technique for troubleshooting SQL Server performance issues is to use Perfmon and SQL Profiler together. Each tool give you insight into what is happening with your database server, but combined they can narrow down your performance issue to specific events or statements. More ...

Creating Webpages with PHP
This article is an introduction to the PHP server-side scripting language where you learn how to create webpages with PHP. More ...

Introduction to SQL (Structured Query Language)
IBM developed its relational database management system by creating a language initially named SEQUEL (Structured English Query Language). However IBM's legal department found a possible copyright issue with the name SEQUEL. So they decided to drop the vowels and call the language SQL. More ...

Language Integrated Queries (LINQ) and Visual Basic
LINQ is a better version of SQL - it is a part of ADO.NET and is integrated with VB.NET. LINQ now has the long missing option of using Visual Basic functionality in the data selection process. More ...