SQL statement training

I've been working with an SQL database for several years.  I use Microsoft Access to generate reports, often building query upon query to pull the data I need.

I'd love to have some SQL select statement training so that I can use nested select statements to generate the data.  Any training courses I find are either way below my current level of understanding or way over my head.  For instance, I don't need a class that explains what a relational database is, how tables are joined, etc.  I need to learn the fundamentals of select statement writing.

Anyone have any ideas on where I might find such specific training sources?
sec1971Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Some references that you might find helpful:

Microsoft Access SQL reference
https://msdn.microsoft.com/en-us/library/office/dn123881.aspx

This has everything you can do in JET SQL with some basic examples.

My favoritate series of articles on JET SQL are these:

http://win.lucaarena.it/doc/sql_access1.pdf
http://win.lucaarena.it/doc/sql_access2.pdf
http://win.lucaarena.it/doc/sql_access3.pdf

 These are originally from the MSDN as well, but the content is no longer available (make sure you download a copy).

 While a bit out dated, it covers everything you can do with JET SQL from A-Z and gives examples of each.   You want to primarily focus on that first article, and probably more the later half.

 Look that over and see if it gets you started.  If not, let me know and I'll see if I can come up with something better.

Jim.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
madunixCommented:
0
PortletPaulfreelancerCommented:
I presume "SQL database" means Microsoft SQL Server (MSSQL) and for that platform I would recommend T-SQL books by Itzik Ben-Gan

MSDN's Transact-SQL Reference
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
No, she's using Access against SQL, so it would be JET SQL at play here, which as you know is somewhat of a unique dialect.

   Although knowing SQL's version would not hurt (for building views).

  Sounded like most of what was being done was in Access though.

Jim.
0
Jeffrey CoachmanMIS LiasonCommented:
<no Points wanted>
A few other notes
You mentioned that you needed to:
use nested select statements to generate the data.
One could take that to mean that you wanted a way to filter more than one field, or perhaps you need "Groupings (Sum, Average, Count, ...etc)"
(Can you explain your exact need?)
Both can be accomplished in a report directly;
Either by opening the report with specific criteria:
"CustID=" & 7 & " AND " & "OrderTotal>" & 1000
...or by using the Grouping Options in the report Wizard.
(and hiding the details)
...or some combination of both.

I know you stated that your background is in SQL and perhaps your ultimate goal here is to learn how to create subqueries in Access T-SQL, ...so take my post as just an FYI.
;-)
JeffCoachman
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Eyeballeth thy article Migrating your Access Queries to SQL Server Transact-SQL as a handy reference from someone that's walked down the trail you're currently on.  Good luck.
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
All - Based on this question and others I just kicked out an article called SQL Server Training.  Please let me know if you like it, and if yes click the 'Good Article' button at the bottom.  Thanks.  -Jim
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
System Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.