View in: Desktop
Copyright @2024 TigerDroppings.com. All rights reserved.
- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Posted by
Message
Best way to learn mySQL in a week?
Posted by LSUlunatic on 12/13/18 at 12:49 pm11
I have a case study for a job interview next week. Need to learn SQL as soon as possible. Looking for advice, tutors, online study materials.. anything I can do to help prep for this thing. Thanks in advance.
re: Best way to learn mySQL in a week?Posted by lnomm34 on 12/13/18 at 12:57 pm to LSUlunatic
quote:
Best way to learn mySQL in a week?
I have a case study for a job interview next week
You're fricked.
re: Best way to learn mySQL in a week?Posted by Mingo Was His NameO on 12/13/18 at 1:01 pm to LSUlunatic
Are you supposed to already know it or is it an advantage? If the first why did you lie on the application?
re: Best way to learn mySQL in a week?Posted by WPBTiger on 12/13/18 at 1:06 pm to Mingo Was His NameO
quote:
why did you lie
re: Best way to learn mySQL in a week?Posted by BitBuster on 12/13/18 at 1:20 pm to LSUlunatic
Select * from 'Job Interview' where 'LSUlunatic' equals 'not fricked'
Results Returned:
Zero
Results Returned:
Zero
re: Best way to learn mySQL in a week?Posted by Mingo Was His NameO on 12/13/18 at 1:23 pm to BitBuster
Isn't Microsoft Access and other things like that SQL language? If so the basics are really easy
re: Best way to learn mySQL in a week?Posted by LSUlunatic on 12/13/18 at 1:28 pm to Mingo Was His NameO
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.
re: Best way to learn mySQL in a week?Posted by oklahogjr on 12/13/18 at 3:07 pm to LSUlunatic
I dont understand why you just dont work the case study come up with questions answer it with sql data pulls. if case requires automation start building and googling.
good luck you're prolly fricked
good luck you're prolly fricked
re: Best way to learn mySQL in a week?Posted by LSUlunatic on 12/13/18 at 4:31 pm to CptRusty
Wow, thanks so much!!!!!
TD SponsorTD Fan
USA
Member since 2001
USA
Member since 2001
Thank you for supporting our sponsors Posted by Site Sponsor to Everyone
Advertisement
re: Best way to learn mySQL in a week?Posted by alabamabuckeye on 12/14/18 at 10:46 am to LSUlunatic
SELECT A.*
FROM MoneyTalk.TigerDroppings AS A
JOIN List.Totallyfricked AS B
ON A.User = B.User
WHERE B.fricked = "Y"
1 result
FROM MoneyTalk.TigerDroppings AS A
JOIN List.Totallyfricked AS B
ON A.User = B.User
WHERE B.fricked = "Y"
1 result
re: Best way to learn mySQL in a week?Posted by GenesChin on 12/14/18 at 2:11 pm to alabamabuckeye
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
This post was edited on 12/14 at 2:12 pm
re: Best way to learn mySQL in a week?Posted by tss22h8 on 12/14/18 at 2:55 pm to LSUlunatic
quote:
learn mySQL in a week?
re: Best way to learn mySQL in a week?Posted by foshizzle on 12/14/18 at 8:24 pm to Mingo Was His NameO
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.
re: Best way to learn mySQL in a week?Posted by Mingo Was His NameO on 12/14/18 at 9:22 pm to foshizzle
quote:
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.
So, yes, thanks
re: Best way to learn mySQL in a week?Posted by alabamabuckeye on 12/14/18 at 10:06 pm to Mingo Was His NameO
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.
re: Best way to learn mySQL in a week?Posted by oklahogjr on 12/15/18 at 12:22 am to Mingo Was His NameO
access is judt a ui on a sql database anymore really. it's easier and doesnt require overhead of servers.
also isn't as powerful as sql database either or able to handle scale well.
also isn't as powerful as sql database either or able to handle scale well.
re: Best way to learn mySQL in a week?Posted by LSUlunatic on 12/19/18 at 11:24 pm to oklahogjr
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?
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?
re: Best way to learn mySQL in a week?Posted by Sev09 on 12/19/18 at 11:30 pm to Mingo Was His NameO
MySQL has a few nuances you won’t find in traditional T-SQL
ETA: W3 schools has a great free interactive course to learn SQL basics. You could definitely blow through that in a week or less.
ETA: W3 schools has a great free interactive course to learn SQL basics. You could definitely blow through that in a week or less.
This post was edited on 12/19 at 11:32 pm
re: Best way to learn mySQL in a week?Posted by GFunk on 12/19/18 at 11:38 pm to LSUlunatic
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.
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.
This post was edited on 12/19 at 11:45 pm
Back to top
Follow TigerDroppings for LSU Football News