Best way to learn SQL for a noob?

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

Make a database of something that’s personally relevant and interesting to you. Sports, investments, anything you like and know well. This way you can learn not only the syntax of creating, updating, modifying, and querying databases but also the ways of thinking and reasoning behind best practices - it’s much easier to internalize when the data is personally meaningful enough that you would notice and care about inconsistencies, and you’d have an intuitive sense of what successful implementation should look like.

You can do this with google, MySQL workbench, and a bit of patience. It will take longer than a course, but you’ll learn a lot more and retain it much better.

likeuplifting

Kahn Academy's SQL course is fantastic.

https://www.khanacademy.org/computing/computer-programming/sql

like

Thank you - going through it as we speak :)

Alix Partners entry level VP again..

likefunny

Ey 1 doesn't get the joke 😳

like

You can get a very entry level walkthrough that's interactive on https://www.w3schools.com/sql/default.asp

For more advanced stuff check udemy, pluralsight or YouTube

Gradient. YouTube. Outsourcing.

i thought the codecademy course was pretty good. that was years ago and i’ve since forgotten almost all of it, but it was solid at the time

';-- drop table users; is pretty much all you need to know

Related Posts

Hi- H1B folks Has anyone got the stamping done recently in New Delhi through Dropbox?What is the time frame to receive the passport back? Any challenges you are hearing with recent lockdowns in Delhi?

like

Friday night check - in! How’s everyone feeling? I have another couple hours of work then I will get in a workout + wine to unwind, then see what’s on Netflix. Bummed that my online orders didn’t make it by end of business week to cheer me up!

like

I think Maisie Williams just drove straight through a stop sign.

likefunny

I have got an offer from juniper for notice period of 2 months but my company notice period is 3 months. Initially HR confirmed via mail that revised offer letter will be shared post confirming doj. But now after 1 month juniper HR is not picking call/not responding to emails.
Can they revoke the offer?

like

Well, I had very different plans for my 4/20... Any other agencies doing layoffs?

likehelpfulsmart

I am looking for job opportunity in Finance, can someone help

like

I joined Capgemini Engineering on 21 September 2021, when will i be considered for appraisal?

like

How do you build trust with your company's employees that you are there as a resource for them, and not just to protect the company? Especially in this remote environment.

like
like

Any difference between Tax Consultant I and II at Deloitte ?

like

Graduating from law school in May. What skills or knowledge should I focus on acquiring that might help me secure employment in a recession? CLEs on bankruptcy and creditors' rights?

like

Hi, what are the hierarchies in data and analytics side? How many steps above Data architect role?
Is the data architect role right for 11 years of exp?
What is salary range for this position?

like

Is moving from industry into climate consulting worth it to be in a job I’m interested and passionate about?

like

Brillio does he take time to share feedback?

Has anyone been to Iceland recently and hiked to see the active fagradalsfjall volcano? Would you recommend doing a tour or is it pretty easy/low risk to do on your own?

likeuplifting

Is there still a KIK group of consulting gays?

like

Tips for getting out of a quarantine-induced funk? It’s been a tough week...and it’s only Monday

like

I don’t need to be recognized for my work. You can either give me props or you don’t have to. But recognizing someone else for my work sets me on fire🔥. Is there a term for this? I need tools to help me calm down in these situations. I have the same reaction for other people and their work.

like

FL fish - any insight on Hill Ward Henderson culture? Specifically the construction & design group?

like

Anyone here misdiagnosed with PCOS? My doctor concluded from my high DHEA-S levels that I have PCOS, however, I have 0 insulin resistance and my overall report for diabetes and thyroid looked great. Please note, my blood sample for DHEA-S was drawn while I was menstruating.

like

Additional Posts in Consulting

Anyone leaving early tomorrow to get to Passover Sedar on time? Have your clients/teammates been respectful?

like

Going to bed and not doing Halloween. Adulthood is so exciting 🤗👵🏻🤓

like

To the dramatic guy who is on the phone to the diamond line threatening to sleep on the floor of SLC because you can't get to your final destination tonight -don't be such a dick to those who can help

like

McKinsey & Company Is there a team within McKinsey & Company that has good WLB? Hear they’re on a hiring spree but don’t want to jump to a team that perpetually works 60 hours. I’m interested in BizOps, Strategy, Project Management and Digital.

like

Anyone here have experience, or have any knowledge about, working at an internal strategy team at a Big Law firm? Interested in making a switch into strategy, but unsure if working at law firm is the correct move. Thanks!

like

Book recommendations on genetics and bio hacking?

like

I need EY CPE credit before year end. Does anyone know of easy CPEs or ones that do not have a test?

like

I hate my current project... It's turned into a dead end role months from completion. My RP is good friends with the Director, and my group is relatively small. I feel pretty trapped 😔

like

Anyone like trump?

like

Wonder what the new name will be for Facebook. Might not be able to call the FAANG anymore, might end up being BAANG....

funnylike

Aside from the obvious Vegas or Miami, where are the best places to go for my bachelor party in the next 2 months? Not sure where's a good place to travel with covid restrictions and travel bans still active in many places.

like

Best SPG/Marriott hotels in downtown NYC? Thoughts on 11 Howard?

like

Any PwC 🐟 from Zürich willing to connect?

like

How do you figure out who your spirit animal is?

likefunny

Best men's watch brands less than $500?

like

Those who made it to Deloitte mid-career (exp hire), how did you do it?

likefunny

Any suggestions on best restaurants for a Rostov evening with wife on/near time square?

like

Someone I worked a couple projects and had little respect for is now at McK. I now have less respect for their "prestige".

funnylike

July 4th, 1776. The original Brexit

like

Where are my fellow straight consultants playing with men while traveling? ;)

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
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

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal