{ "media_type": "text", "post_content": "Best way to learn how to read and debug SQL? I understand the basics but project is requiring more", "post_id": "5e461cbef0e46a002903c1b9", "reply_count": 4, "vote_count": 1, "bowl_id": "5ace5097be6e660013abcc42", "bowl_name": "Data & Analytics Consultants" }

Best way to learn how to read and debug SQL? I understand the basics but project is requiring more

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

Break the query down into smaller chunks for testing. Store intermediate tables as views. You can build up to the full query if you know the view works. Test the query with a subset of the table if it’s slow. Explain statements can be useful for figuring out what the query will do. Read the error messages. Stack overflow is your friend. If it is a really complicated query query building tools can be helpful.

likehelpful

Google...google everything

like

Use the the print query to test the results. Temporary tables to pull out small chunks of data.

like

https://www.w3schools.com/sql/default.asp Hope that helps

Related Posts

Anyone deal with a client stakeholder that keeps trying to derail or sidetrack the project? I am leaning toward that the person is incompetent on the project topic and has something to prove.

like

Need a freelance React Developer for a project.

like

When calling American to ask for points what are you telling them ? My flight was delayed due to a lightbulb change which means I missed my connector and my client dinner Never had to claim points

like

Hello All, hope you are doing great. I am working with TCS, but due to salary in peanuts, I need to change my job. Any leads/references would be much needed and appreciated. My Profile: Scrum Master, Agile Coach, Project Manager. Thanks

like

How long is your one way trip from home to client site? I’m at 5 hours- 3.5 flying, the rest driving to/from airports.

like

I love my new client side job. But the west coast based team is not considerate of my time zone. I’ve been here four weeks with no improvement despite being vocal about it (within reason). My manager works non stop so I am sympathetic to that. But it often means I go days without seeing my young kids after school. Any suggestions?

like

Hi bowl, I'm not okay today. I woke up feeling off, then my project told us that my workstream is ending this coming Friday. I feel like an after thought, I feel so anxious and so tired. I know I should eat today but I just want to lay down in bed and disappear. I'm sorry for this post, I just needed to write this and cry as I do it.

like

What agencies in Canada have Sephora or any other beauty brands as a client? I know McCann has L’Oréal, but it’s mainly their French wing. Really want to pursue an opportunity to work on a beauty brand at some point. Thanks!

like

Bain & Company anyone heard about the Macro Trends Group? Any insights on client interaction, pay, wlb etc?

like

A bunch of friends and I have a potential real estate project in Mexico but one wants to obtain funding through crypto. We have financial and legal backgrounds but not much experience regarding crypto. Is it feasible to create a cryptocurrency to obtain this funding and if so, based on experience, how hard is it to promote / get the crypto rolling?

likefunny

What is ZS equivalent on Axtria Project Leader?( MBA tier 2 + 4 years experience)

like

Hi interested if anyone has personal feedback/insight into "Baker Tilly (US)"? I have an opportunity lined up to interview with a Risk Advisory Partner for a lateral move (and faster promotion to Senior) and it seems their internal employee culture is good on paper. But I'm wanting to see if others have IRL experience with them? My main focuses that I'd like more info on are: Office/Team Culture, Client Management expectations, and Senior/Staff Support

likefunny

H1b 🐠 : when you guys get a new client engagement to a diff. Location how long does it take for you to be in the location physically ? As in no. Of days till ur docs. come through ?

like

Freelancer here. I typically charge by the hour. Picking up a side project that's a 360 campaign. Quick turnaround. How do you convert your hourly rate to a project rate?

like

Has anyone started traveling yet? Client’s city has not had an outbreak and I’m slated to travel soon. I’m fairly nervous and refuse to fly so looking at driving 5-6 hours. I also have a young kid and my husband works lengthy hours so I’m pretty apprehensive but don’t feel like I’m at liberty to decline travel.

like

West coast 🐠 with East Coast/Midwest projects do you regularly take a red eye (client site by 9) or earliest flight after 6 am (on site by 3) or lose part of your day Sunday to fly in day before?

like

About to start traveling again after a year and a half local. Based in Chicago, only have Gold on American but MVP Gold 75k with Alaska. Can take UA, AA, or SW to new client in PHL (cont'd)

like

Any tips on how to roll off a project that you’re not fully engaged in without offending the senior managers on the project?

like

My project keeps getting pushed back week at a time so my utilization has been suffering for last 2 months... I'll probably get dinged for it at year end review. And its supposed to be my promo yr FML

like

Any thoughts and ideas on how to break into Microsoft (non-federal practices) Profile in product development, project management, analytics and business intelligence in financial services plus MBA Microsoft

like

Additional Posts

Any insight on kpmg’s FDD practice? Specifically the healthcare or core industries.

like

Domestic flyer with status on AA and United. What is the best way to book an int’l flight on an airline like British A? Can I just use my AA # and get the perks and points or do I need to get a BA #?

Do you guys feel like it’s a good time to be a Black woman professionally? I feel like if I wanted to raise money for my idea, now is the time. Im scared to miss this moment but I’m not ready.

like

For those of you who have worked at both KPMG and EY consulting/advisory how do benefits compare? Specifically: cell phone allowance, allowance for meals while traveling, and alternative travel policy

like

Need some advice, I’m a third year healthcare/corp/M&A associate in Texas from a small firm. Was let go today because of recent hires and not enough billable work. Feel like I should try everything possible to secure another job and still a bit shocked. So if anyone in this bowl has any leads, please let me k ow! TIA!

like

I just got a 4% raise. Doesn’t feel great since I expected more and am considering looking for a new job. Am I being over dramatic?

like

Manchester Consulting compensation transparency thread: Title Company Base Salary Bonus + Benefits YoE

Thoughts on Ops Strategy and Analytics role as an exit from consulting? Anyone moved to a similar role in industry?

like

Looking to burn Marriott points and air miles? Thoroughly recommend the JW on Isla Della Rosa - Venice....

like

Note to partners: no. We NEVER need a zoom meeting at 8am.

likefunnyuplifting

When can you ask what the salary is during the interview process. I’d need a bump to jump & don’t want to waste anyone’s time. Glassdoor has very wide range.

like

Still on my parents insurance plan - can I set up an HSA and max it out? Currently max my 401k and Roth IRA. Is it through the ibm portal or can I just set up fidelity

like

What do Managers in HK make? (Post top 15 MBA if that matters).

like

It makes me sick whenever I hear the heads of nonprofit organizations are called CEOs.

likefunny

I have a offer from CGI 17.5 Lakh fixed and 50 k joining bonus North America shift. I have another offer from wipro-18 lakh of which 15.3 fixed Singapore shift. Both are project manager role. What will be my take home in wipro. Which is a safer bet for a lady employee.

Post Photo
like

Looking to vacation next summer in Greece and Italy with the fam. When you all book on bonvoy points do you reserve the room just for yourself or do put the actual number of people? When I search for just 2 people staying the room, there is availability to use bonvoy points. When I search for 3 people(6y/o kid) nothing is available. The same in Athens, Rome & Naples.

like

Starting a new job on January 3. Want to leave on good terms in case I want to boomerang down the road. Is it a bad move to put in my 2 weeks on December 17, right before my whole project team disconnects? Or should I at least give them a heads up before I put in 2 weeks? Do I need to tell my practice leaders/PPMDs in advance? I’m a SC fyi. Thanks fam! First time doing this.

like

Do you all ever have guilt calling in a sick day? I have a pretty bad cold and 5 months pregnant. I’m just so slow today and want to nap. Working from home

like

Is something like this alright for an office holiday party? Or too formal? (I have a similar cheaper/vintage dress that's a bit more pencil than a-line and midi length)

Post Photo
likefunny

Trying to get a 45 y/o sibling in to consulting (was an entrepreneur prior in the restaurant industry). No college degree but willing to bust his butt to learn. Books/online courses recommended pls

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