SQL Language Tutorial Needed

[Mike Labosh]

For a friend of mine. MS Access 2003 dialect, if possible, but general
SELECT, INSERT, UPDATE, DELETE is probably good enough for now. I'll worry
about GROUP BY, HAVING, PIVOT and TRANSFORM when she asks.

Any good links to decent articles out there?

--


Peace & happy computing,

Mike Labosh, MCSD MCT
Owner, vbSensei.Com

"Escriba coda ergo sum." -- vbSensei

 

['69 Camaro]

Hi, Mike.

Any good links to decent articles out there?

MSDN has a few tutorials for fundamental, intermediate, and advanced Jet 4.0
SQL:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acfundsql.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acadvsql.asp

The following aren't specifically for the Jet 4.0 dialect, but they're still
good for a beginner. The following one shows SQL Server, Oracle and MySQL
syntax:

http://www.1keydata.com/sql/sql.html

This one is generic SQL and provides an interactive query window:

http://www.sqlcourse.com

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

['69 Camaro]

Hi, Mike.

I thought of something else that might help. I've had the Microsoft Jet SQL
Reference for such a long time that I don't remember whether it was
installed as part of Microsoft Office 2003, or I manually installed it
myself from a download from Microsoft's Web site. If it's part of Office
2003, then the Help file can be located here:

"C:\Program Files\Common Files\Microsoft Shared\OFFICE11\1033\JETSQL40.CHM"

It has the Jet 4.0 SQL syntax, explanations, and examples.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Van T. Dinh]

It is part of Access Help. You can access this through the "book" Microsoft
Jet SQL Reference in Access Help Contents.

HTH
Van T. Dinh
MVP (Access)

 

[Mike Labosh]

unfortunately, this is an End-User we're talking about, and she wants *free*
hand-holding so she doesn't have to reach out her stubby finger and press
the F1 key.

So this way, I can feed her some links to read and let her have at it.

I personally don't have the time for stuff like, "What's a Select Query?"
My answer: RTFM!

I think it was Mark Twain (Correct me if I'm wrong) that said, "If you lead
a horse to water, he will drink. If you show a horse how to *find* water,
he will drink on his own"

Similarly, if you tell an end-user how to write a select statement, you will
be chained to that end user forever. However, if you tell the end user how
to google for a select statement....



--


Peace & happy computing,

Mike Labosh, MCSD MCT
Owner, vbSensei.Com

"Escriba coda ergo sum." -- vbSensei

 

[Van T. Dinh]

Tell her to buy a copy of the book "SQL Queries for Mere Mortals" by
Hernandez & Viescas and read it in her own time???