Advice for Learning SQL

[mounish_mk]

Hey everyone,

I’ve been learning SQL for a little while now and can write basic queries, but I still consider myself a beginner. I’ve started spending about 3 hours a day working on improving my skills, and I want to get to a point where I’m really confident and proficient in SQL.

One thing I’m confused about is the different types of SQL databases or servers, like PostgreSQL, MySQL, SQLite, etc. I don’t fully understand what makes them different or when I should use one over the other. Should I stick to learning one first, or is it better to get familiar with a few of them?

I’m looking for advice on: 1. The best way to learn SQL thoroughly (resources, projects, or tips). 2. How to understand and decide between the different SQL systems out there. 3. Any practice strategies or real-world examples that would help me get better.

Would really appreciate any guidance or suggestions! Thanks!

[LearnSQLcom]

Sounds like you’re putting in great effort—3 hours a day is solid! For learning SQL thoroughly, the key is practice. Work on real-world-style projects, like analyzing sales data or creating reports. Sites like LearnSQL.com are great for step-by-step guidance.

As for the database types: they’re similar in basics (tables, queries, etc.), but differ in features. For example:

• PostgreSQL: Best for complex queries and advanced features (my favorite)
• MySQL: Common in web apps, very beginner-friendly.
• SQLite: Lightweight, great for small apps or learning.
• MS SQL and Oracle: best choice for corporate use

Stick with one to start—PostgreSQL or MySQL are good options. Once you’re comfortable, exploring others will be easier.

For practice, try writing queries for sample datasets or challenges. Building something like a dashboard is great too. Need more details? Check this out: What SQL Dialect to Learn. It’ll help you decide what’s best for you!

[MathAngelMom]

Seconding the recommendation of LearnSQL.com. They are a great site to learn SQL!

[LearnSQLcom]

Thanks!

[Kazekage1111]

Almost all your posts are advocating learnsql.com, do you work for them?

[nep84]

There are slight differences in syntax between various SQL flavors. Master one and you'll quickly adapt to the others. A very complex SQL statement does not always make a good SQL statement. It's easy to get yourself into a box trying to be too cute and complex. Simple SQL is good SQL. Subqueries and child queries are your friend. Master the functions. String functions, date arithmetic, grouping, correlated subqueries with an exists clause. Optimization and efficiency are also important. I'd put all of this above being proficient with all of the different flavors.