Skip to main content
Monte Cristo Logo
Monte Cristo

Relational Databases

Study sheet

Relational databases organize data into structured tables linked by defined relationships. Learners will understand schema design, normalization, ACID transactions, and how to manage data integrity using relational database management systems like PostgreSQL and MySQL.

28 resources

Level
Type

📹Videos(3)

video👁️ 0

Postgres Full Tutorial

Programming with Mosh PostgreSQL tutorial.

beginner🇬🇧
video👁️ 0

The Ultimate MySQL Bootcamp

Colt Steele's popular Udemy course preview/full on YouTube.

beginner🇬🇧
video👁️ 0

SQL Tutorial for Beginners

Comprehensive SQL tutorial covering basics to advanced queries

beginner🇬🇧

📺YouTube(1)

youtube👁️ 0

Programming with Mosh - SQL Tutorial for Beginners

Mosh Hamedani's 'Programming with Mosh' channel provides high-quality, concise tutorials. His SQL tutorial, while broadly applicable, covers fundamental concepts essential for MySQL users. It is free, highly relevant, and has a strong positive community reputation, making it an excellent learning resource.

beginner🇬🇧

🎓Courses(8)

scroll for more →
course👁️ 0

Databases

Learn relational databases and SQL with this free course by Jennifer Widom. Master database concepts & query data effectively!

intermediate🇬🇧
course👁️ 0

Introduction to Database Systems (15-445/645)

Learn relational database systems from Carnegie Mellon's Andy Pavlo. Explore core concepts and implementations!

advanced🇬🇧
course👁️ 0

SQL for Data Science

As data collection has increased exponentially, so has the need for people skilled at using and interacting with data; to be able to think critically, and provide insights to make better decisions and optimize their businesses. This is a data scientist, “part mathematician, part computer scientist, and part trend spotter” (SAS Institute, Inc.). According to Glassdoor, being a data scientist is the best job in America; with a median base salary of $110,000 and thousands of job openings at a time. The skills necessary to be a good data scientist include being able to retrieve and work with data, and to do that you need to be well versed in SQL, the standard language for communicating with database systems. This course is designed to give you a primer in the fundamentals of SQL and working with data so that you can begin analyzing it for data science purposes. You will begin to ask the right questions and come up with good answers to deliver valuable insights for your organization. This course starts with the basics and assumes you do not have any knowledge or skills in SQL. It will build on that foundation and gradually have you write both simple and complex queries to help you select data from tables. You'll start to work with different types of data like strings and numbers and discuss methods to filter and pare down your results. You will create new tables and be able to move data into them. You will learn common operators and how to combine the data. You will use case statements and concepts like data governance and profiling. You will discuss topics on data, and practice using real-world programming assignments. You will interpret the structure, meaning, and relationships in source data and use SQL as a professional to shape your data for targeted analysis purposes. Although we do not have any specific prerequisites or software requirements to take this course, a simple text editor is recommended for the final project. So what are you waiting for? This is your first step in landing a job in the best occupation in the US and soon the world!

beginner🇬🇧
course👁️ 0

Intro to SQL: Querying and managing data

Learn SQL fundamentals with Khan Academy! Master querying and managing data in this free introductory course.

beginner🇬🇧
course👁️ 0

Relational Database

Master SQL database concepts with freeCodeCamp's interactive Relational Database course. Build practical projects and gain valuable skills!

beginner🇬🇧
course👁️ 0

Databases and SQL for Data Science with Python

Working knowledge of SQL (or Structured Query Language) is a must for data professionals like Data Scientists, Data Analysts and Data Engineers. Much of the world's data resides in databases. SQL is a powerful language used for communicating with and extracting data from databases. In this course you will learn SQL inside out- from the very basics of Select statements to advanced concepts like JOINs. You will: -write foundational SQL statements like: SELECT, INSERT, UPDATE, and DELETE -filter result sets, use WHERE, COUNT, DISTINCT, and LIMIT clauses -differentiate between DML & DDL -CREATE, ALTER, DROP and load tables -use string patterns and ranges; ORDER and GROUP result sets, and built-in database functions -build sub-queries and query data from multiple tables -access databases as a data scientist using Jupyter notebooks with SQL and Python -work with advanced concepts like Stored Procedures, Views, ACID Transactions, Inner & Outer JOINs through hands-on labs and projects You will practice building SQL queries, work with real databases on the Cloud, and use real data science tools. In the final project you’ll analyze multiple real-world datasets to demonstrate your skills.

beginner🇬🇧
course👁️ 0

Introduction to Relational Databases

Database management systems are a crucial part of most large-scale industry and open-source systems. This course will introduce you to important concepts of database systems and design. We will learn what relational databases are, what they are used for, the theory underlying their design, and how to query and modify a database using the declarative SQL language. At the end of the course, you will be able to: - Describe what relational databases are, and how they are used. - Master the Relational Database Model. - Demonstrate proficiency in formal relational database theory. - Demonstrate comprehensive SQL skills. - Apply database knowledge to practical problems. Software Requirements: Jupyter Notebooks, SQL

beginner🇬🇧
course👁️ 0

Advanced Relational Databases

This course is one of five self-paced courses on the topic of Databases, originating as one of Stanford's three inaugural massive open online courses released in the fall of 2011. The original "Databases" courses are now all available on edx.org. This course is broad and practical, covering indexes, transactions, constraints, triggers, views, and authorization, all in the context of relational database systems and the SQL language. This course builds on concepts introduced in Databases: Relational Databases and SQL and is recommended for learners seeking to advance their understanding and use of relational databases. The Indexes and Transactions section of this course covers two important features of database systems from the application-builder's perspective: indexing for increased performance, and transactions for concurrency control and failure recovery. The Constraints and Triggers section of this course explains key, referential integrity, and "check" constraints, followed by comprehensive coverage of database triggers. The Views and Authorization section of this course provides extensive coverage of how database views can be created, used, and updated, and introduces standard techniques for authorization in relational databases.

intermediate🇬🇧

📚Books(3)

book👁️ 0

Fundamentals of Database Systems

Fundamentals of Database Systems - A book resource

intermediate🇬🇧
book👁️ 0

Relational Database Design and Implementation

Relational Database Design and Implementation - A book resource

intermediate🇬🇧
book👁️ 0

SQL and Relational Theory

SQL and Relational Theory - A book resource

intermediate🇬🇧

🌐Websites(11)

scroll for more →
website👁️ 0

PostgreSQL Tutorial

Official-like free tutorial site for Postgres.

beginner🇬🇧
website👁️ 0

Explain Extended

In-depth SQL query optimization articles.

beginner🇬🇧
website👁️ 0

DB-Fiddle

Online SQL fiddle for multiple RDBMS to test queries.

beginner🇬🇧
website👁️ 0

SQLite Tutorial

Comprehensive free tutorial for learning SQL with SQLite.

beginner🇬🇧
website👁️ 0

MySQL 8.0 Reference Manual

The official and most comprehensive documentation for MySQL. It's an invaluable resource for understanding all aspects of MySQL, from installation and configuration to advanced features, SQL syntax, and administration. While not a traditional 'book' in print, it functions as a highly detailed and authoritative reference available online for free.

beginner🇬🇧
website👁️ 0

geeksforgeeks.org

GeeksforGeeks is a comprehensive programming education platform offering tutorials, explanations, and examples on algorithms, data structures, and core CS topics. It also provides practice problems, coding challenges, and interview-focused articles to help learners build and test their skills.

intermediate🇬🇧
website👁️ 0

sqlshack.com

SQLShack is a comprehensive resource for SQL Server and relational databases, offering tutorials, guides, and practical code examples on T-SQL, database design, administration, and performance tuning.

intermediate🇬🇧
website👁️ 0

use-the-index-luke.com

A practical guide to database indexing and query optimization, offering clear explanations of how indexes work, how to design them, and tutorials with SQL examples across major relational databases.

intermediate🇬🇧
website👁️ 0

datacamp.com

DataCamp is an online learning platform for data science offering interactive, hands-on courses and tracks in Python, R, SQL, and other data tools. It features coding exercises, real-world projects, and skill assessments.

intermediate🇬🇧
website👁️ 0

freecodecamp.org

FreeCodeCamp.org is a nonprofit coding education platform offering free, self-paced lessons and interactive challenges on web development and data topics, including relational databases and SQL, along with hands-on projects and certificates.

intermediate🇬🇧
website👁️ 0

sqlzoo.net

SQLZoo.net is an interactive SQL learning resource offering free tutorials and hands-on practice with live databases. It provides step-by-step lessons and coding exercises on SQL topics (SELECT, JOIN, aggregation, etc.) with immediate feedback.

intermediate🇬🇧

🎙️Podcasts(2)

podcast👁️ 0

Software Engineering Daily

Technical interviews about software topics.

beginner🌐
podcast👁️ 0

The Data Stack Show

Each week we’ll talk to data engineers, analysts, and data scientists about their experience around building and maintaining data infrastructure, delivering data and data products, and driving better outcomes across their businesses with data.

beginner🌐

Frequently Asked Questions

What are the best free resources to learn Relational Databases?

Dantes has curated 28 resources for Relational Databases, including 3 videos, 1 YouTube videos, 3 books, 8 courses, 11 websites, 2 podcasts. All resources are hand-picked for quality — no algorithmic filler. Browse the full list above to find the format that works best for you.

Is Relational Databases hard to learn?

Relational Databases is approachable at the beginner level — there are resources here specifically for those starting from scratch. As you progress, intermediate and advanced material is also available to take your skills further.

What types of Relational Databases learning resources are available on Dantes?

For Relational Databases, Dantes has curated 3 videos, 1 YouTube videos, 3 books, 8 courses, 11 websites, 2 podcasts. Each resource type serves a different learning style: videos and YouTube for visual learners, books for depth, courses for structured progression, and websites for quick reference.

How does Dantes select Relational Databases resources?

Dantes is an algorithm-free learning directory. Resources are hand-curated based on quality, accuracy, and usefulness — not engagement metrics or paid placements. The goal is to surface the best learning material for Relational Databases, whether it's a free YouTube series, a classic textbook, or an open courseware from a top university.

Go deeper

Test your understanding of Relational Databases

Explain it out loud. An AI tutor listens and asks questions that expose gaps you didn't know you had.