|
|
Databases
|
Simply put, a database is a computerized record keeping system. More
completely, it is a system involving data, the hardware that physically
stores that data, the software that utilizes the hardware's file system
in order to 1) store the data and 2) provide a standardized method for
retrieving or changing the data, and finally, the users who turn
the data into
information.
|
-
Using a MySQL database with PHP
Ian Gilfillan
- It's time to add some dynamic content to your website. The best choice for ease-of-use, price and support is the combination of PHP and MySQL. This article introduces the beginner to using MySQL with PHP.
-
Introduction to relational databases
Ian Gilfillan
- Large databases can easily get out of hand when badly designed, leading to poor performance, and resulting in the whole database needing to be rebuilt later. This article is a brief introduction to the topic of relational databases.
- SQL joins - multi-table queries
Ian Gilfillan
- 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 1
SitePoint
- 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.
- Build Your Own Database Driven Website Using PHP & MySQL: Part 2
SitePoint
- This second installment covers an introduction to databases, logging on to MySQL, defininfg SQL, inserting data into a table, and modifying stored data.
- Build Your Own Database Driven Website Using PHP & MySQL: Part 3
SitePoint
- This third installment introduces PHP, variables and operators, user interaction and forms, control structures, and multi-purpose pages.
- Build Your Own Database Driven Website Using PHP & MySQL: Part 4
SitePoint
- 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.
- Optimizing MySQL, Hardware and the Mysqld Variables
Ian Gilfillan
- 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
- 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.
- Expert One-on-One: Oracle: Part 1
Wrox Press
- This manuscript is Chapter 1 "Developing Successful Oracle Applications" from the Wrox Press book Expert One on One: Oracle. This first part covers developing successful Oracle applications and the Black Box approach.
- Expert One-on-One: Oracle: Part 2
Wrox Press
- This manuscript is Chapter 1 "Developing Successful Oracle Applications" from the Wrox Press book Expert One on One: Oracle. The second installment covers understanding Oracle architecture, using bind variables, understanding concurrency control, and multi-versioning.
- Expert One-on-One: Oracle: Part 3
Wrox Press
- This third installment looks at database independence, the impact of standards, features and functions, and solving problems simply. This manuscript is Chapter 1 "Developing Successful Oracle Applications" from the Wrox Press book Expert One on One: Oracle.
- Expert One-on-One: Oracle: Part 4
Wrox Press
- This fourth and final installment looks at making the database run faster and the DBA-developer relationship. This manuscript is Chapter 1 "Developing Successful Oracle Applications" from the Wrox Press book Expert One on One: Oracle.
- Beginning SQL Programming
Wrox Press
- 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.
- Beginning SQL Programming: Part 2
Wrox Press
- 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: Part 3
Wrox Press
- 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 4
Wrox Press
- 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.
-
Introduction to Databases for the Web
Selena Sol
-
Database Basics
- Introduction to Databases for the Web is a four-part
course designed by Selena Sol.
-
Retrieving and Manipulating Data
- Continuing Selena Sol's free four part course
for webmasters and web
developers with little or no database experience. This second part
introduces retrieving
and manipulating data. The third and fourth parts will address CGI and
Java connectivity respectively.
-
CGI Interfaces to SQL Databases
- This third part
of Selena Sol's four part course
deals with CGI Interfaces to SQL Databases.
Part of the
WebWare series.
-
Java Database Connectivity
- The final part
of Selena Sol's four part course
deals with JDBC - Java Database Connectivity.
Part of the
WebWare series.
-
Simple SQL : Getting Started With SQL
Web Developers Journal
-
Simple SQL, Part 1 : Introduction
-
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
-
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
- 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.
|
|
