Good places to learn SQL from? Datacamp not great
Question about Data Camp’s SQL track.
Is this SQL cheat sheet correct? Source from DataCamp.
Struggling with SQL self-study (Datacamp Skill Track) — feels like my brain just freezes. Any advice or resources?
Does DataCamp offer Data Analyst Certification?
What is a Data Analyst?
Data analysts work with business stakeholders to provide actionable insights from data. They are typically using visualizations and statistical methods to understand and interpret data, identify patterns and trends and make recommendations. They will generally be using SQL and visualizations tools, adding in Python or R as they progress in their career.
How long are DataCamp Certifications valid for?
Our Career Certifications are valid for two years from the date awarded. The data industry is moving quickly and it is important to keep your skills up to date, so you will be invited to retake the exams after two years, or if you would prefer, you can attempt to upgrade to a more advanced level certification.
Videos
So I’ve been going over datacamp and have completed the intermediate sql and the course on Joins etc but recently I tried taking a test for a product firm that required SQL and most of the questions were on joins but I just scored a 12/22. Additionally I am trying to solve the intermediate questions on hackerank related to SQL and I am failing to do so. The basic ones were pretty easy.
I am wondering what resources I should look at to relearn SQL or maybe datacamp gets better as I progress? Idk. So far it seems to gloss over a lot of concepts but there is a lack of application. Or maybe I’m not very good at this and should just stick to corporate finance :/
I see there is a career track on DataCamp for SQL. It is data Data Analyst with SQL Server. It looks to focus on Microsoft SQL server and using Excel as well. This one looks to be 40 hours as it gets into Database design.
There is another that is just a SQL Fundamentals course that teaches PostgreSQLthat is part of the larger Python and R data analyst tracks. It looks to include less being around 22 hours or so.
I don’t really know enough to know the differences or benefits of either, or what differs between PostgreSQL or the T-SQL used by Microsoft.
I plan on solidifying my SQL knowledge as I have completed some tutorials on sql basics going back 6 months.
My goal is to create a data project portfolio using SQL, Tableau(which I am also taking courses for) and Excel in order to display this as a link on my resume to show what I know. My end goal would be to at-least land an entry level job as a data analyst. I have also started learning some Python.
Does anyone have recommendations of which track I should focus on? Or any other recommendations of outside courses I should take instead of DataCamp? Is it recommended? From what I have been reading companies only care what you can do with those skills? Which is why I would like to set myself apart with a portfolio.
I just want to ensure I build a solid foundational knowledge and I don’t know the best way to go about doing that. I see a lot of jobs that require SQL, but really don’t know which flavor to take up.
Any advice is very appreciated.