Advice learning SQL

[dysfunction]

I'm trying to get a job as a systems accountant. Quite a few roles seem to require experience of SQL. I have no experience of this. Im good at finance systems software and that sort of thing.

Im thinking of perhaps doing a SQL course.

Would I be wasting my time and money as im not really a programmer? Or is it fairly easy to pick up?

Any advice or Suggestions regarding SQL courses and how to practice using it?

 

[old.Osy]

SQL in relation to accountant /analyst roles generally means ad-hoc generation of reports and data mining/sorting.

Nothing a few SELECTs * FROM won't handle. Unless they need a real DBA, you should be ok with just practicing by yourself. Google-fu and all that.

 

[Zenith.UK]

The only one you really need to know is:

SELECT * FROM users WHERE clue > 0
0 records returned.

 

[- English -]

try this one, they will be mega impressed.

DROP DATABASE <database_name>

 

[Zarjazz]

Even better, change your name.

 

[dysfunction]

I think i'm going to enrol for this. looks to me like it would be the right kind of level for me.
http://www.city.ac.uk/courses/short-courses/database-design-with-sql-server#course-detail=0

 

[Moriath]

select * from emp
where emp =

scott and tiger practice users on an Oracle DB

 

[Overdriven]

Don't bother with courses for initial SQL, learn the basics first. It helps if you know what vendor DBMS you want to use (Oracle, MySQL, MSSQL) due to minor syntax differences when writing queries.

I endorse MSSQL. TechNet, googling 'Normalisation' and 'SQL Server Central'

 

[Hawkwind]

I had some SQL experience from DB work back in the days of Paradox. I downloaded the Joes2pros vids for MySQL and just played around to get a refresher.

Bunch of free vids there on SQL
http://joes2pros.com/?page_id=43

 

[- English -]

+1 for joes2pros

 

[TdC]

dude: microsoft's SQL server is free if you don't want support. TSQL is actually pretty decent and iirc it actually comes with server manager, which is built in to MS's IDE these days. Install it in a VM and faggetahbaahtit.

 

[dysfunction]

dude: microsoft's SQL server is free if you don't want support. TSQL is actually pretty decent and iirc it actually comes with server manager, which is built in to MS's IDE these days. Install it in a VM and faggetahbaahtit.

Cheers dude! Now I have to work out how to create a VM!

 

[old.Osy]

Sun's Virtual Box will do.

 

[TdC]

alternately you can just install it on your computer

 

[Moriath]

Can get test license from oracle at otn just download it from there or MySQL

 

[Gahn]

https://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx

Tis should do for evaluating, it has some limitations but nothing you can worry about.

As for learning Sql it pretty much all boils down on what you are asked to do, if job revolves around providing Data in Reports or Files learning from T-Sql Guide http://msdn.microsoft.com/en-us/library/ms189826(v=sql.90).aspx should be a good start.

If Job requires Database Administration i'd suggest a Microsoft Certified Course : http://www.microsoft.com/learning/en/us/sql-training.aspx.

 

[Ono]

If you get decent at SQL let me know as we need some. YOu already have TM1 and BO so can be quite marketable.

Well, putting aside the bit where you are a bit of a spaz.

 

[dysfunction]

Employ me then Ono and I can learn on the job!

 

[Ono]

We need to have a catch up.

Our planning team lost an SQL person recently and they were struggling to get one in.

 

[dysfunction]

We need to have a catch up.

Our planning team lost an SQL person recently and they were struggling to get one in.

We can meet for lunch sometime. Let me know when you are free!