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 :/
Apologies if it’s not the right sub. I have been using DataCamp for a while. And I find it not too bad for getting your head around the basics I’ve completed the basic & intermediate sql courses. But I don’t find they go very deep. A lot of the posts on here refer to term’s and concepts I’m still very unsure of.
Any recommendations on going beyond basic SQL?
Videos
Would anyone recommend the datacamp for beginners? I saw that they're having a sale currently and was thinking about getting to learn SQL. Thanks
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.
I’m Mechanical Engineering, and currently work as Data Analyst, and I planned to do a Master in Data Science.
Now I didn’t feel motivated with the videos from Datacamp about SQL, and sometimes I guess that my best way to learn are books combined with practical exercises from Kaggle or StrataSratch (ie.), since I can move forward at a better pace and not in such a basic way.
I don’t want to feel that I’m giving up or losing my money in Datacamp :(
Hi everybody. I'm learning SQL on data camp which unfortunately does not have much guidance on the order in which the SQL sub-tracks should be taken. I've mastered the fundamentals (i and iii, below) but where do I go from here? I'm also not sure how the Database administrator skill tracks are different from the rest (especially if my goal is to use SQL for data analysis)? Any guidance would be much appreciated!:
Here are the available sub-tracks:
i) SQL Fundamentals,
ii) SQL for business analysts,
iii) SQL Server Fundamentals,
iv) SQL Server for Database Administrators,
v) SQL for Database Administrators.
Hello, I am someone who wants to do SQL I have an ACCA background and thinking this is something which is helpful can someone guide me on where to start in datacamp from sql and how it works?
Hey everyone,
I’m a student studying IT Infrastructure with a focus on systems, aiming for Systems Analyst or Application Support Analyst roles. I’m a beginner in SQL and currently deciding between LearnSQL.com and DataCamp to build my skills.
Which platform would be better for career growth? Should I use both? I’m also planning to learn Data Visualization (e.g., Power BI, Tableau) is DataCamp good for that too?
Any advice would be appreciated. Thanks!
How long did it take you guys to get the associate certificate for Sql on datacamp? I’ve just finished the joining data section, wanna get a grasp on time. I started about 4 months ago
Hi, I have some sql knowledge but due to my job now I have to run more complex queries so I wonder if there is any good tutorials or courses out there. In the past I did datacamp sql and it was ok but why so not have too much stuff around sql. Thanks
Hi guys,
I have been learning SQL on and off over the past few months and recently just completed a few courses including joins on DataCamp.
Once a course is completed, you are 'awarded' a certification of completion. Are these certs worth putting on your LinkedIn profile under 'Licenses & certifications' and resume when applying for jobs or is this essentially useless?
When applying for jobs, some online applications ask for linkedin profile url. Again, would these datacamp certs be worth placing on your linkedin and resume since it 'proves' that I know SQL joins as well as just general visibility for recruiters for example or should I just leave this off since it does not count for actual real world experience, etc.?
What has been your general experience with this? Graduated w/ a BS in Biology from a few years back and currently work a non-IT related job in healthcare right now but am looking to potentially transition into an analyst role and I live in/near a very large city in the USA by the way if that matters.
Thanks for any feedback/advice I can get on this, greatly appreciated in advance!!
I am in my 40s and I have never done any kind of tech work. Consider me a newborn baby in any kind of computer science field. Now I recognize that going forward, learning about AI and the digital space is going to be the best thing for me since I am in the process of changing careers. Is DataCamp, the ideal place to learn these brand spanking new tools and how would a certificate from them be advantageous? I hope this isn't a silly query but I need some feedback. Please help!
Would anyone recommend one platform over the other (money aside)? Open to hearing all experiences with either (or both!) platforms.
I will be starting my MSBA this Fall and wanted to spend the next few months building my programming skills. I wanted to know if a data camp subscription (costs $75/year on sale) is the best way to do this. I will be a beginner with very limited exposure.
Additionally, how do I practice the skills I’ve built. I’ve heard about kaggle data sets but I don’t know how I can use them.
Any other suggestions about resources or tips in general are welcome.
I’m in the middle of finishing Coursera Google Data Analytics course & would love to add another SQL-related course to supplement my learning. I feel that GDA is not is not in-depth enough to equip me in building a decent portfolio. For now I want to focus to get more in-depth skills on SQL. Which one is the most recommended platform between Coursera UC Davis SQL or DataCamp for its practicability? Any suggestions / thoughts would be much appreciated! - A little bit about my background: I’m on the self-taught path trying to break into Data Analytics. Currently on a career break while transitioning out from tech sales. Thanks!
Hi - I recently started to take a couple of SQL classes in Datacamp. I have used MSSQL, DB2, and postgreSQL through my career but mostly from an application support/implementation engineer point of view, simple queries, some joins and subqueries, inserts, etc. A fair bit of admin work also doing data migrations, backup/restores, SQLagent jobs in MSSQL.
But that is it, I am not familiar with stored procedures aside from specific instructions on how to run, scripting, etc.
I am curious what other folks think or what their experience has been with datacamp as far as a learning path. My goal in the end would be visual presentation, specifically gaining experience with Tableau.
I feel like I should gain a better understanding of SQL.
I completed the Introduction to SQL and Joining Data in SQL classes. Should I continue the SQL Fundamental skills track? Jump into the Data Analyst with SQL Server Career Track? Or go right for Tableau or Python?
Look forward to hearing some others' opinions and thanks in advance.
I enjoy it.
I'm switching between python and SQL with hopes of using them both when I learn enough.
I've learned more about sql than I ever would've and used my knowledge to solve some what I would call advanced queries.
Will follow this. I'm also currently using SQL for simple tasks as reports and process support however, I feel that there's a lot more more to do with this. Btw, this is my 1st yr using SQL, so you could say I'm totally new to this.
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 :/
Hey guys,
I started the SQL career track on DataCamp a few weeks ago, and found that I need more practice to actually understand how to use different functions. I looked at SQLzoo and a few others, but still think I could do with more practice.
Some people suggested working on real life data sets and developing project work to show to potential employers.
My questions might be really basic, but 1) how can you practice it? And 2) how do you show it to potential employers?
I don't fully understand how you develop a project with SQL. Do you download a data set from somewhere and an IDE and start playing around until you have a few different tables?
Once you have practiced, how do you show it to an employer. Do you export data from SQL into Excel and make visualisations to show them? Or would they just want to see the kinds of questions you ask and how you find solutions?
I realise these are probably REALLY basic questions, but my course has just been showing the different kinds of queries, and it forgot to mention where to use them and how to show off what you know.
Any help would be really appreciated!