Skip to main content
Monte Cristo Logo
Monte Cristo

Database Fundamentals

Study sheet

Database fundamentals introduces the core concepts of data storage, retrieval, and management. Learners will understand the differences between relational and non-relational systems, basic query writing, data modeling, and the role databases play in software applications.

11 resources

Level
Type

📹Videos(1)

video👁️ 0

SQL Tutorial for Beginners

Comprehensive SQL tutorial covering basics to advanced queries

beginner🇬🇧

🎓Courses(2)

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 Databases

In this course, you will be introduced to databases and explore the modern ways in which they are used. Learn to distinguish between different types of database management systems then practice basic creation and data selection with the use of Structured Query Language (SQL) commands. By the end of this course, you’ll be able to: - Demonstrate a working knowledge of the concepts and principles that underpin how databases work - Identify and explain the different types of core technology and management systems used in databases - Identify and interpret basic SQL statements and commands - Manipulate records in a database with the use of SQL statements and commands - Outline alternatives to SQL - and plan and design a simple relational database system You’ll also gain experience with the following: • Fundamental concepts in database • Basic MySQL syntax and commands • Database management systems • MySQL software • Relational databases

beginner🇬🇧

📚Books(2)

book👁️ 0

Database Systems: The Complete Book

Database Systems: The Complete Book - A book resource

intermediate🇬🇧
book👁️ 0

Database Management Systems

Database Management Systems - A book resource

intermediate🇬🇧

🌐Websites(6)

scroll for more →
website👁️ 0

DB-Fundamentals

Interactive SQL and database tutorials

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

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

tutorialspoint.com/dbms

Tutorialspoint's DBMS section offers step-by-step lessons on database concepts—from data models and architecture to SQL, normalization, indexing, and transactions—with clear explanations, code examples, diagrams, and practice exercises.

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

Frequently Asked Questions

What are the best free resources to learn Database Fundamentals?

Dantes has curated 11 resources for Database Fundamentals, including 1 videos, 2 books, 2 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 Database Fundamentals hard to learn?

Database Fundamentals 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 Database Fundamentals learning resources are available on Dantes?

For Database Fundamentals, Dantes has curated 1 videos, 2 books, 2 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 Database Fundamentals 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 Database Fundamentals, whether it's a free YouTube series, a classic textbook, or an open courseware from a top university.

Go deeper

Test your understanding of Database Fundamentals

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