SQL (Structured Query Language)
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 ...
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 ...
Working With Numbers in PHP
One of the most important things to consider in using arithmetic operators is operator
precedence, that is, the order in which the operations are performed. 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 ...
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 ...
SQL 2012 Data Tools
Data Tools (SSDT) is a tool set designed for use by Microsoft with SQL Server and SQL Azure
to facilitate database design. Features include business intelligence (BI) tools, rapid data
discovery, and data warehousing, among others. More ...