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 ...
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 ...
Gettting Started With MySQL Database
MySQL is a powerful relational database management system. The fact that MySQL is used by many major organizations such as Yahoo, NASA and the U.S. Census Bureau proves that it can outperform the big name database management systems. 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 ...
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 ...
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 ...
Database Management Basics - What You Need to Know
When they start throwing terms around like schema, SQL, transaction processing or relational design, wouldn't you like to understand what they're talking about? More ...
Program a Visual Basic MySQL Database
In my previous article we used MySQLGUI for executing SQL queries on our example database. In this article I show you how to program a simple MySQL database browser using Visual Basic. I assume that you already know how to program a simple Visual Basic .EXE project. More ...
Microsoft SQL Azure - Microsoft Takes SQL Databases to the Clouds
SQL Azure provides data storage in the cloud, much like Amazon S3 and many Google Apps. One of the big advantages for SQL Azure is that relational queries can be made against data stored in the cloud, regardless of whether they are structured. More ...
What is an Entity Relationship Diagram?
Entity Relationship diagram is simply a graphical concept which shows the flow of information input and output. Entity relationship diagram has three main components, entity, attribute, and relationship. More ...
