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 ...
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 ...
A Free Windows Graphical Interface to MySQL
In my previous article "Gettting Started With MySQL Database" we installed MySQL on Windows and worked with it using MySQL monitor in a DOS window. In this article, rather than work with a DOS window, we will use a free Windows Graphical Interface to MySQL. More ...
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 ...
How to Connect to an Unresponsive SQL Server: Direct Admin Connection
When SQL Server stops responding but is still, the first impulse is to reboot SQL Server. This may stop the symptom, but will not tell you anything to help you prevent the cause. More ...
Build Relational Databases in Seven Steps
Many web applications revolve around a relational database. So to create a good application design, you should always create a good database design. Database design is a step-by-step process. More ...
Learn SQL and Create a Database With Only Your Web Browser
WebSQL is an API built-in to Google's Chrome web browser that allows you to use JavaScript to create and manage SQL databases. It's mind-boggling to me that you can create and manage an SQL database with nothing more than your web browser. 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 ...
Working With Strings in PHP
Computer programs usually work with some form of data. One of the most common forms of data used in PHP is a text character or an array of text characters. An array of text characters is called a string. More ...
Introduction to Variables in PHP
Computer programs usually work with some form of data. This article is an introduction to variables in PHP. More ...
