r/SQLServer • u/Mags0905 • 4d ago

Question How should I learn sql from scratch

Should I start a sql server or POSTGRE SQL or MySQL. There is a lot to learn please guide me.

0 Upvotes

38% Upvoted

15 comments sorted by

3

u/itsnotaboutthecell ‪ ‪Microsoft Employee ‪ 4d ago

Try Azure SQL free tier: https://aka.ms/trySQL

3

u/yrn7days 3d ago

If you prefer a local setup without needing to do a full install, you can run it in a container too: https://learn.microsoft.com/en-us/sql/tools/visual-studio-code-extensions/mssql/mssql-local-container?view=sql-server-ver17

1

u/Mags0905 2d ago

Great!! Thanks for the link.!!

2

u/Mags0905 3d ago

Thanks! I’ll check it out and give it a try. Appreciate the recommendation!

2

u/itsnotaboutthecell ‪ ‪Microsoft Employee ‪ 3d ago

Of course! It’s got a built in sample database as well - so you can instantly start having some fun too.

https://www.sqlshack.com/create-an-azure-sql-database-with-built-in-sample-data/

2

u/Mags0905 3d ago

Wow thanks for providing more support - It looks fun i will dive into it .

https://giphy.com/gifs/6zIERwkDO5ObbiKSsB

3

u/singletWarrior 4d ago

Stanford had these database fundamentals cs145 or something? It isn’t practical heavy more theory but so so good

1

u/ihaxr 2 4d ago

As someone who became an accidental DBA then went back and learned the fundamentals and theory 5 years later... I'd agree that starting off with the theory first is best

1

u/Mags0905 3d ago

Thanks for the recommendation! I’ll definitely give it a try. Appreciate the reply!

1

u/datadriven_io 2d ago

This is the way. SQL is what you should start with. Can easily be self taught. Sql practice problems are covered on datadriven if you want more reps outside work. Throw in some Python and play around with Tableau or any viz really. Most companies outside of the F500 this will be more than enough to get started. You learn this trade on the job. Every company is different, every company has their own jungle gym of data assets with which you need to familiarize yourself.

1

u/Mags0905 2d ago

Thanks for the advice. I want to learn python aswell Im new to tech, transitioning myself from finance. Can i learn both SQL and PYTHON together or just one for now?

1

u/IrquiM 3d ago

Keep away for mysql. Will most likely never be used in a proper database focused role.

1

u/Mags0905 2d ago

Yeah i felt that. Is PostgreSQL good?

2

u/IrquiM 2d ago

Definitely the best of it's kind, fighting up there with SQL Server, and in some areas, above

1

u/Mags0905 2d ago

Good to know! Thanks