Q I'm going to be writing a database application, but I don't know much about programming of about databases. Should I learn Python before MySQL, or MySQL before Python?
A As far as our training is concerned, the order in which you learn the two technologies isn't especially important. They're like two large but well fitting jigsaw pieces - you need them both, but the order that you put them into the puzzle doesn't really matter. And in terms of connecting them together, there's just the tiniest drop of "glue" to go between them which we do cover on the Python course.
Footnote Although I've answered this question in relation to
python and
MySQL, the answer would equally apply to other programming languages such as
Perl and
PHP. In the case of PHP, some prior knowledge of HTML and web site structure is required before the PHP course - we can help with that on our
technology for PHP day ... but that's the subject for another day's entry!
(written 2005-09-13, updated 2006-06-05)
Associated topics are indexed under
S151 - Introduction to SQL and MySQL [3928] Storing your intermediate data - what format should you you choose? - (2012-11-20)
[3269] Files or Databases? MySQL, SQLite, or Oracle? - (2011-04-28)
[2786] Factory methods and SqLite in use in a Python teaching example - (2010-05-29)
[2567] Extra MySQL course dates (2 day course, UK) - (2010-01-08)
[2561] The future of MySQL - (2010-01-03)
[2134] Oracle take over Sun who had taken over MySQL - (2009-04-21)
[924] The LAMP Cookbook - Linux, Apache, MySQL, PHP / Perl - (2006-11-13)
[918] Databases needn't be frightening, hard or expensive - (2006-11-08)
[691] Testing you Perl / PHP / MySQL / Tcl knowledge - (2006-04-19)
[591] Key facts - SQL and MySQL - (2006-02-04)
[515] MySQL - an FAQ - (2005-12-03)
[382] Central London Courses - Perl, PHP, Python, Tcl, MySQL - (2005-07-18)
[175] Worthwhile - (2005-01-11)
[85] Present and future MySQL - (2004-10-12)
[84] MySQL - nuggets - (2004-10-11)
Y101 - Introduction to Python [1663] Python in an afternoon - a lecture for experienced programmers - (2008-06-01)
[1375] Python v Ruby - (2007-10-02)
[950] Python and the Magic Roundabout - (2006-11-27)
[949] Sludge off the mountain, and Python and PHP - (2006-11-27)
[909] Python is like a narrowboat - (2006-10-30)
[846] Is Perl being replaced by PHP and Python? - (2006-08-27)
[834] Python makes University Challenge - (2006-08-15)
[753] Python 3000 - the next generation - (2006-06-09)
[745] Python modules. The distribution, The Cheese Shop and the Vaults of Parnassus. - (2006-06-05)
[712] Why reinvent the wheel - (2006-05-06)
[710] Linux training Glasgow, Python programming course Dundee - (2006-05-05)
[629] Choosing the right language - (2006-03-01)
[380] Bridging to the customer requirement - (2005-07-16)
[317] Programming languages - a comparison - (2005-05-20)
5449
Some other Articles
Out of the norm.Tomorrow's meeting.Up earlySticky newsDatabase or Progamming - which to learn first?Server side scripting of styles to suit the browserHow far away is that server?Upgrade!You cantFair system for travel and accommodation expenses