SQL 101: Relational Database Fundamentals

Helen Anderson on September 01, 2018

When working with data in relational databases there are some key concepts to understand. These are some of the things I found useful when getting... [Read Full]
markdown guide
 
 
 

The best topic would be: how to create a relational database from scratch, say an RDBMS about a school having students, teachers, classes, courses etc.

I would give 10 thumbs up for such a post! (I'll borrow the 8 other thumbs from other people!)

 
 
 
 

I find it refreshing that you wrote the SQL code downcase. I always felt afraid of SQL and seeing it downcase makes it more pleasant. Thanks.

 

One record in relational database is a basic relation.

 

Yeaaaah SQL! This is my jam! Thanks for this post. I may use relational databases every day, but I do struggle to understand the definition and explain it to people.

 

Love the enthusiasm! I'm drafting posts about indexes, joins, subqueries and CTEs (all with a T-SQL flavour) and my observations when dabbling in Postgres. Stay tuned :)

code of conduct - report abuse