SQL

SQL joins - multi-table queries Ian Gilfillan February 28, 2002	To harness the true power of relational databases it is vital to master queries using more than one table. This article will introduce you to database joins - queries using 2 or more tables.
Build Your Own Database Driven Website Using PHP & MySQL: Part 4 SitePoint January 24, 2002	This final installment covers publishing MySQL data on the Web, connecting to MySQL with PHP, sending SQL queries with PHP, inserting data into the database, and even has a "homework" assignment. This book covers everything from installing PHP & MySQL under Windows or Linux, through to building a live Web- based content management system.
Build Your Own Database Driven Website Using PHP & MySQL: Part 3 SitePoint January 17, 2002	This third installment introduces PHP, variables and operators, user interaction and forms, control structures, and multi-purpose pages. This book covers everything from installing PHP & MySQL under Windows or Linux, through to building a live Web-based content management system.
Build Your Own Database Driven Website Using PHP & MySQL: Part 2 SitePoint January 10, 2002	This second installment covers an introduction to databases, logging on to MySQL, defininfg SQL, inserting data in a table, and modifying stored data. This book covers everything from installing PHP & MySQL under Windows or Linux, through to building a live Web-based content management system.
Build Your Own Database Driven Website Using PHP & MySQL: Part 1 SitePoint January 3, 2002	Together, PHP & MySQL form the most widely used open source database and scripting technologies on the Web today. This book covers everything from installing PHP & MySQL under Windows or Linux, through to building a live Web-based content management system.
Optimizing MySQL, Hardware and the Mysqld Variables Ian Gilfillan December 17, 2001	You've fine-tuned your indexes, and have optimized those queries to the bone. But still your MySQL database is crawling. It's time to look at tweaking the mysqld variables, what hardware improvements you can make, and how you can compile MySQL to run just that little bit faster.
Optimizing MySQL Queries and Indexes Ian Gilfillan November 26, 2001	Building a database-driven site is one thing. But all too often your masterpiece starts performing like a donkey when it becomes popular. Learn how to optimize your queries and indexes in MySQL, and potentially speed up your application many times over.
Beginning SQL Programming: Part 4 Wrox Press August 9, 2001	This fourth installment covers data warehouse with multiple SQL requesters, the human roles in DBMS, when to use SQL, scaling, speed, price, universality, and analytic capabilities, among other areas. This book provides the reader with a firm grasp of SQL concepts.
Beginning SQL Programming: Part 3 Wrox Press August 2, 2001	This third installment covers configurations for using SQL, two and three tier architecture on a LAN, n-tier architecture on the Web, mainframe and terminals, and mainframe to mainframe. This book provides the reader with a firm grasp of SQL concepts.
Beginning SQL Programming: Part 2 Wrox Press July 26, 2001	This second installment covers procedural versus declarative languages, SQL's place in the data center and obtaining SQL. This book will furnish readers with a firm grasp of SQL concepts that you can work with straight away, as well as provide solid foundations and challenging ideas with which you can later develop more advanced SQL techniques.
Beginning SQL Programming Wrox Press June 28, 2001	This book will furnish readers with a firm grasp of SQL concepts that you can work with straight away, as well as provide solid foundations and challenging ideas with which you can later develop more advanced SQL techniques. This first excerpt covers the history of SQL, standards, terminology and the current state of SQL.
Simple SQL : Getting Started With SQL Web Developers Journal August 18, 2000	Your boss has given you a mission. It sounds simple enough - you just need to create a few custom reports on your intranet that connect to your company-wide database. Well, what if suddenly you discover the database is a legacy monstrosity filled with arcane language and structures? What if, heavens forbid, nobody can understand it? How will you keep your job?
Simple SQL, Part II : Getting Started With SQL Web Developers Journal September 1, 2000	Now that you've learned exactly what SQL is (in my previous column), and how to use the standard SELECT functions, it's time to move ahead to other features. In this section, I'll be covering special grouping, logical and mathematical functions. These functions build upon what you've hopefully already learned, and allow you to leverage that to use SQL in your work.
Simple SQL, Part III: SQL in Action Web Developers Journal September 15, 2000	In the previous two parts of this series, we looked at the underlying concepts of SQL and many of the basic SQL query components. In this, the third and final installment of the series, we'll look at why you'd want to use SQL, and an example of it in action, via the Microsoft Visual InterDev 6.0 programming environment.