Best way to learn mySQL in a week?

Are you supposed to already know it or is it an advantage? If the first why did you lie on the application?

Select * from 'Job Interview' where 'LSUlunatic' equals 'not fricked'

Results Returned:
Zero

I'm very good with Excel and have a working knowledge of SQL (have completed several online tutorials in the past) just never used it in a professional setting. Looking to get past the basics for this case study.

Good website:

LINK


also book recommendation:

quote:

---

SELECT A.*
FROM MoneyTalk.TigerDroppings AS A
JOIN List.Totallyfricked AS B
ON A.User = B.User
WHERE B.fricked = "Y"

1 result

---

Hard to believe this query returned only one result.




OP should also check out Khan Academy's SQL course. It is quick and easy to learn basics. Can get through it in 1-2 days minimal effort


From there, look at more advanced concepts

quote:

---

Isn't Microsoft Access and other things like that SQL language?

---

If you are in 1990, definitely yes.

If you are in 2000, still mostly yes but with caveats.

In 2018? Sure, Access works fine if you're doing volunteer work at the local book club where nobody knows anything better.

In all seriousness, check out CodeAcademy too. It has a free SQL course I believe. I used them to learn Python and I really liked their method.

I'm currently practicing with the Sakila open source data set, and have made some decent progress thus far. I do have a question, though.

LINK /

I'm currently trying to generate results that illustrate the most rented film (by rental_id) corresponding to each category and the number of times such film has been rented. Aka, the query should return the distinct category names, the most rented movie within such category, and the # of times the movie has been rented.

Anyone wanna take a crack at it and help me out?

A partner at work called me into an interview a few weeks ago with a girl in grad school...

First thing that stood out to me was SQL on the resume as being proficient in. A coworker beat me to the punch asking about C+ (C++? I forget because I don’t know it). I was jealous because I hadn’t used SQL in years and feel it’s a great skill to have.

The response was, “I’m self taught. I don’t have certifications.” Collective awkward silence.

Someone else noticed a minor in a foreign language. When asked whether she spoke the language-in that language-the response was...uhhhhhhhh....Si?

Don’t call us. We’ll call you.