Learning SQL

General Memory Chat
1

Hi all,

I’m starting to learn SQL and I’m wondering what is the most efficient way to go about this. I just started a tutorial and I’m placing each example I learn in a loci. It’s working well so far but I imagine recall being a problem if I have to go through each example I ever learned in order to find what I need.

Would memorizing all commands and grouping them by functions as it is presented in the below link be more efficient?

4 Likes
2

Are you memorizing from the “PostgreSQL commands” section in the middle of the page, the linked PDF, or the “fundamentals” in the sidebar?

1 Like
3

Currently I’m just using a tutorial/online course which follows a traditional learning method of introducing a new syntax, explaining it, showing examples, and reinforcing knowledge with problems.

Apologies, I should’ve provided more info about the link, it is just something I looked up right now. I think the combination of these three would be the most exhaustive as that PDF looks incomplete. My idea would be to group syntax and definition learning by function e.g. table joins, managing tables, data types, data operations, etc.

The above method does seem to make most sense to me right now, but maybe someone else used a different method when they learned a new programming language.

2 Likes
4

You could group the information in sections within the memory palace. Example: if the memory palace is a house, a different room could be used for each group. Then if you want to look up the information about joins (or whatever), you could walk through the room that holds the information about joins.

2 Likes
5

Thanks, Josh. That seems like a great way of approaching this problem.

2 Likes
6

If you come up with a good system and want to share how you grouped the facts, I’d be interested in seeing it.

We moved the last MySQL database on this site to Postgres recently, so I’ve been reading that postgresqltutorial.com site lately. I also picked this up this Postgres course for about $12 recently and have been casually watching sections. (Udemy courses go on sale every couple of weeks.) A lot of the knowledge from MySQL transfers to Postgres but some things are different.

2 Likes
7

I will share how I grouped everything after I’m done.

I’m currently taking the this course. I found the site from its somewhat popular 8-week SQL challenge. The challenge is free to do and though there are no answers you can probably just use Excel to verify your queries.

Glad to hear that there is a big overlap between MySQL and PostgreSQL! In case I ever land that data analytics position but they’re using some other type of SQL. Thanks for sharing the course, I might take it if my current course does not cover everything.

2 Likes
8

The project-based nature of that course looks good.

2 Likes
9

mySQL is easy to learn but hard to be excelled.
In w3school, you can do experiments on given data.

image
image1242×2148 194 KB

I remembered that my SQL is just an average grade. The hardest type question is related to the joining multiple set and select reconstruction of a specific functional task table.

1 Like
10

If anyone is into Udemy, they just started a $9.99 sale (at least in the US) that runs until August 13th.

1 Like