« GRITZ Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next

Re: Recommended: SQL for Data Analytics - Learn SQL in 4 Hours (free). Plus thanks to Zim! 

By: Zimbler0 in GRITZ | Recommend this post (1)
Mon, 19 May 25 6:23 AM | 14 view(s)
Boardmark this board | Grits Breakfast of Champeens!
Msg. 08529 of 08556
(This msg. is a reply to 08518 by Fiz)

Jump:
Jump to board:
Jump to msg. #

Fiz > but this is an exceptionally solid, high-level yet hands-on, SQL CRASH course.


Your welcome. Though I don't remember providing the link . . .

I have a vague memory of being exposed to SQL . . . And, if I remember correctly, there is a way in Access (Microsoft Office Access) to change a query into SQL . . . or maybe even write a query in SQL.

I was more of an electron pusher, than a data processing guy. Though I did write and implement the shop inventory program. And I maintained the shop log program (both in Access).

At least a couple of the systems we ran had 'Sequel Server' data bases built into them. And I remember using Access as a 'Front End' to one of them so I could use Access to fish certain data sets out of the Server. Interesting stuff.

Zim.




Avatar

Mad Poet Strikes Again.


- - - - -
View Replies (1) »



» You can also:
- - - - -
The above is a reply to the following message:
Recommended: SQL for Data Analytics - Learn SQL in 4 Hours (free). Plus thanks to Zim!
By: Fiz
in GRITZ
Mon, 19 May 25 3:06 AM
Msg. 08518 of 08556

http://www.youtube.com/watch?v=7mz73uXD9DA

I doubt anyone here has any interest, but this is an exceptionally solid, high-level yet hands-on, SQL CRASH course. After a discouragingly long search, trying to find something neither too theoretical nor too basic (boring), I found this just yesterday. I am about 1.5 hours into the 4 hours (running videos as 2x normal speed) and I have seen enough to highly recommend this. A wonderful teacher; very to the point, and providing lots of hands on queries to run, yourself, on the provided database with SQLite and Postgres (haven't hit the Postgres yet).

Anyway, a really high quality, hands-on tutorial, and not just a come-on to spend money (he does ask for a donation, but he doesn't require it to give value). I'll probably donate something at the end.

Oh, BTW, A much belated “thank you” to Zimbler for recommending https://www.amazon.com/Advanced-Engineering-Mathematics-Erwin-Kreyszig a few years ago. I can't claim I've exactly completed the book, but I am buying my 2nd copy (too heavy to carry on the plane;-). It's nice to see math with pretty nearly everything explained in physics terms. (Even if I don't know the physics, it is much more motivating for me to have practical reasons to do the problems).

Who here was an engineer or physicist? I'm looking for other recommendations that might allow me to take some short cuts without missing the point of the journey entirely.

And I now return you to your regular programming!


« GRITZ Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next