Monte Cristo Logo
Monte Cristo

Relational Databases

24 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 - Full Database Course for Beginners

4-hour freeCodeCamp course covering SQL basics to advanced queries in PostgreSQL.

beginner🇬🇧

🎓Courses(8)

scroll for more →
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

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

Introduction to Databases with SQL

Learn SQL database basics with this free Khan Academy course! Master relational databases and data querying.

beginner🇬🇧
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

Relational Database Certification

Master relational databases with freeCodeCamp's certification course! Learn SQL, database design, and build practical projects.

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(2)

book👁️ 0

Fundamentals of Database Systems

Fundamentals of Database Systems - A book resource

intermediate🇬🇧
book👁️ 0

SQL and Relational Theory

SQL and Relational Theory - A book resource

intermediate🇬🇧

🌐Websites(9)

scroll for more →
website👁️ 0

SQLZoo

Interactive SQL tutorials and exercises.

beginner🇬🇧
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

Use The Index, Luke

Explains SQL indexes and performance tuning.

beginner🇬🇧
website👁️ 0

SQLite Tutorial

Comprehensive free tutorial for learning SQL with SQLite.

beginner🇬🇧
website👁️ 0

use-the-index-luke.com

Use The Index, Luke! is a practical guide to relational database indexing, teaching how to design and use indexes to speed up queries and read execution plans. It includes tutorials, examples, and reference material on index types, optimization techniques, and cross-DBMS guidance.

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

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🇬🇧

🎙️Podcasts(2)

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🌐
podcast👁️ 0

Software Engineering Daily

Technical interviews about software topics.

beginner🌐

Frequently Asked Questions

What are the best free resources to learn Relational Databases?

Dantes has curated 15 resources for Relational Databases, including 3 videos, 6 courses, 6 websites. 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, 6 courses, 6 websites. 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.