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 ...

Entity-Relationship Diagrams
An entity-relationship (ER) model represents the structure of a database, where data equates to entities (or objects) that are linked by relationships expressing dependencies and requirements. More ...

Database Administration
This is the definitive, technology-independent guide to the modern discipline of database administration. Packed with best practices and proven solutions for any database platform or environment, this text fully reflects the field?s latest realities and challenges. 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 ...

Conversion of Access Database Systems to Visual Basic Dot NET and SQL Server
Microsoft will continue supporting VBA for many years to come, but the programming emphasis is rapidly changing in favour of Visual Basic.Net and SQL Server. 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 ...

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 ...

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 ...