JuanDeaged
-
Posts
819 -
Joined
-
Last visited
-
Days Won
6
3 Followers
About JuanDeaged
- Birthday 04/20/2003
Recent Profile Visitors
30517 profile views
JuanDeaged's Achievements
Immigrant (1/7)
1.4k
Reputation
Single Status Update
-
Who wants to teach me SQL over the summer?
-
And what would you like to learn how to communicate with a database for sir ?
-
I highly recommend code academy and w3 schools to help learn online, then spin up a PostgreSQL instance to demo and try things on your own.
Consider making a database for fun things - for example, a Game of Thrones themed database, with a table for characters, one for family houses, one for types of weapons, etc.
It's a good way to learn different relations (one to one, many to one, many to many), when each should be used.
Other stuff:
- Then learn to make triggers to make a field to dynamically update the time a record was last updated
- Indices to retrieve data faster
- Soft deletions vs hard deletions in data for protection
Feel free to reach out to me on Discord if you have questions or anything: PoptartRex #6077
-
