Related Posts
Is a SCRUM master cert worth it?
Anonymous User
Bowl Leader
Bowl Leader
Bowl Leader
Additional Posts in Data & Analytics Consultants
Mentor
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
It’s kinda hard to be in data & analytics with no SQL experience. Cram and embrace the opp.
Lol I was going to say the same thing.. thousands of people in this job market are wishing they could learn SQL on the job instead of doing dumb certificates online that don't inspire any confidence about your experience. Look up all the cheat sheets and YouTube videos online. You'll figure it out!
Bro your fine.
Select * from, and look up SQL cheat sheet. You got everything you need now. SQL is English.
What this person said. Made it this far from doing this and still going strong
Drop table employees;
Brutal
sql is not hard.
1/Learn the structure of a query.
2/learn the function of aggregates, logical, and filter statements
3/learn the different types of joins and how joins work
4/learn about concatenation and making your o nw keys u can use for joins
5/learn about data validation and reconciliation
6/go on leet code or data camp to practice
7/ after some practice start learning more advance concepts like CTEs, Window Functions
8/keep practicing
Outsource it to me
Depends on the ask, if it’s as simple as select * from x where y=number, you’ll be fine.
Feel free to DM
It’s pretty easy to pickup, I’d use this as an opportunity to add this to your skillset.
You can pick up everything and more in a week or two. Start with SQL For Dummies, you'll be fine.
I second SQL for Dummies! It takes you from the basics to intermediate techniques while being entertaining with a touch of humor. Super easy read. I still have my copy from like 30 years ago. Yes, partners still use SQL occasionally.
Depends, are you doing analyses or building pipelines?
Analysis in SQL is a skill that can be learned in a weekend. Figure out what data you need, pull it, dump into excel, and analyze.
Building pipelines? You’re cooked
dude i’m over here with data engineering experience, coding, scripting experience and can’t even get on that.
Why not just start with ChatGPT and take it from there?
It's never been easier
I’ll switch
Start with HackerRank exercises. And, BeardedDev videos on YouTube for more advanced stuff. You will be fine.
Just need to apply yourself for a week.
Pipelining requires a bit of a strategic mindset. Determine what steps you want to include within the pipeline.
For most purposes, a combination of GO, CREATE TABLE, INSERT INTO, DROP, UPDATE, and ALTER will take you places. Parameters, looping etc aren’t too critical.
Alternatively, if you know Python or KNIME, you could just use one of these tools. KNIME is low/no code and open-source.
Mentor
Have you ever coded before, or done other query languages in JIRA or even a reporting tool like Power BI? You have the baseline logic if so
Basic SQL is a cakewalk. If you are having to optimize or use window functions or build recursive CTE, you might be cooked.
Mentor
window functions and trying to migrate that SQL code to Pyspark is still one of my least favorite tasks I've ever done 😵💫
I’m in the same boat. Stuck with SQL in my new role after switching from Consulting experience. But just taking it up as a challenge to add a new skill which is quite handy in data analytics.
If I still don’t like it in a couple years then I’ll jump ship.