Learning SQL recommendations

[Cliphead]

Doing more and more with MySQL and really need to learn SQL. So many books but no idea where to start, any ideas?

I know the basics and comfortable with the command line but need to get beyond simple querys.

 

[MarillionFan]

Doing more and more with MySQL and really need to learn SQL. So many books but no idea where to start, any ideas?

I know the basics and comfortable with the command line but need to get beyond simple querys.

I might have a training course I put together. I'll see if I can dig it out.

 

[Cliphead]

I might have a training course I put together. I'll see if I can dig it out.

Thanks MF, I'd really appreciate that.

 

[EternalOptimist]

Generally, or are you using a specific app ?

 

[Cliphead]

Generally, or are you using a specific app ?

ClientCo have a custom written app using MySQL as the backend DB. Eventually I'm going to have to create reports and otherwise do the DBA thing.

For years I've been creating and sort of maintaining MySQL and PostresSQL databases but actually creating queries I've never had to do much with.

Got Navicat and can connect remotley but I want to learn the basics before using graphical tools. Using that I'm creating thngs using trial and error, sure way to get bad habits.

 

[EternalOptimist]

ClientCo have a custom written app using MySQL as the backend DB. Eventually I'm going to have to create reports and otherwise do the DBA thing.

For years I've been creating and sort of maintaining MySQL and PostresSQL databases but actually creating queries I've never had to do much with.

Got Navicat and can connect remotley but I want to learn the basics before using graphical tools. Using that I'm creating thngs using trial and error, sure way to get bad habits.

right. cant help unless you have a specific problem then. knowing there is a risk of bad habits is actually a good thing, it's the peeps who think 'oh yeah , i'll remember all this next year' who will get in too deep.

 

[Cliphead]

right. cant help unless you have a specific problem then. knowing there is a risk of bad habits is actually a good thing, it's the peeps who think 'oh yeah , i'll remember all this next year' who will get in too deep.

Thanks, just need to put the time in and learn. I have half an idea but getting it right at the beginning to fill in the gaps is important.

 

[EternalOptimist]

Thanks, just need to put the time in and learn. I have half an idea but getting it right at the beginning to fill in the gaps is important.

I have no idea what level you are thinking, so apologies if I am teaching granny to suck eggs, but make your stuf reusable and parameterised.
switchable. build a library

 

[Cliphead]

I have no idea what level you are thinking

Basics, basics...

I understand the concept of a library but wouldn't know where to start. I can create a db, tables, fields, keys but that's about it.

 

[Zippy]

Basics, basics...

I understand the concept of a library but wouldn't know where to start. I can create a db, tables, fields, keys but that's about it.

You could start with a specific query you have to write, have a go at writing it, post the query here with a request for suggestions for improvement and , err, duck.