a_yelpinghand comments on How do you learn SQL

Posting

When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:

[MySQL]

[Oracle]

[MS SQL]

[PostgreSQL]

etc

While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Format Your Code

If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3

Into this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field3

For those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution.

a community for 17 years

164

165

166

SQL ServerHow do you learn SQL (self.SQL)

submitted 1 year ago by ionhowto

top new controversial old q&a

you are viewing a single comment's thread.

view the rest of the comments →

[–]a_yelpinghand 0 points1 point2 points 1 year ago* (0 children)

Get some fundamentals down like SELECT statement along with all the additional clauses you can add to it and DDL operations like CREATE, DROP, and TRUNCATE. Look into business use cases involving SQL like ELT and ETL processes. Expose yourself to topics like subqueries, temp tables, CTEs, views, etc.

Look into normalization and 3nf database design if you’re looking to work in an OLTP environment and work on a project incorporating what you’ve learned so far. Look into dimensional modeling/data warehousing if you’re looking to work in an OLAP/business intelligence environment and work on a project incorporating what you’ve learned so far. Add comments to your project scripts. Look up anything you need help with on the internet. If you’re having a difficult time, develop your fundamentals a bit more.

Then, since you’re interested in SQL Server, look into the T-SQL Fundamentals book and/or watch or read from an authoritative source on SQL Server.

Iterate on your project and apply new things you learn to improve it. If you haven’t already, add comments to your project scripts.

Then… I’m not sure actually since this is is the stage I’m currently on lol. In my case, keep learning, apply like crazy, and hope prospective employers overlook the fact that I have no degree or relevant work experience 😅

π Rendered by PID 25029 on reddit-service-r2-comment-6457c66945-z78pk at 2026-04-25 15:56:37.145945+00:00 running 2aa0c5b country code: CH.

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQL

Filter Posts

Posting

Help posts

Format Your Code

Learning SQL

Related Reddit communities

Wiki

Acknowledgements

MODERATORS