347d Database or Progamming - which to learn first?
Training, Open Source Computer Languages

Search for:
Print friendly page
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Database or Progamming - which to learn first?

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
Back to
Server side scripting of styles to suit the browser
 Previous and next
or
Horse's mouth home		 Forward to
Sticky news
Some other Articles
Out of the norm.
Tomorrow's meeting.
Up early
Sticky news
Database or Progamming - which to learn first?
Server side scripting of styles to suit the browser
How far away is that server?
Upgrade!
You cant
Fair system for travel and accommodation expenses
4086 posts, page by page
Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82 at 50 posts per page


This is a page archived from The Horse's Mouth at http://www.wellho.net/horse/ - the diary and writings of Graham Ellis. Every attempt was made to provide current information at the time the page was written, but things do move forward in our business - new software releases, price changes, new techniques. Please check back via our main site for current courses, prices, versions, etc - any mention of a price in "The Horse's Mouth" cannot be taken as an offer to supply at that price.

Link to Ezine home page (for reading).
Link to Blogging home page (to add comments).
You can Add a comment or ranking to this page
Public Training Courses
Running regularly at our UK training Centre.
[Schedule] - [About] - [Book]

Like this? ??

Related short articles
Django - first steps - Updated
Test Driven Development in Python - Customer Comes First
Cacheing class for Python - using a local SQLite database as a key/value store
JSON from Python - first principles, easy example
Learning about Object Orientation in PHP - a new set of examples
MVC and Frameworks - a lesson from first principles in PHP
Frameworks - learning through exploring and understanding data sources
SQL databases from Python - an SQLite example
Reading and checking user inputs - first lessons - Ruby
Which database should I use? MySQL v SQLite
Christmas Bus Schedule for Melksham - First Bus
Melksham Bus Issues - to be raised at First Bus Customer Panel
First match or all matches? Perl Regular Expressions
Filtering PHP form inputs - three ways, but which should you use?
Shell - Grep - Sed - Awk - Perl - Python - which to use when?
Flowchart to program - learning to program with Well House
Inheritance, Composition and Associated objects - when to use which - Python example
Formatting output - why we need to, and first Python example
Learning to use existing classes in Perl
Know Python or PHP? Want to learn Perl too?
Want to escape the Olympics? Learn to program in the countryside!
Learning to program - the if statement. Python.
Not everyone has a computer - 9 more ways to learn about the Melksham Campus
Looking and Learning - even on Holiday
Learning to Program in Lua - public / open training course / class
Learning C++ - a design pattern for your first class
Functions are first class variables in Lua and Python
A Pivotal Incident - learning how to welcome your guests
Defining database relations in your Django model
Want to learn iPad and iPhone programming? Come along and learn with me for free.
Learning about how to help people learning - and retaining
Emergency First Aid Provision at Well House Manor - part of the service
Transport in Cambridgeshire - seen by an outside observer. What can Wiltshire learn?
Adding Expect on top of Tcl - what is it and where can I get a training course to learn about it?
Telling which ServerAlias your visitor used - useful during merging domains
First of the year
Python or Lua - which should I use / learn?
Learning more about our web site - and learning how to learn about yours
Learning to program in PHP - Regular Expression and Associative Array examples
Emergency First Aid at Work (HSE) training in Melksham - places available for 19.1.2012
Which West Wilts Town? A picture quiz for you
Databases - when to treat the rules as guidelines
Catching the fishes first?
MySQL, MySQLi, PDO or something else - how best to talk to databases from PHP
Which or ATOC - who reads train fares right?
3 digit HTTP status codes - what are they, which are most common, which should be a concern?
Open Source Training Schedule - learn a programming language - in Autumn 2011 or 2012
New Camera - very first picture, and next from first films
C - a first program that does something useful for you
Date of the Census (which month and day?)
Structures v Structure Pointers in C. How, which, why.
A framework with python - Django - first steps
Learning to write good programs in C and C++ - separating out repeated code
My First Christmas
Perl - database access - DBD, DBI and DBIx modules
Learning Object Orientation in Perl through bananas and perhaps Moose
Sizers (geometry control) in a wxPython GUI - a first example
Databases - why data is split into separate tables, and how to join them
String handling - from first steps to practical examples
Gathering information - logging - with log4j. First steps.
How to display information from a database within a web page
Learning to Program ... in PHP. Course examples.
Learning to program - where to start if you have never programmed before
Camilla, Duchess of Cornwall, turns first sod in Melksham Link Canal
Upload Image, Store in database, redisplay in browser. PHP and MySQL
Learning about Regular Expressions in C through examples
Are you learning Perl? Some more examples for you!
Learning to program in Python 2 ... and / or in Python 3
Connecting Python to sqlite and MySQL databases
First and last match with Regular Expressions
Make and makefiles - a commented example to help you learn
Training comparison to QA Training, Learning Tree, GB Direct.
Learning to program in ...
Learn about MySQL stored procedures
Using print_r in PHP to explore mysql database requests
Which version of MySQL am I running?
Are you wanting to learn PHP?
A first demonstration of OO, including polymorphism
Checking the database connection manually
Making variables persistant, pretending a database is a variable and other Perl tricks
4a6
© WELL HOUSE CONSULTANTS LTD., 2013: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/mouth/444_Data ... irst-.html • PAGE BUILT: Sat Feb 23 12:39:13 2013 • BUILD SYSTEM: wizard
0