SQL Training

[Matt S]

Where's the best place to start?

 

[Douglas J. Steele]

SQL Queries for Mere Mortals, by John Viescas and Michael Hernandez

http://www.amazon.com/dp/0321444434...iveASIN=0321444434&adid=0369HV1RFT2TWCGH5DMV&

 

[George]

Tough question to answer because it is so broad.

For starters, SQL is supposed to stand for Structured Query Language
(although I've heard it stated as Standard Query Language). In any event, it
is, well, a computer language specifically designed for the retrieval and
management of data in relational database management systems (RDBMS),
including SQL Server, Oracle, Access, etc. Each RDBMS implements a slightly
different flavor of SQL, which means you'll need to foucs on the one which
is used in your RSBMS, e.g. Access, which uses SQL in its queries.

Sometimes, though, people use "SQL" to refer to the SQL Server RDMS itself.
Is that what you mean by any chance?

For my money, one of the best ways to learn anything is to get hands on, so
if you have access to MS Access and can locate some sample mdbs or accdbs,
I'd recommend just diving into them and seeing how the queries in them work.
The Access help system is pretty good.

If you want classes or training, the place to start is you local community
college or trade school. Not likely to be the most advanced training, but
good introduction to the subject, if they have classes, and less expensive
than some other options might be.

I don't have any book recommendations, unfortunately, although a quick
search on Amazon or B&N should turn up several titles.

George

 

[George]

Doug,
Sounds good. I have Michael's DBs for Mere Mortals and refer to it a lot. .

George

 

[Matt S]

Tough question to answer because it is so broad.

For starters, SQL is supposed to stand for Structured Query Language
(although I've heard it stated as Standard Query Language). In any event, it
is, well, a computer language specifically designed for the retrieval and
management of data in relational database management systems (RDBMS),
including SQL Server, Oracle, Access, etc. Each RDBMS implements a slightly
different flavor of SQL, which means you'll need to foucs on the one which
is used in your RSBMS, e.g. Access, which uses SQL in its queries.

Sometimes, though, people use "SQL" to refer to the SQL Server RDMS itself.
Is that what you mean by any chance?

For my money, one of the best ways to learn anything is to get hands on, so
if you have access to MS Access and can locate some sample mdbs or accdbs,
I'd recommend just diving into them and seeing how the queries in them work.
The Access help system is pretty good.

If you want classes or training, the place to start is you local community
college or trade school. Not likely to be the most advanced training, but
good introduction to the subject, if they have classes, and less expensive
than some other options might be.

I don't have any book recommendations, unfortunately, although a quick
search on Amazon or B&N should turn up several titles.

George

 

[Matt S]

Thanks. I'll Check it out.

SQL Queries for Mere Mortals, by John Viescas and Michael Hernandez

http://www.amazon.com/dp/0321444434...iveASIN=0321444434&adid=0369HV1RFT2TWCGH5DMV&

 

[Matt S]

Thanks. I'm interested -for now - in using SQL in Access and maybe Brio.
I'll check with my local community college. Tks again.