[Sussex] [Fwd: MySQL User Group info & More]

[Andrew Guard]

Just thought some of you might be interested in this.

-------- Original Message --------
Subject: MySQL User Group info & More
Date: Thu, 6 Apr 2006 17:36:15 +0100
From: Imran Chaudhry <ichaudhry at gmail.com>


Hello All,

First off - thanks very much for your positive feedback on MySQL and
the talk at the Hampshire LUG meeting.

Next Meet-up
########

All of you expressed support for a MySQL user group (or your address
was given to me on the understanding that you would be interested!).

To keep things simple, I suggest we hold the first meetup with the
next LUG meeting. This will be near the start of May (more info:
http://www.hantslug.org.uk/cgi-bin/wiki.pl)

At the next meeting I will mention a few other tips that didn't make
it into the talk.

How many of you are running 5.0? I could demonstrate obtaining and
installing 5.0 on Linux from a tar.gz package, or over an existing
MySQL 3.23/4.x installation.

A few people would like to know more about joins and outer joins which
can be complicated beasts. When are left outer joins or joining a
table to itself useful? I could put together a short tutorial on this
starting from first principles.

Lemme know!

MySQL Certification
############

Some of you asked about certification. At the next meeting, I will
bring along my study guide (normally £35 or so) to lend out to anyone
who wants to go for certification against 4.1.

To pass Core certification, I didn't use the guide. I simply
downloaded the syllabus from
http://www.mysql.com/training/certification/4x/candguide.html and
studied the appropriate chapters from the DuBois MySQL 4.0 book.

Atom Database
#########

www.atomdatabase.org is not live yet. BUT the server it is running on
has MySQL 5.0 and I can register a MySQL 5.0 account to anyone who
wants one.

It's running on my a VM server located in the USA and it is subject to
transfer and space limits - but you could run a small or medium
website using this as the backend!

If you want a MySQL account you can have one. Simply email me the name
you want your database to have (and optionally it's default
collation). I will reply with the settings you need to log in.

If you like, I can pre-fill your database with tables from either the
'world' databse that MySQL use in their certification (see 'Examples'
at http://dev.mysql.com/doc/)

or the 'sampdb' database which is good for learning about
straight/inner/outer joins

(see http://www.kitebird.com/mysql-book/)

or the 'sakila' database which has lots of lovely triggers and stored
procedures.

(see http://www.openwin.org/mike/download/sakila-0.7.zip)

Then to access it right away you just need any MySQL client eg. the
command line client that comes with mysql or the MySQL query browser
(http://www.mysql.com/products/tools/query-browser/).

I will be running MySQL 5.1 concurrently.


Thats it, all the best!
Im

--
http://www.ImranChaudhry.info
MySQL Database Management & Design Services