MySQL ODBC Connector - MySQL database design documentation

Author

MySQL database design documentation

Maurice van Peursem

2005-11-27, 8:24 pm

Hi,

I'm relatively new to the database-scene. I've installed MySQL on Mac
OSX 10.3, which was easy. I've installed Perl support for MySQL,
which was suprisingly difficult. I've installed CocoaMySQL
(http://cocoamysql.sourceforge.net/) to create, inspect and backup
databases. And now I'm building my first database, and that is not as
easy as I had hoped. I know that use of the 'JOIN' keyword can save
me pages of Perl code, but how it works exactly is not yet clear to
me.

Therefore I'm looking for a book, or maybe other documentation (on
the web?), that can point me in the right direction. More
specifically, I'm looking for a book that explains how to design and
build databases, with examples of the queries in MySQL. Most books
describe how you install MySQL, and list the SQL commands, but this
information I already have. Can any of you suggest to me some helpful
learning material?

Thanks,
Maurice van Peursem
The Netherlands

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Rhino

2005-11-27, 8:24 pm

----- Original Message -----
From: "Maurice van Peursem" <mpeursem@ision.nl>
To: <mysql@lists.mysql.com>
Sent: Sunday, November 27, 2005 6:33 PM
Subject: MySQL database design documentation

> Hi,
>
> I'm relatively new to the database-scene. I've installed MySQL on Mac OSX
> 10.3, which was easy. I've installed Perl support for MySQL, which was
> suprisingly difficult. I've installed CocoaMySQL
> (http://cocoamysql.sourceforge.net/) to create, inspect and backup
> databases. And now I'm building my first database, and that is not as easy
> as I had hoped. I know that use of the 'JOIN' keyword can save me pages of
> Perl code, but how it works exactly is not yet clear to me.
>
> Therefore I'm looking for a book, or maybe other documentation (on the
> web?), that can point me in the right direction. More specifically, I'm
> looking for a book that explains how to design and build databases, with
> examples of the queries in MySQL. Most books describe how you install
> MySQL, and list the SQL commands, but this information I already have. Can
> any of you suggest to me some helpful learning material?
>
For the most part, _any_ good database design book for _any_ decent
relational database should do the job for you. That's because all (?) of the
professional grade databases use the same SQL and the same normalization
techniques to decide what columns belong in what tables and what primary and
foreign keys should be used. Therefore, a good design book for DB2 or Oracle
or Sybase would probably tell you almost exactly the same things as a good
design book specifically intended for MySQL. You will still need to use the
MySQL reference to help you with places where the MySQL syntax is slightly
different than the syntax used by the other database but this really
shouldn't happen too often.

However, if you want a design book specifically written for MySQL, you may
want to look at http://www.informit.com/articles/ar...p?p=30885&rl=1. I
should stress that I don't have this book, nor have I read it cover to
cover. But the sample chapter on database design is pretty good, so, if the
rest of the book is as good, you should come out okay. In fact, you may find
that the sample chapter alone, which you can read online for free, may tell
you everything you really want to know and save you the cost of the book. No
guarantees on that but it's a starting point anyway.

By the way, I have not seen any other MySQL Design books so there may be
others that are better. The URL I've given you actually mentions some other
books specifically for MySQL that may suit your personal learning style
better.

Rhino

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.8/183 - Release Date: 25/11/2005

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Ligaya Turmelle

2005-11-27, 8:24 pm

-------------- 04070407020008090909
0007
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

A couple of good links for databases.

Database Design (quick and dirty, but gets the points across):
http://www.geekgirls.com/menu_databases.htm - the from scratch side

SQL:
Basics: http://www.sqlcourse.com (you probably already know this stuff -
but just in case.
semi-Advanced: http://sqlcourse2.com (joins are specifically at
http://sqlcourse2.com/joins.html).

Maurice van Peursem wrote:
> Hi,
>
> I'm relatively new to the database-scene. I've installed MySQL on Mac
> OSX 10.3, which was easy. I've installed Perl support for MySQL, which
> was suprisingly difficult. I've installed CocoaMySQL
> (http://cocoamysql.sourceforge.net/) to create, inspect and backup
> databases. And now I'm building my first database, and that is not as
> easy as I had hoped. I know that use of the 'JOIN' keyword can save me
> pages of Perl code, but how it works exactly is not yet clear to me.
>
> Therefore I'm looking for a book, or maybe other documentation (on the
> web?), that can point me in the right direction. More specifically, I'm
> looking for a book that explains how to design and build databases, with
> examples of the queries in MySQL. Most books describe how you install
> MySQL, and list the SQL commands, but this information I already have.
> Can any of you suggest to me some helpful learning material?
>
> Thanks,
> Maurice van Peursem
> The Netherlands
>

--

life is a game... so have fun.

-------------- 04070407020008090909
0007
Content-Type: text/plain; charset=us-ascii

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
-------------- 04070407020008090909
0007--

Ben Wilson

2005-11-27, 8:24 pm

Relational Database Design Clearly Explained, Second Edition
ISBN: 1558608206

The original edition was my first primer on relational databases. It was
an excellent read.

Ben

Maurice van Peursem wrote:
> Hi,
>
> I'm relatively new to the database-scene. I've installed MySQL on Mac
> OSX 10.3, which was easy. I've installed Perl support for MySQL, which
> was suprisingly difficult. I've installed CocoaMySQL
> (http://cocoamysql.sourceforge.net/) to create, inspect and backup
> databases. And now I'm building my first database, and that is not as
> easy as I had hoped. I know that use of the 'JOIN' keyword can save me
> pages of Perl code, but how it works exactly is not yet clear to me.
>
> Therefore I'm looking for a book, or maybe other documentation (on the
> web?), that can point me in the right direction. More specifically, I'm
> looking for a book that explains how to design and build databases, with
> examples of the queries in MySQL. Most books describe how you install
> MySQL, and list the SQL commands, but this information I already have.
> Can any of you suggest to me some helpful learning material?
>
> Thanks,
> Maurice van Peursem
> The Netherlands
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links