Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Osaze Osoba
875 PointsDo I need the "Modifying Data with SQL" course as a growth marketer?
Do I need the "Modifying Data with SQL" course as a growth marketer? I'd mainly be using this for data analysis and generating reports.
Asking because I'm not sure if there's ever a need to actually modify the database information with this use case, I'd rather move on to the next course in the track if it's not needed
2 Answers
Stuart Wright
41,119 PointsI +1 the answer from Jeffrey - it's well worth knowing the basic ideas behind creating your own databases and modifying them even if it isn't going to be your main job responsibility. In my job as a data analyst I don't have to know how to do this, but the ability to create and maintain small* databases on my local machine has been a very useful skill for me.
*By 'small' I mean < 10GB, which I maybe shouldn't describe as small as it's still a pretty huge amount of data, but I just mean that it's a size that's manageable on my personal laptop without the need for a server.
Jeffrey James
2,636 PointsAgreed. I'd also suggest anyone take https://teamtreehouse.com/library/sql-window-functions (being able to assign arbitrary ranks and row numbers to anything) along with knowing CTE's is the apex of what most people will need to ever know, at least from a data analysis POV. So much of biz analytics revolves around first event analysis (row_number) or time until (lag()) and you really can't do any of it easily without window functions.
Osaze Osoba
875 PointsThanks for the tips guys. Decided to go ahead with learning modifications as well.
Jeffrey James
2,636 PointsJeffrey James
2,636 PointsIn the grand scheme of things it'll be worth knowing how to grab data and copy it into a postgres or mysql database from the command line. Lots of times in marketing, you'll need to integrate separate data sources. For instances, analytics data may need to be blended with your customer data, that resides in your production database. You may opt to extract data from prod and join with your marketing database, or just join flat files 100% of the time, etc....
I would not get hung up on whether to spend another 5 hours on anything. If there's a simple thing to learn, just start plowing through it.
Source: 10 yrs experience in digital marketing / seo / sem analytics and now mainly dealing with machine learning and python stuff (lots of SQL as well).