--- title: Database Fundamentals description: 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. category: programming-tech subcategory: databases difficulty: beginner, intermediate, advanced url: /subject/database-fundamentals --- # Database Fundamentals 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. ## Available Resources 1 Videos • 2 Books • 2 Courses • 2 Websites ## Videos ### 1. SQL Tutorial for Beginners **Author:** Mike Dane Four-hour freeCodeCamp course by Mike Dane using MySQL. Covers tables, keys, constraints, inserts and updates, basic queries, functions, wildcards, unions, joins, nested queries and triggers, plus ER diagrams, ending with a company-database project. **Difficulty:** Beginner | **Price:** Free **Link:** https://www.youtube.com/watch?v=HXV3zeQKqGY **Tags:** sql, mysql, relational-databases, joins, database-design ## Courses ### 1. Databases and SQL for Data Science with Python **Author:** Rav Ahuja, Hima Vasudevan IBM course on Coursera teaching SQL for data work, from SELECT, INSERT, UPDATE and DELETE through filtering, grouping, subqueries, joins, views, stored procedures and transactions. Labs query cloud databases from Jupyter notebooks with Python, ending in a project analysing real-world datasets. **Difficulty:** Beginner | **Price:** Free **Link:** https://www.coursera.org/learn/sql-data-science **Tags:** sql, python, data-science, jupyter, relational-databases ### 2. 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 **Difficulty:** Beginner | **Language:** English | **Duration:** 5 weeks of study, 1.5 - 3 hours/week. | **Price:** Free **Link:** https://www.coursera.org/learn/introduction-to-databases **Tags:** courses, technology-computer-science, database ## Books ### 1. Database Systems: The Complete Book **Author:** Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom A comprehensive Stanford textbook spanning relational database design, the relational model and algebra, SQL, constraints, transactions, storage structures, indexing, and query execution and optimization. Readers learn both how to design and query databases and how database engines work internally. **Difficulty:** Intermediate | **Language:** English | **Price:** Paid **Link:** https://www.amazon.com/dp/0130319953?tag=edmonddante07-20 **Tags:** books, technology-computer-science, database ### 2. Database Management Systems **Author:** Raghu Ramakrishnan, Johannes Gehrke A widely used university textbook covering the relational model, SQL, ER modeling, normalization, file organization, indexing, query evaluation and optimization, transaction management, and concurrency control. Readers understand how relational database systems store, query, and protect data. **Difficulty:** Intermediate | **Language:** English | **Price:** Paid **Link:** https://www.amazon.com/dp/0072322063?tag=edmonddante07-20 **Tags:** books, technology-computer-science, database ## Websites ### 1. 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. **Difficulty:** Intermediate | **Language:** English | **Price:** Free **Link:** https://use-the-index-luke.com **Tags:** websites, technology-computer-science, computer-sciences ### 2. 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. **Difficulty:** Intermediate | **Language:** English | **Price:** Free **Link:** https://sqlzoo.net **Tags:** websites, technology-computer-science, computer-sciences --- *This content is part of Dantes.io - Your Treasure Map to Knowledge* *Curated by humans at Dantes.io. Personal study use welcome; republishing this curation requires permission (team@dantes.io).* View this page online: https://dantes.io/subject/database-fundamentals