Best way to re-aquaint with SQL?

Furton

Furton

Furton

Soldato
Joined
9 Aug 2003
Posts
2,713
Location
Liverpool
Since graduating in 2005 from a Comp Sci course, I went straight into testing as the money was good and allowed me to save well for my 1 year of travelling. However, since returning I've struggled to find a job but have got an interview for a testing job on monday but they've asked me to brush up on my SQL.

Having not done much technical work since leaving Uni I'm a bit rusty on SQL and need some advice on how to brush up.

Would going through my old lecture notes be the best way or getting hold of a database and practising some commands on it be a better way?
 
I would say you should read your Uni notes. They would help you get back into SQL. You could then try a project of your own to implement using SQL so you devise your own problems and have to fix them yourself in terms of working out commands.

There is also some SQL stuff on W3Schools. http://www.w3schools.com/sql/default.asp. :)

I couldn't really recommend an SQL program although I know of two. MySQL and MS' SQL Server.

http://www.mysql.com/

http://www.microsoft.com/downloads/...b5-0b07-4448-8848-dcc397514b41&DisplayLang=en

You'd probably get a better response in HGP so I will ask a don to move this over for you. :)
 
As above, you should review your notes and read through some tutorial-type pages. Install MySQL, perhaps in a virtual machine, so you can play with a live database. For a free stack you could use Ubuntu Server selecting the LAMP (Linux, MySQL, Apache, PHP) option when you install on top of Virtualbox running on your Windows system.
 
Depending on the job it's probably unlikely that you will be asked anything terribly in depth - as long as you are able to demonstrate an understanding of the fundamentals e.g. data schema, create/load/alter/select statements etc, triggers/views and explain how you have used these in the past. If possible try and find out what type of database systems they are running (sql server, db2, sybase, mainframe based etc) and have a look at typical query tools.
 
You must log in or register to reply here.
Back
Top Bottom