Log In

Your email is not your username

Register

If you were a member of the old Bodybuilding.com forums and would like to reuse your previous username, you can request it below. We use your email only for registration and do not store it. For more information, please see our Privacy Policy.

Confirm your email

A registration code was sent to your email. Enter it here.

Welcome

You have successfully setup your account.

Sign in

Quick Navigation Bottom Misc
Forum » MySQL - Books/Video Recommendations
  1. Results 1 to 18 of 18
  2. Page 1 of 1

Thread: MySQL - Books/Video Recommendations

post 1653801513 01-05-2022, 09:11 PM
-
#1
  1. iamanalphamale
  2. NEG ME HARDER, DADDY
  1. iamanalphamale
  2. NEG ME HARDER, DADDY
  3. Join Date: Apr 2021
  4. Posts: 4,770
  5. Rep Power: 22835

MySQL - Books/Video Recommendations

Getting into learning MySQL as a way to branch to something new and as a hopeful job career (looking to work remote/WFH).

Anyone here know some books/videos to watch for a beginner and intermediate?

Not really interested in spending money on Udemy or whatever site if I can learn this for free - rather save my money.

Serious help appreciated.



Thanks!
post 1653801603 01-05-2022, 09:13 PM
-
#2
  1. SaviorSelfJT
  2. clownslayer
  1. SaviorSelfJT
  2. clownslayer
  3. Join Date: Aug 2010
  4. Posts: 12,855
  5. Rep Power: 166618
You don't know SQL until you can use window functions and recursive CTEs

---

For practicing, leetcode has SQL questions
Best lifts:
Bench press: 315x5
Squat: 465x1
Strict press: 205x5
Deadlift: 405x13 (conv tap'n'go with straps)
post 1653801733 01-05-2022, 09:19 PM
-
#3
  1. bartosh
  2. Registered Nerd
  1. bartosh
  2. Registered Nerd
  3. Join Date: Apr 2010
  4. Posts: 11,559
  5. Rep Power: 77338
Install
- sql server express
- sql server management studio(ssms)

Install a local instance of sql server via sql server express. Watch a YouTube video

Do two tutorials
1) a tutorial that has you build a database from scratch using ssms
2) a tutorial that provides a built out database that you load into ssms and do queries into it

After that, leetcode and you should be pretty much set

Tbh that shouldn’t take you over a week tops


Not sure what free options there are unfortunately but you can easily find good YouTube videos that cover everything in multi-part series. I use pluralsight for my subscription service
MS, Computer Science
Feel free to PM me CS questions
post 1653801823 01-05-2022, 09:21 PM
-
#4
  1. tunafishha
  2. Registered CCP
  1. tunafishha
  2. Registered CCP
  3. Join Date: Nov 2014
  4. Posts: 29,114
  5. Rep Power: 27114
They said OP can be anything so he became a database admin.
*Catholic Crew*
*Community College Master Race*
*5'5 Masterrace*
*Starbucks Crew*
*Buy high, sell low*
post 1653802023 01-05-2022, 09:24 PM
-
#5
  1. BrianDaMan
  2. Registered User
  1. BrianDaMan
  2. Registered User
  3. Join Date: Jun 2011
  4. Posts: 22,168
  5. Rep Power: 383523
https://sqlzoo.net/wiki/SQL_Tutorial
post 1653802473 01-05-2022, 09:34 PM
-
#6
  1. iamanalphamale
  2. NEG ME HARDER, DADDY
  1. iamanalphamale
  2. NEG ME HARDER, DADDY
  3. Join Date: Apr 2021
  4. Posts: 4,770
  5. Rep Power: 22835
Originally Posted By bartosh⏩
Install
- sql server express
- sql server management studio(ssms)

Install a local instance of sql server via sql server express. Watch a YouTube video

Do two tutorials
1) a tutorial that has you build a database from scratch using ssms
2) a tutorial that provides a built out database that you load into ssms and do queries into it

After that, leetcode and you should be pretty much set

Tbh that shouldn’t take you over a week tops


Not sure what free options there are unfortunately but you can easily find good YouTube videos that cover everything in multi-part series. I use pluralsight for my subscription service
Does this all apply as well w/ MySQL as that is the tool I am using - MacOS user.
post 1653802923 01-05-2022, 09:46 PM
-
#7
  1. batmanman
  2. Rep Power: 696969
  1. batmanman
  2. Rep Power: 696969
  3. Join Date: Oct 2006
  4. Location: Manhattan, Kansas, United States
  5. Age: 36
  6. Posts: 29,598
  7. Rep Power: 55554
Used to be a mysql injection exploit on this site where you could glitch the 1000 posts per 1 rep power feature

Just had to run a mysql injection with some bullcrap into someone's bodyspace profile, since the forums and bodyspavce were connected then the picture comments counted as posts

You could post like 400 million comments all at once then end up with 400k rep power
post 1653803853 01-05-2022, 10:15 PM
-
#8
  1. BraddlesMcGee
  2. Registered User
  1. BraddlesMcGee
  2. Registered User
  3. Join Date: Dec 2011
  4. Age: 36
  5. Posts: 11,239
  6. Rep Power: 58176
MariaDB is a fork of MySQL which is widely considered superior, and compatible.
Nocrew crew

SS final perma ban request
https://forum.obnoxiousbrutes.com/showthread.php?t=184614323
post 1653805693 01-05-2022, 11:02 PM
-
#9
  1. bartosh
  2. Registered Nerd
  1. bartosh
  2. Registered Nerd
  3. Join Date: Apr 2010
  4. Posts: 11,559
  5. Rep Power: 77338
Originally Posted By iamanalphamale⏩
Does this all apply as well w/ MySQL as that is the tool I am using - MacOS user.
More or less exactly the same, just different softwares. I think you still use sql server express just not ssms. Not 100% sure though
MS, Computer Science
Feel free to PM me CS questions
post 1653805953 01-05-2022, 11:10 PM
-
#10
  1. Astra5H
  2. Banned
  1. Astra5H
  2. Banned
  3. Join Date: Sep 2020
  4. Age: 56
  5. Posts: 1,122
  6. Rep Power: 0
repped
post 1653805983 01-05-2022, 11:10 PM
-
#11
  1. iamanalphamale
  2. NEG ME HARDER, DADDY
  1. iamanalphamale
  2. NEG ME HARDER, DADDY
  3. Join Date: Apr 2021
  4. Posts: 4,770
  5. Rep Power: 22835
Originally Posted By bartosh⏩
More or less exactly the same, just different softwares. I think you still use sql server express just not ssms. Not 100% sure though
Well, its basically what I have available to learn at the moment.

I assume the tools will change however, the syntax for how SQL works is pretty universal cross-platforms?
post 1653806123 01-05-2022, 11:13 PM
-
#12
  1. Xerve
  2. Registered User
  1. Xerve
  2. Registered User
  3. Join Date: Mar 2019
  4. Posts: 3,491
  5. Rep Power: 26179
Learn the basic commands and then play games like this that really help you retain the knowledge. Build from there.. tons of resources on YT for learning

SQL murder mystery game
https://mystery.knightlab.com/
post 1653806213 01-05-2022, 11:15 PM
-
#13
  1. Ratfish
  1. Ratfish
  3. Join Date: Jul 2009
  4. Location: Portland, Oregon, United States
  5. Posts: 113,850
  6. Rep Power: 576095
Legit just realized your username is

i am anal phamale

Mind obliterated
Make Europe Germany Again
post 1653806283 01-05-2022, 11:18 PM
-
#14
  1. iamanalphamale
  2. NEG ME HARDER, DADDY
  1. iamanalphamale
  2. NEG ME HARDER, DADDY
  3. Join Date: Apr 2021
  4. Posts: 4,770
  5. Rep Power: 22835
Originally Posted By Ratfish⏩
Legit just realized your username is

i am anal phamale

Mind obliterated
I am also from Portland, OR - mind even more blown.
post 1653806423 01-05-2022, 11:22 PM
-
#15
  1. Ratfish
  1. Ratfish
  3. Join Date: Jul 2009
  4. Location: Portland, Oregon, United States
  5. Posts: 113,850
  6. Rep Power: 576095
Originally Posted By iamanalphamale⏩
I am also from Portland, OR - mind even more blown.
Ffffuark
Make Europe Germany Again
post 1653806543 01-05-2022, 11:24 PM
-
#16
  1. iamanalphamale
  2. NEG ME HARDER, DADDY
  1. iamanalphamale
  2. NEG ME HARDER, DADDY
  3. Join Date: Apr 2021
  4. Posts: 4,770
  5. Rep Power: 22835
Originally Posted By Ratfish⏩
Ffffuark
I know, goosebumps.
post 1653846093 01-06-2022, 02:52 PM
-
#17
  1. binlogic
  2. Registered User
  1. binlogic
  2. Registered User
  3. Join Date: Dec 2019
  4. Posts: 1,956
  5. Rep Power: 0
Originally Posted By batmanman⏩
Used to be a mysql injection exploit on this site where you could glitch the 1000 posts per 1 rep power feature

Just had to run a mysql injection with some bullcrap into someone's bodyspace profile, since the forums and bodyspavce were connected then the picture comments counted as posts

You could post like 400 million comments all at once then end up with 400k rep power
Huge if true. You Mr. Robot brah?
post 1654026213 01-09-2022, 06:18 PM
-
#18
  1. iamanalphamale
  2. NEG ME HARDER, DADDY
  1. iamanalphamale
  2. NEG ME HARDER, DADDY
  3. Join Date: Apr 2021
  4. Posts: 4,770
  5. Rep Power: 22835
For those interested, I found a video on SQL that did a very good job at teaching the basics - freecodecamp is an amazing channel!




Anyways, will be starting on a project to design a database for a made-up school district my first project.

Will expand on more projects afterwards - banks, corporation, etc.
Quick Navigation Top Misc
Bookmarks
Digg.com
Digg
del.icio.us
del.icio.us
Stumbleupon.com
StumbleUpon
Google.com
Google
Facebook.com
Facebook
Posting Permissions
  1. You may not post new threads
  2. You may not post replies
  3. You may not post attachments
  4. You may not edit your posts