How do I get good at databases?

learn algebra

>>61984310
How does learning algebra help with databases?

>>61984321
I wonder...

>>61984387
Stop being a faggot.

Watch Log Horizon.

>>61984670
You're on the right track.
Keep going, and you'll master databases in no time.

Is there some book/site full of exercises where i can practice sql queries?

All sites i have found really lack in number of exercises

>>61984171
Keep putting data in bases until you can do that with closed eyes.

>>61984869
Udemy or Lynda?

>>61984917
they just teach basic concepts, i want shitload of exercises

>>61984994
I'm taking a 21 hour long course on Udemy. Seems pretty thorough to me.

>>61985035
name

>>61985038
https://www.udemy.com/the-ultimate-mysql-bootcamp-go-from-sql-beginner-to-expert/

It's MySQL. If you can get past the guy's cringe humor it's bretty gud.

>>61985317
anything that has any connections with anime can't be good

>>61984917
Hacker Rank has a lot of decent SQL exercises.

>>61986455
To add to this, I also recommend Seven Databases in Seven Weeks and Readings in Database Systems.

You can also hack together CRUD apps with Postgres and Mongo until you get the hang of it.

>>61985789
pay this man a beer

File: Log Horizon.gif (1MB, 208x186px) Image search: [Google]

1MB, 208x186px

>>61984715

>>61984670
Roll

>>61985789
+beer

>>61986522
>>61987006
>>61985789

I like this thread

Databases are the worst meme that has ever happened to IT.

>>61984321
relational algebra

>>61987151
go ahead, say something better

>>61984994
>make your own database
>start practicing
do you really need a book?

Pay me $20 and I'll give you a list of exercises

>>61984869
hacker rank

>>61984715
shit animu

>>61987313
>do something i am sure it's right
>can't check real solution
>learn jack shit

File: 1476875341557.jpg (65KB, 433x482px) Image search: [Google]

65KB, 433x482px

>>61984171

File: 1501636214095.png (359KB, 600x800px) Image search: [Google]

359KB, 600x800px

>>61988660

To get good at databases, it is like anything worth learning and takes lots of time. I studied enterprise information systems at uni and this got me started but was pretty lacking at actually teaching me what to do with databases. (skip this if you can)
Next step make your own, find something you can catalogue and normalise. If you are having trouble thinking of anything look at some crime or health statistics, they are usually good candidates.
Set theory really is your friend if you want to understand how things actually work in relational databases.
I did this and it was enough for me to get an entry level position programming but working closely with data migrations. In 3 months I have learned more than uni and self study combined. Having a good mentor really helped as well as doing it every day.

File: 1501675885761.png (428KB, 618x529px) Image search: [Google]

428KB, 618x529px

>>61991209
do you recommend any books?

>>61985789
It's manga, there's no anime.

>>61991394
No sorry. Never really used books

>>61984670
I wish to kiss all of these midriffs.

>big computer
>stores lots of data
Not much to understand, really.

>>61985789
It is the opposite.

>>61984670
fucking weebs

>>61985789
>4chan started as an anime discussion forum
it all makes sense now

>>61984171
Collect enough animu pictures and cute midriffs that you inevitably come over the problem where you have no fucking idea how to organise it. Then it will come to you, in a fury of caffeine, fapping and reading literature on databases