SQL Course Cape Town

D

Dryad

Well-Known Member
Joined
Jun 28, 2012
Messages
180
Reaction score
0
Hi,

I have a friend looking for a SQL course in Cape Town. Something that covers similar contents than the "Head first SQL" book by Lynn Beighley published by O'Reilly Media and would allow you to write the international recognized exam.

Do you maybe have any recommodations?

There are so many dodge IT "schools" out there these days, I would really appreciate any assitance.

Thanks!
 
I wouldn't pay anyone to teach me SQL.

The best way to learn it is install something like MySQL and then use google to run through some tutorials.

Focus your studies on the theory behind relational databases.

Seriously, SQL is piss easy. There are only 4 SQL data manipulation commands to learn. Insert, Select, Update and Delete. then how to do joins, and build a decent where clause. It's the database theory part that is hard.

There are shed loads of courses available on iTunes. Such as :
Database System Principles at Silicon Valley University.

Stanford University also has very good IT courses.
 
zippy said:
I wouldn't pay anyone to teach me SQL.

The best way to learn it is install something like MySQL and then use google to run through some tutorials.

Focus your studies on the theory behind relational databases.

Seriously, SQL is piss easy. There are only 4 SQL data manipulation commands to learn. Insert, Select, Update and Delete. then how to do joins, and build a decent where clause. It's the database theory part that is hard.

There are shed loads of courses available on iTunes. Such as :
Database System Principles at Silicon Valley University.

Stanford University also has very good IT courses.
Click to expand...

Depends on what he wants to do. MS SQL or MySQL. The syntax does slightly differ (as well as what you can do with it) and you have a lot more to learn in MySQL (ISAM/InnoDB/indexes etc) than you would in MS SQL where it literally is fire & forget and all your **** runs really fast (and even faster if you play around with indexes) :p
 
Dryad said:
Hi,

I have a friend looking for a SQL course in Cape Town. Something that covers similar contents than the "Head first SQL" book by Lynn Beighley published by O'Reilly Media and would allow you to write the international recognized exam.

Do you maybe have any recommodations?

There are so many dodge IT "schools" out there these days, I would really appreciate any assitance.

Thanks!
Click to expand...

Have the Head-First Book and honestly you'd learn alot more just getting the book and working through it yourself;quicker too compared to going to a week course,
Where I went though there was no internationally recognized exam, think the MS certification is as recognized as it gets,
 
AcidRaZor said:
Depends on what he wants to do. MS SQL or MySQL. The syntax does slightly differ (as well as what you can do with it) and you have a lot more to learn in MySQL (ISAM/InnoDB/indexes etc) than you would in MS SQL where it literally is fire & forget and all your **** runs really fast (and even faster if you play around with indexes) :p
Click to expand...

Sure.

If you can do MySQL, which is closer to ansi sql, then you can pick up SQL used in the other verndors such as Microsoft and Oracle. They all still work with ansi sql. I learnt SQL with Oracle. Occasionally I come across ansi joins in an Oracle script, and its wtf !!!. Google :D But it isnt a show stopper.

Btw, another good and really cheap way is download the Firefox browser and install the sqllite addon. Sqllite is an embedded sql engine.

http://www.sqlite.org/

Its used in a suprising number of places. I use it sometimes for writing iphone apps(when i dont feel like using Apples Core Data API). Since I work with SQL, its much more intuative for me use use sqllite to store things like application settings, user preferences for mobile and desktop apps. Claims to be the most widely deployed SQL database engine in the world. Probably running on your smartphone. In C/C++ you can write a custom DB class which is very lightweight. Obviously its not meant to process a gazillion rows, but hey, its SQL. I havent explored using for Andriod though. Not sure I can as Android is java and Im not sure about calling C/C++ API from Android. Woudl be cool if can, because then I reuse the classes in my iOS app.
 
Last edited:
+1 on sqllite. wish that **** existed in 2004/5 when I had to write an app and sql express wasn't an option
 
Thanks everyone, I passed on the information, much appreciated :)
 
zippy said:
I wouldn't pay anyone to teach me SQL.

The best way to learn it is install something like MySQL and then use google to run through some tutorials.

Focus your studies on the theory behind relational databases.

Seriously, SQL is piss easy. There are only 4 SQL data manipulation commands to learn. Insert, Select, Update and Delete. then how to do joins, and build a decent where clause. It's the database theory part that is hard.

There are shed loads of courses available on iTunes. Such as :
Database System Principles at Silicon Valley University.

Stanford University also has very good IT courses.
Click to expand...

+1.

I taught myself MySQL years ago, then with trial, error, and a lot of practise, mastered it.
Did Oracle at Unisa as part of my degree and add MSSQL to that, I have no issues writing pretty complex queries.

A book, a SQL server that you can practise on, and determination.... that's all you need.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X