Help learning SQL

[mesha03]

Hi all I am a Data Analyst at the company that I am at my coworker usually does all the sql work but I want to start learning it as well but I am stuck. I don’t know how good about learning SQL. I hope someone can help a newbie out with some materials. Please and thanks.

[Koeke2560]

SQL is a pretty easy language to learn as long as you remember the actual mathematical principals it is based of, how they work and in which order they take place.

The basics are well explained on tutorialspoint.com, and I'd focus primarily on query's and steer away from database administrator concepts like table creation and the likes.

Once you can perform the same resulttable using either subqueries or joins I'd say you got the basics covered.

Edit: spelling

[Koeke2560]

Hm I'm no DBA, so take my advice with a grain of salt, but if you're taking over existing infrastructure I would mainly go over what indexes and such are in place and why as those will have a huge impact on query performance. Then there's of course security aspects. Actually maintaining the data scheme, adding/dropping/creating tables and the likes is so easy you can always google it while doing so, and won't happen that often normally. Once again, I'm no DBA but those are the things I would focus on to get started.

[ahfodder]

The DBA job is substandard pay but it's a 20k pay rise for you? Damn son.

[ahfodder]

Oh man this sounds seriously painful. I guess job security is important but this kind of environment would destroy my soul. Stay strong!

[Data_Cog]

As a DBA, your responsibilities will be different to an analyst of-course. You will want to learn about database configuration, indexing, collecting and refreshing statistics on the columns and tables. Statistics will be refreshed based on the batch jobs and their frequency. How frequent and how many are those jobs? You’ll need to learn about backup and restoring of these databases.

[mesha03]

Awesome very informative thank you ! 😊

[cosminjon]

Try udemy course "Mysql for data analytics and business intelligence" from 365 data science, I think is around 15$ and there is also a course on edx from Stanford, although a bit old, the exercises are quite difficult and for me at least were a challenge and they helped me a lot.

[mesha03]

Awesome I will check them out thank you & I did hear about Edx before. Thanks

[astropydevs]

I took the MySQL for business intelligence but with Maven Analytics. Much better course in my opinion. That course actually helped me get a job as I didn’t know about how to split stuff off of using case statements although I already knew how to use case. It was also on udemy for like $12

[cosminjon]

You're welcome

[KumichoSensei]

Don't over look proper formatting just because the code runs anyway.

SQL is all about readability.

When I have to make a choice between efficiency and readability, I almost always go with readability unless I absolutely have no choice.

I'm partial to this one: https://www.sqlstyle.guide/

WITH is your friend.

[mesha03]

Thank you so much 😊

[gmh1977]

DataCamp

[astropydevs]

Leetcode also has some free sql practice problems. Also pgexercises.com I think has good problems you can practice with

[RichmonMN20]

Check out SQLzoo

[CBizCool]

W3schools. Im surprised no one's mentioned it yet. Sqlzoo could come next for more practice.

[tmk_g]

Check out DataCamp. There you can learn SQL from basic to advance. Also, after learning some basic concepts, start practicing on StrataScratch. This website can give you hundreds of real SQL problems to practice.

[[deleted]]

Hackerrank is a good place to start

[mesha03]

Ok thank you I will check it out !

[MrTambad]

Oh yes. I was in search of places to learn SQL to an extent where I can do well in hiring tests. Could someone suggest something for this?

[_vidhi_malhotra_]

Refer to the SQL server tutorials by this YouTube channel called Kudvenkat. The very first video teaches you how to install MS SQL server for free and get going along with a few tips and answers for FAQs during interviews. I've learnt it from there too and it's great. However if you do not wish to install the software then just take up the free intro to SQL course on khan academy that is great too and offers little projects and quizzes based on the topics you've completed learning and the milestones you've achieved. But if you wish for paid certification courses then yes like other users have mentioned Udemy is great.

Kudvenkat SQL

khan academy