Related Posts
I recently graduated from law school and have started my clerkship in the superior court of NJ. Once done with my clerkship, I’m hoping to work in employment law (defense). I’ve seen online that Jackson Lewis is hiring at their Berkeley Heights, NJ location. Can anyone give me any insight on what it’s like to work at JL? culture? First year associate salary? Typical work day? Jackson Lewis P.C.
More Posts
My mind every time I meet new clients

Back to your regularly scheduled programming

Additional Posts in Data and Analytics in Advertising & Marketing
Best resource to learn SQL?
New to Fishbowl?
unlock all discussions on Fishbowl.






First find out WHAT they use it for and then learn that. Most times you are just pulling data and that’s quite simple to learn. If you take a SQL course you might end up learning a more academic view of SQL’s role in database management and that’s the purview of a data engineer.
This is so helpful!
I had to do the same thing recently. I went to Udemy and took the SQL boot camp!
Datacamp
Khan Academy was where I started. Great for free learning. Once I realized that I wanted to take the next step with SQL and data analytics I moved on to taking the full Google Data Analytics certificate course on Coursera
try out sqlzoo.net for the basics. its free and the little chapters/exercises are really helpful. from there if you want to do more, try youtube tutorials or a datacamo
Coursera
I think that Datacamp's program is the best around. Here's a pro tip I heard: try a free course, let it linger after not proceeding onto the paid portion, and DataCamp will send you an email with a % off coupon. Otherwise, there is usually a sale around the holidays.
Just go to w3schools.org and do their free online sessions. Learn select, joins, sub query, case, etc… and it’ll be all you need for 90% of positions.
Learn sub query and CTE. Find out the difference and why some might prefer CTEs
I’ve found it most helpful to start from a problem you’re trying to solve or question you’re trying to answer and then seeing how to get there using a given tool (SQL in this case).
Anything else becomes too abstract to be helpful and I lose any new knowledge due to lack of use.
Coursera or Udemy are both great. Agree with the first couple of comments, but sometimes you just want the cert.
Try a junior college, they might have it online and with the syllabus you can go through the course at your pace. If you are an in state resident it might be far cheaper (maybe even more credible? don’t quote me, do your due diligence) than other online offerings.
Danny ma’s serious sql course.
For most interviews, you’ll need to know the basics (basics ends at the difference between WHERE and HAVING), CASE WHEN, and PARTITION BY.
Kind of shocked this is an acquiescent relenting... This is a fairly easy skill to learn the basics on that is valuable enough on a resume to be able to speak to for any analytics professional.
Why were you holding out for so long?
CodeAcademy has as good SQL starter course: https://www.codecademy.com/catalog/language/sql