OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Course image
edX logo

Introduction to Databases and SQL

3.4 Filled star Filled star Filled star Empty star Empty star
Based on 6 ratings
see reviews
Matt Hogan and Martin O'Hanlon

On this course from the Raspberry Pi Foundation, you will learn about databases and how to use SQL to search and manipulate the data they store.

Along the way you'll learn about primary keys and table relationships, as well as how to create joins to search multiple tables.

In the final week, you'll finish by grouping and looking at exporting data from the database.

Enroll now

What's inside

Learning objectives

  • Explain the key terms used to describe databases
  • Produce sql statements to search and update a database
  • Explain the comparison of databases to spreadsheets
  • Apply filters in sql statements
  • Demonstrate how to use sql statements to create relationships for tables in a database
  • Produce sql statements to search across multiple tables
  • Over the following three weeks, you will:

Syllabus

This course will cover:
What are databases used for?
Why use a database or a spreadsheet?
Create SQL statements to search a database
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Introduces the fundamentals of relational databases to enable efficient data storage, manipulation, and retrieval
Provides practical experience in using SQL, a widely-used database programming language, for data querying and manipulation
Suitable for beginners seeking an introduction to database concepts and SQL basics, potentially appealing to students in fields like data science or software engineering
Emphasizes data relationships and table joins, valuable for learners interested in data modeling and analysis
Part of a series of offerings from the Raspberry Pi Foundation, suggesting potential continuity and alignment with subsequent courses
May require additional resources or practice to master the practical implementation of SQL

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Foundational introduction to databases and sql

According to students, "Introduction to Databases and SQL" is a largely positive experience, especially for absolute beginners. Learners consistently praise its clear and concise lectures and the accessible explanations provided by the instructors, making complex topics easy to grasp. The course excels with its practical, hands-on exercises and labs, which significantly help to solidify understanding and provide directly applicable skills. Its logical structure and appropriate pace are also frequently highlighted. However, some learners with prior experience found the content too elementary and desired more advanced topics or complex scenarios.
Well-organized content with a natural flow of topics.
"The progression from basic commands to joins was very logical."
"I appreciated the logical flow of topics, building knowledge step-by-step."
"Highly practical and well-structured."
Perfectly suited for those with no prior database knowledge.
"Highly recommend for anyone starting out!"
"Definitely a must-take for beginners."
"It's pitched perfectly for those with no prior knowledge. Overall, a useful first step."
Provides valuable hands-on activities to reinforce learning.
"The practical exercises are brilliant and directly applicable."
"I particularly enjoyed the hands-on exercises which really helped solidify my understanding."
"The Raspberry Pi Foundation did a great job designing the labs. I learned a lot about querying and data manipulation."
Highly praised for accessible explanations and concise content.
"This course is an excellent introduction to SQL and databases. The lectures are clear and concise, making complex topics easy to understand for a complete beginner like me."
"As someone with no prior experience in databases, this course broke down SQL into digestible chunks."
"Perfect for beginners! I always found databases intimidating, but this course made it accessible. The instructor's explanations were very easy to follow."
May be too basic or slow for those with prior experience.
"It definitely is an 'introduction'. If you already know some SQL or have worked with databases, you might find it too basic."
"Found some of the content a bit too basic and repetitive, especially if you've ever dabbled in Excel functions."
"Too elementary for me. If you have any technical background at all, this will feel like a waste of time."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Introduction to Databases and SQL with these activities:
Read 'SQL Queries for Mere Mortals' by John L. Viescas
Reading this book will help you understand the fundamentals of SQL and how to write effective SQL queries.
View SQL Queries for Mere Mortals: A Hands-On Guide... on Amazon
Show steps
  • Read the first few chapters of the book
  • Try out the examples in the book
  • Answer the review questions at the end of each chapter
Review SQL
This activity will help you familiarize yourself with SQL commands and prepare you for the challenges of the course.
Browse courses on SQL
Show steps
  • Read the SQL tutorial on W3Schools
  • Practice writing SQL queries using the online SQL editor at SQLZoo
  • Complete the SQL exercises on HackerRank
Create a SQL database for a real-world scenario
Building a SQL database for a real-world scenario will allow you to apply your knowledge of SQL to a practical problem.
Browse courses on SQL Database
Show steps
  • Identify a real-world scenario where you can use SQL to solve a problem
  • Design the database schema
  • Create the database and tables
  • Populate the database with data
  • Write SQL queries to retrieve and manipulate the data
Show all three activities

Career center

Learners who complete Introduction to Databases and SQL will develop knowledge and skills that may be useful to these careers:
Database Analyst
Database Analysts design and maintain databases to help organizations optimize their data storage and retrieval systems. Graduates of *Introduction to Databases and SQL* can learn about the principles of database design, SQL, and data manipulation, which can prepare them for success as Database Analysts. This foundational knowledge can empower them to understand data structures, data types, and database management systems, making them valuable assets to organizations that rely on data-driven decision-making.
See salaries and explore the career path for Database Analyst
Data Scientist
Data Scientists use advanced statistical and computational techniques to extract insights from data, helping organizations make informed decisions. The *Introduction to Databases and SQL* course can provide Data Scientists with a solid understanding of data storage and retrieval, enabling them to work effectively with databases. This course can equip them with the skills to query and manipulate data, making them valuable contributors to data science teams.
See salaries and explore the career path for Data Scientist
Data Analyst
Data Analysts collect, clean, and analyze data to identify trends and patterns that can inform decision-making. *Introduction to Databases and SQL* can provide Data Analysts with the foundational knowledge they need to work with databases effectively. The course covers topics such as data modeling, SQL, and data visualization, which are essential skills for Data Analysts to succeed in their roles.
See salaries and explore the career path for Data Analyst
Software Engineer
Software Engineers design, develop, and maintain software applications. While the *Introduction to Databases and SQL* course is not directly related to software engineering, it can provide Software Engineers with a foundation in data management. By understanding the principles of database design and SQL, Software Engineers can better integrate databases into their software applications, enhancing their functionality and efficiency.
See salaries and explore the career path for Software Engineer
Business Analyst
Business Analysts bridge the gap between business and IT, helping organizations align their technology with their business goals. The *Introduction to Databases and SQL* course can provide Business Analysts with a deep understanding of data storage and retrieval. This knowledge can empower them to effectively analyze business data, identify opportunities for improvement, and make data-driven recommendations.
See salaries and explore the career path for Business Analyst
Data Engineer
Data Engineers design, build, and maintain data pipelines and infrastructure to support data-driven organizations. *Introduction to Databases and SQL* can provide Data Engineers with a strong foundation in data management. The course covers topics such as data modeling, SQL, and data integration, which are essential skills for Data Engineers to build and manage robust data systems.
See salaries and explore the career path for Data Engineer
Database Administrator
Database Administrators ensure the smooth operation and maintenance of databases. The *Introduction to Databases and SQL* course can provide Database Administrators with a comprehensive understanding of database management systems. The course covers topics such as database design, SQL, and performance tuning, which are essential skills for Database Administrators to effectively manage and optimize databases.
See salaries and explore the career path for Database Administrator
Information Security Analyst
Information Security Analysts protect organizations from cyber threats and data breaches. The *Introduction to Databases and SQL* course may be useful for Information Security Analysts as it provides a foundation in data security. The course covers topics such as data encryption and access control, which are essential for Information Security Analysts to understand and implement security measures to protect sensitive data.
See salaries and explore the career path for Information Security Analyst
Project Manager
Project Managers plan, execute, and close projects to achieve specific goals. The *Introduction to Databases and SQL* course may be useful for Project Managers as it provides a foundation in data management. The course covers topics such as data modeling and data analysis, which can be useful for Project Managers in understanding project requirements and tracking project progress.
See salaries and explore the career path for Project Manager
Web Developer
Web Developers design and develop websites and web applications. While the *Introduction toDatabases and SQL* course is not directly related to web development, it can provide Web Developers with a foundation in data management. By understanding the principles of database design and SQL, Web Developers can better integrate databases into their web applications, enhancing their functionality and efficiency.
See salaries and explore the career path for Web Developer
Systems Analyst
Systems Analysts analyze and design IT systems to meet the needs of organizations. The *Introduction to Databases and SQL* course may be useful for Systems Analysts as it provides a foundation in data management. The course covers topics such as data modeling and data analysis, which can be useful for Systems Analysts in understanding system requirements and designing efficient data management systems.
See salaries and explore the career path for Systems Analyst
IT Auditor
IT Auditors assess the security and effectiveness of IT systems. The *Introduction to Databases and SQL* course may be useful for IT Auditors as it provides a foundation in data security. The course covers topics such as data encryption and access control, which are essential for IT Auditors to understand and assess the security of IT systems.
See salaries and explore the career path for IT Auditor
IT Consultant
IT Consultants provide guidance and support to organizations on IT-related matters. The *Introduction to Databases and SQL* course may be useful for IT Consultants as it provides a foundation in data management. The course covers topics such as data modeling and data analysis, which can be useful for IT Consultants in understanding client needs and providing effective solutions.
See salaries and explore the career path for IT Consultant
Information Architect
Information Architects design and organize information systems to meet the needs of users. The *Introduction to Databases and SQL* course may be useful for Information Architects as it provides a foundation in data management. The course covers topics such as data modeling and data analysis, which can be useful for Information Architects in understanding user needs and designing effective information systems.
See salaries and explore the career path for Information Architect
Data Journalist
Data Journalists use data to tell stories and inform the public. The *Introduction to Databases and SQL* course may be useful for Data Journalists as it provides a foundation in data analysis. The course covers topics such as data visualization and data interpretation, which can be useful for Data Journalists in uncovering insights and communicating them effectively.
See salaries and explore the career path for Data Journalist

Reading list

We've selected nine books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Introduction to Databases and SQL.
Cover image
MySQL Reference Manual
Save
This manual is the definitive reference for MySQL. It provides detailed information on all aspects of MySQL, from installation to configuration to administration.
MySQL Reference Manual: Documentation from the...
Paperback
$$
Cover image
Database Internals
Save
Provides a comprehensive overview of database internals. It covers all the basics of database internals, and it valuable resource for anyone who wants to learn more about how databases work.
Database Internals: A Deep Dive into How...
Paperback
$$
Database Internals: A Deep Dive into How...
Kindle Edition
$$
Cover image
Logic and Relational Theory
Save
Provides a comprehensive overview of database design and relational theory. It valuable resource for anyone who wants to learn more about the design and implementation of database systems.
Logic and Databases: The Roots of Relational Theory
Paperback
$$
Logic and Relational Theory
Kindle Edition
$$
Cover image
Database Systems: The Complete Book
Save
This classic textbook provides a comprehensive overview of database systems, covering everything from the basics to advanced topics. It valuable resource for anyone who wants to learn more about databases.
Database Systems: The Complete Book
Kindle Edition
$$$
Database Systems The Complete Book
Paperback
$$
Database Systems: The Complete Book
Hardcover
$$$$
Goal Student Access Code Card for Database Systems:...
Printed Access Code
$$
Cover image
PostgreSQL 16 Administration Cookbook
Save
Provides a comprehensive overview of PostgreSQL. It covers all the basics of PostgreSQL, and it valuable resource for anyone who wants to get started with PostgreSQL.
PostgreSQL 16 Administration Cookbook: Solve real...
Kindle Edition
$$
Cover image
Learning MySQL
Save
Provides a comprehensive overview of MySQL. It covers all the basics of MySQL, and it valuable resource for anyone who wants to get started with MySQL.
Learning MySQL
Paperback
Check
Learning MySQL
Kindle Edition
Check
Cover image
PostgreSQL 9.0 Official Documentation - Volume I....
Save
This tutorial great way to learn PostgreSQL. It covers all the basics of PostgreSQL, and it valuable resource for anyone who wants to get started with PostgreSQL.
PostgreSQL 9.0 Official Documentation - Volume I....
Paperback
Check
PostgreSQL 9.0 Official Documentation - Volume I....
Kindle Edition
Check
Cover image
MySQL Crash Course
Save
Quick and easy way to learn SQL. It covers all the essential SQL commands and techniques, and it great way to get started with SQL.
MySQL Crash Course
Paperback
$$
MySQL Crash Course
Kindle Edition
$$
(中文) MySQL必知必会 (图灵程序设计丛书 97) (Chinese Edition)
Kindle Edition
$
(中文) MySQL Crash Course(Chinese Edition)
Paperback
$$
Cover image
Head First SQL
Save
This interactive and engaging book great way to learn SQL. It uses a hands-on approach to teach the basics of SQL, and it great resource for beginners who want to get started with SQL.
Head First SQL: Your Brain on SQL -- A Learner's...
Paperback
$$
Head First SQL 1st (first) edition Text Only
Unknown Binding
$$$
(Deutsch) SQL von Kopf bis Fuß (German Edition)
Kindle Edition
$$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Introduction to Databases and SQL.
Communicating Data Insights with Tableau
Most relevant
Getting Started with Data Warehousing and BI Analytics
Most relevant
Data Literacy Essentials
Most relevant
Splunk Administration and Advanced Topics
Most relevant
Defining, Describing, and Visualizing Data
Most relevant
Introduction to Technology-Assisted Decision-Making
Most relevant
Data Analysis Using SQL
Most relevant
Learn Data Storytelling: Power BI Techniques
Most relevant
Teradata: Improving Analysis and Storage
Most relevant

edX Buyer Protection & Guarantee

Verified partner policies & purchase protections

World-Class University Partner
Free Trial & Audit

Free Audit Track Available

Free audit track available for most courses, giving open access to video lectures, course readings, and assignments at no charge.

Return & Refund Policy

14-Day Full Refund Window

14-day full refund available up to 14 days after course start or 14 days after payment (whichever comes second, up to 6 months max), provided verified certificate has not yet been earned.

Buyer Protections

Verified Academic & Industry Partner

University-backed credentials authored by elite institutions like Harvard, MIT, and Oxford, with tamper-proof certificate verification.

Key Purchase Protections
Free audit track for open learning access
14-day money-back guarantee on verified certificates
Prestigious university credentials (Harvard, MIT)
Automatic unenrollment refund process via dashboard
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Rating
3.4 Filled star Filled star Filled star Empty star Empty star
Effort
2 to 4 hours per week for 3 weeks
Level
Intermediate
Via
edX
Institution
Raspberry Pi Foundation
Instructors
Matt Hogan
Martin O'Hanlon
Language
English
Transcript
English
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Introduces the fundamentals of relational databases to enable efficient data storage, manipulation, and retrieval
Provides practical experience in using SQL, a widely-used database programming language, for data querying and manipulation
Suitable for beginners seeking an introduction to database concepts and SQL basics, potentially appealing to students in fields like data science or software engineering
Emphasizes data relationships and table joins, valuable for learners interested in data modeling and analysis
Part of a series of offerings from the Raspberry Pi Foundation, suggesting potential continuity and alignment with subsequent courses
May require additional resources or practice to master the practical implementation of SQL
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
Enroll now to gain full access to Introduction to Databases and SQL.
Enroll now
Save for later
Add this course to your list. Find it anytime.
Save
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser