Best way to learn SQL for the non-techie but strong and motivated learner?

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

Select *
From tablename
Where criteriastatement

Covers a surprisingly large number of use cases. Learn to riff on this for more complex queries, environments, and systems, tailoring what you need in the select, adding joins, sorts, etc.

likehelpful

Get access to a development environment to run a query in your company's database. Tech people are extremely helpful I've found if you show interest in learning. It will be easier to understand SQL if you run it against data you know.

Print going down:

Select
From x
Join y on x.something = y.something
Where
Group by
Having

Decide which things you want from the list.

Select means what columns you want to see

From is the table you are starting from and will move out from.

Join you'll need to look at some Venn diagrams to understand the different types but this is where you connect table x to y through some agreed up connect (lookup primary and foreign keys to learn more).

Where is your Excel filter. Remove out and only see specific information.

Group by is your pivot table in Excel.

Having is once you pivot table you want to filter some more. You can't use having unless you use group by. In most cases you'll use where instead.

Happy learning!

likeupliftinghelpful

My pleasure. If you need further advice feel free to DM me.

You can learn how to do simple SQLlite queries on Khan academy for free.

like

Just learned SQL from very little prior experience in 1 week for two technical interviews - used Udemy, and HackerRank

like

Theory: Select, From, Where, Left Join, Inner Join, Group By
Practice: Hackerrank or so
Rest: Google

Tbh you can learn to code 90% of all usecases in 1 week

like

LinkedIn Learning has some great courses on SQL and also challenges that you can do as hands on

W3Schools is the place to go

Follow it up with problems on database through leetcode

Related Posts

Hi Guys,

I have 11 years if IT expe

I'm currently serving notice period. Last working fate is September 2nd week. Hardly one and half months left. Worse thing is I do not hold any offer yet.

Thinking of transforming my career to Devops line , I dropped my paper. I started learning and doing hands ons on devops

But I'm little afraid how to get placed in devops role. Will they recruit me ? Or will they expect genuine experience in devops line.

Kindly provide your suggestions and help.on this.

like

Outside of the M7, which programs have strong investment banking pipelines?

like

How have you gone about transitioning from one agency to another? (Quick start, no gap).

like

Best advice for successful exit from consulting to a high growth startup?

like

Got an offer from Netwest . Grade B7.2 , Fixed CTC offered 20 lacs , , department product control . Could you please let me know what that B7.2 means & how much time it will take to reach to AVP level .

like

I’m confused by the CFP education requirement. Do I need to complete other designations before I can sit for the CFP exam? Such as CLU and ChFC?

like

I have 4.5 yrs of work ex and joining as ACON at KPMG. Will I get promoted to CON in next cycle i.e October 2023 or so I have to wait until October 2024?

like

Devops-Platform engineer looking to get into GCP data engineering. Where do i start? Currently looking the GCP professional data associate certificate courses.

like

How did you guys know you wanted to stay in HR?

like

This might be a long shot but I'm looking for a volunteer who is trying to break into a federal career. Maybe a transitioning veteran, recent grad, or career-changer.

I'm pursuing my master career coaching cert and need to do a recorded 45-minute session. You don't have to be identified if you don't want to.

The single session is all I'm asking but could certainly turn into a longer lasting coaching relationship (at no cost), if you like.

like

I currently work in Private (GA) Aviation & have for some time (about 12 years) I’m currently making the switch to the Department of Aviation and am unsure if I should ditch my current job (in private) and go full force with the DOA & embrace this new opportunity educationally and gather as much experience as I can or keep both jobs even though I’d be working 80hr weeks.. I love the private world but am really ready to move up. I don’t know what I should do. Any suggestions?

like

I have an offer from L.E.K. Consulting should I accept? I’m a Manager in the UK with 10YOE. Things that matter to me: faster progression, learning from partners, f2f teaming culture, senior women role model

like

Hi guys, I have a bachelors in management from Pace U and have 5 years in auto sales experience, any suggestions on where i should start if i wanted to switch over to tech sales, what the starting positions to looks into, and how to break the barrier? TIA!

like

How do you actually transition from CE into tech smoothly.

like

What inspired you to pursue a career in your particular field?

like

Hi everyone! I had a question—I’ve noticed lately that a lot of roles are requiring Figma skill sets as a general graphic designer etc.

Any tips on what courses are best for learning this program and potentially getting some certification in it? I’d like to explore it more but don’t really know where to begin

Thanks!

like

How useful is financial due diligence experience for PE recruiting? I have about a year FDD and a year in M&A IB mid market. I’m planning on making associate in banking first but wondering if that year extra gives me any brownie points for MM fund recruiting down the road

It’s Friday night at midnight and I just got out of work. I am new to FPP defense. So far it’s soul crushing. I feel like a robot just doing the same pattern pleadings and discovery over and over. If I try to be creative or ask questions I get the response that I should not recreate the wheel… basically just cut and paste. My brain feels like it’s going to rot doing this work. Does it get better or do I need to plan my exit to a different field ASAP?

like

Hello everyone!

I graduated from uni last year with a Latin American studies major and Comp Sci minor. I have been working as an administrative assistant all this time but I decided it’s time for a career change. I am interested either in marketing or front end development. Any tips on where to start? Any other career ideas with my current background?

like

Interested in a manager position at Altman but want to stay in the DC area. Would that be possible?

More Posts

Honest question for any KFC folks - are all these colonels building up to some multi-year “there’s no substitute for the original” campaign? If not, why?

like

Is there a way to verify an email address without sending emails? I need to verify A TON of emails, but don’t need to actually send them emails myself.

like

New to this so any guidance is appreciated. Currently have my Roth 401k, Roth IRA, and HSA all through fidelity. 401k is invested my target retirement year fund. Both ira and hsa are fully in FXAIX, Fidelity’s 500 index fund. Is this fine? Obviously I know investing and saving is good but still learning the ins and outs

like
like

What is recurring incentive in TCS? When is it given and how much is the amount ?

likefunny

I’ve been with my company for 5 years and have never asked for a raise, I’ve accepted annual review we get without question. I’ve now realised I’m getting paid significantly less than the market rate. I’m getting job offers with almost 40% increase. I know my male peers at my company get paid significantly more than me. I love my job and my company but I don’t know how to ask for a raise 🙈 I know I deserve it but don’t know how to ask! Any guidance please ?

like

People at my company claim to be supportive, promote great work culture but there’s actually no support at all just bunch of bs. I am in a situation where im not getting the support from my supervisors, BDs and everyone is fake all the time. I am genuinely putting in the work and not getting the benefits I deserve. What are some good companies to work for in Marketing/advertising in Toronto? Or how would u go about addressing stuff like this ?

like
like

I have this partner who doesn’t enjoy working with me because I do below avg work for her but she has little choice of foot soldiers. I do below avg work for her because she consistently gives me little time to do huge tasks (and usually at odd hours) and doesn’t involve me in what finally goes to the client (and I have no visibility on the client’s expectations, response, feedback, expected timeline). How do we (mainly I) get out of this painful cycle?

likesmart

I am looking for a Java developer for Globant.
Experience should be 6++

Primary Skills - Java8 or above, Spring, Spring Boot, ORM
Secondary(Good to have) - JUnit , Docker , Kubernetes, CICD, MySQL
Location - Pune
Notice period - less than 30 days

like

My peers are not getting as much work as me. I pride myself on being a hard worker and a team player, but it’s getting out of hand. I have been working 80+ billable hours the past month+

likefunny

I joined wipro 1 week back , want to resign now. should I absord or serve the NP

like

Creative 1: “What’s that smell?”

Creative 2: “Oh, I think it’s me. I went to the bar for like 2 hours at lunch. I’ll just light a candle."

likefunny

“I love when young creatives like you come in here raw and just start doing it.”

funnylike

As a new joiner.. is micromanaging the culture at all Big four firms ? Or does it depend on what service line your in?

like

Hey!! I am looking for a job Change, I have 9 years of experience in EDI/B2B integration and worked on multiple tools like TIBCO, Dell Boomi. Are there any job opportunities, Need referral.

like

Have an interview with Google in their IT Audit department? How are the odds for exit opportunities into other areas of the business (i.e, security, product)?

like

Anyone with more than a year in FDD regret leaving audit? Feeling a bit nostalgic for some reason this morning

like

Hey guys, Can anybody tell me how much time does it takes the location to be updated in Accenture. Its already been 3 weeks, and the Hr has no update regarding the same.

How is Arthur D. Little in the region? In the process of an offer. Any fish keen for a quick message chat? Thanks!

like

Additional Posts in Startups and Entrepreneurship

How do you go about building a marketplace with great search function? Any resources I can leverage? Also, what payments software options are there for collecting payments with minimal fees?

like

When starting your LLC did you use a third party registered agent or did you just list yourself?

like

Anyone have any best practices for connecting to online journalists about your business? Any tips or tricks to share? :)

like

Anyone knowledgeable in Amazon sponsored ads willing to talk?

like

Hi all! I am looking for clients. I create Matterport virtual tours. Allow people to be visit and experience your space from anywhere at anytime!

like

What’s a reasonable percentage to give away to an investor in the early stage of your business where you have not generated revenue? How is the percentage determined?

like

Anyone have attorneys working for their startup in non attorney roles. If so what positions should I be looking at. Not enjoying the practice of law but also have no experience with startups. Would I need to learn to code to get a job in say project management?

like

Is there anybody out there that can help someone out with obtaining a real estate license?

like

Anyone here work at a16z? I'm interviewing tomorrow and would love some tips to ace the process. Thank you!

I need some help understanding how Estonian e-residency company would work if the operations are based in India. How would the tax part work?

like

What is the best way to find a mentor for your personal ambitions and financial/investing goals?

To clarify, I graduated college in August, I just started my full time job, and I own/operate a business I started in my Junior year of college. I am eager to work with someone that can guide me when it comes to growing my income(both short and long-term) as a full-time employee, entrepreneur and aspiring real estate investor.
I understand this may be too vague, but any tips/insight is appreciated

like

Can anyone recommend good books or articles on startup org charts and hiring? Think we’ve hit early signs of product/market fit, but not sure who to hire next, in what order, and how the org should evolve over next few years.

like
like

I'm wanting to transition into innovation and strategy function. I come from non IT background i.e. HR and Business transformation. Is there a way I could learn hands-on perhaps shadow or give in few hours to support someone in the role already and requires a helping hand for free in exchange of knowledge sharing? Perhaps someone who is on these projects and need some helping hand
Would love to hear from anyone of you who can extend any ideas, advice and/support is greatly appreciated.

like

I want to start my business with an LLC and then a few months later add another partner. How should I go about this? Assume then I would need an operating agreement?

like