{ "media_type": "text", "post_content": "Suggestions on an effective certification course for learning SQL? I’ve taken courses in undergrad but was looking to bolster my skills. Feel a bit overwhelmed in terms of what resource (Courseera, LinkedIn Learning, etc.) would be effective for teaching skills for querying on the job.", "post_id": "5eea422712bfd50022dd848a", "reply_count": 3, "vote_count": 1, "bowl_id": "5ace5097be6e660013abcc42", "bowl_name": "Data & Analytics Consultants" }

Suggestions on an effective certification course for learning SQL? I’ve taken courses in undergrad but was looking to bolster my skills. Feel a bit overwhelmed in terms of what resource (Courseera, LinkedIn Learning, etc.) would be effective for teaching skills for querying on the job.

like
Posting as :
works at
You are currently posting as works at

Advanced SQL for Data Scientists on LinkedIn has enough for most of what you'll write. It's only a few hours long. Querying isn't a complicated process, it's knowing what to query that gets you. Supplement with a programming SQL variant so you can do fancier ETL design, like when there are overlapping hierarchies in the data or something. Tons on YouTube for this, specific to the language. Also add a short course in SQL optimization, so you learn about indexing, partitions, and materialized views. Then practice practice practice. None of the new syntax you learn will stick until your next interview unless you keep using it.

likehelpful

Thank you really appreciate the advice!

Related Posts

Amazon FLDP vs Gartner Consulting (post-MBA level). I am worried taking Amazon will close the door for consulting in the future. Amazon comp - 130k base + 80k sign-on bonus (~45k first year, ~35k second year) + 100k RSU (4 year vest). Gartner - 125k base + 15K EOY Bonus + 10k sign-on bonus. Do I pass on my hopes for consulting and chase the money?

like

MD or MBA? I got into both. I know most will say choose the MD, but hear me out: MD: I'd have to go into a specialty to have a good IRR given my salary & the $200K+ debt. By the time I'd be done with residency the US may be in a single payer system. US doctors make 3x the amount in France and 2x vs UK.. I currently make what a doctor makes in France. That could be the future here, too. MBA: 1 yr. Europe. I'd make about 15-20% more vs. now.

likefunny

Better to be a big fish in a small pond or a little fish in a big pond for MBA apps (I.e. superstar at B4 or mediocre/below average at MBB; metaphorically speaking ofc, ik the B4 is technically bigger in terms of size but you understand the point in terms of competitiveness)?

like

Can somebody please explain to me why MBB and other top consulting firms are so adamant that you have an MBA? I majored in accounting, finance, and operations management at a top 10 undergrad business school and then got my masters in information systems from the grad school program. I took multiple MBA courses as electives when getting my masters and it seemed like those classes were very basic and easy. Idk if I would learn anything in an MBA program that I hadn’t already learned in undergrad

like

Anyone took workday certification courses remotely? Does anyone have the link to the course books used during certification?

like

A-game questions to ask a principal in a quick coffee chat? Recruiting for MBA summer internship.

like

Is getting an MBA beneficial in consulting? 2 yr of consulting experience and thinking of getting an MBA.

like

Comp question - what should a B4 Senior with a CPA, CFF, CFE, and a MBA with 4 years forensic exp (D&T) and 6+ years non-forensic exp (industry) in NYC and DC markets expect in this current climate?

like

Anyone successfully clear any Oracle EPM certification? Did you use any data dumps? How was your experience? Given that it’s mandatory now at D, trying to see how I can clear an exam when I’m not working hands on, in any epm tool development.

like

How much of a value-add are Exec MBAs? I've not come across many of them. Been in IB for 9 years (no MBA) and wonder if it's something I do around the time I try to move up?

like

First year SC at the D federal in enterprise ops - base salary is 90k with MBA, am I getting screwed on comp? I feel like I am.

like

Do you guys think ZS Associates has better growth potential or Capgemini Invent (this includes possibly getting an MBA later down the line)?

like

Best books about product management for a good exit to industry? I already have an MBA and PMP but looking for a refreshed perspective since it’s been years since my formal education. Currently reading “Product Managements Sacred Seven” but it’s geared toward the startup world. I am in healthcare and not looking for a startup role. TIA!!!

like

What is the best certification to pursue in this area? Looking at SHRM-CP but want to learn more about others.

likehelpful

Hi, i am currently working in sales profile in one of the leading company. I want to change my profile to SAP FICO .As i have done my MBA in finance i though to go for sap.i need some suggestions...

like

Is it worth it to get a professional certification like SHRM/PHR? Not many of my colleagues have one and it’s not a requirement for my role, but I’m curious if it’s worth it in the long run

like

Hi All, I'm 5+ experienced in IBM DataPower, secondary skills include working on WAS, MQ, Jboss, Tomcat - shell scripting to automate basic stuff. Holds certification in AWS Cloud Practitioner. Knowledge of DevOps tools like Jenkins, Ansible, Docker, GIT, SonarQube. Please let me know of any opportunities

like

Reposted in Compensation. What roles can I look at doing in Tech for a Manager in Cyber with 4 YOE in consulting + 1? Have CISSP as well and degree in CompSci if that matters. Also estimated TC for position. Though I’ve been “fast tracked” the grind of it with minimal pay is frustrating and debating if I can get higher TC have a relative or better title and enjoy a better WLB. Thanks in advance 🐠

like

Career question. I want to eventually get to be Director or VP Strategy at a F500, and most of these roles say they require a M7 MBA. I currently have 3 YOE and have the opportunity to exit at the manager level in strategy. Will not having a MBA gate keep these senior levels from me?

like

If I stay at EY until Senior Manager, will I have trouble becoming a director or VP at a F100 company without an MBA? Do you really need an MBA from a top school (MBA in general) to have high level positions in industry?

like

Additional Posts

What are the requirements for Marriott’s new lifetime platinum premiere status? Thought had it with 998 total nights and 15 years of platinum but app shows as ‘regular’ lifetime platinum elite

like

Hi, Can anyone help me with details of the health insurance premium in cG?

like

Please help. I was laid off this past week. I am international and my OPT is coming to an end very soon. I had a call with an immigration lawyer and Deloitte unfortunately does not offers additional support for immigrants aside from said call. I am in need of a job ASAP. I have until July 24th to find a job or I will have to start a new educational program or leave the US. Leaving the US is personally not a viable option. Skills: AWS Solutions Architect Associate Certified, Power BI (cont.)

like

Does your resume bullet points matter at all if you just have public accounting experience. Like if you say you are tax in Big 4 and you do Federal does anything else really matter to employers?

like

What can be maximum salary of scrum master in India?

like
like

How’s FAANG (Facebook, Amazon, apple, Netflix and Google) presentation in the region? And if they are present how’s the WLB and reputation?

like
like

How much do Accenture first year consultants make? Assume a 2 YOE out of undergrad. Would you stay at KPMG or leave for Accenture if Accenture was giving close to a 30% raise?

like

I am 10 days into my H1B grace period with no leads. Are there any suggestions for next steps?

like

Do you think with Delta+ on the way agencies who have mandated RTO will send people home again?

like

Lost retainer beginning of pandemic and haven’t been able to get replacement (Covid/Moving Out of State/ Other Priorities). Top teeth have shifted back to some extent, bottom teeth have built in retainer so haven’t moved. Back at parents home now and want to fix this mistake, what are realistic expectations? Full Invisalign program ~ 2-3k, Orthodontist to give me some break since we’ve already paid X thousand, some middle ground? Just want to try and be prepared on fair expectations.

like

As a male mid-level/senior associate, can you take the full parental leave (10-14 weeks) and come out without impact on partnership prospects? What are questions I should be asking to get at this issue before accepting a lateral offer? Quiz recent junior partners with kids? Seems a bit aggressive but may be necessary.

like

How much are y’all making? How has remote work factored into that? I’ll go first. 63k in Richmond, VA.

like

What fare class is economy comfort plus on Delta? What’s the upgrade priority logic?

like

I've asked this in the general bowl several times without response, so perhaps I'll get an answer here. When recruiting, did you know you were going to an AC? What is your background? Were you applying to core roles at other firms?

like

Anyone at West Monroe willing to chat? Applying to the experienced consultant position for healthcare.

like

WLB at FAANG companies? I've heard it can be bad, especially at FB, but mostly from engineers that aren't used to >40 hrs a week. Any insights?

like

I received an offer from another agency (Agency B) that's a 15% pay bump, but I am happy at my current agency (Agency A). I have asked Agency A for a raise to match that (not mentioning I had another offer) but it will take them a few weeks to come back to me, and Agency B are wanting a response soon... What do I do? Do I go for the money? Do I tell my boss I have another offer on the table?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the Fishbowl app

Get realtime notifications and see
what's happening in your industry
from the palm of your hand.

For account settings, visit Fishbowl on Desktop Browser or

General

Legal