Understand the fundamentals of databases and data management systems. This course covers core concepts, the differences between relational (SQL) and NoSQL databases, and how to interact with data using basic SQL commands. Learn essential principles for storing, organizing, and retrieving information effectively. Suitable for individuals starting with data management.
Prerequisites No prior knowledge needed
Level:
Core Database Concepts
Explain what a database and a Database Management System (DBMS) are, and why they are used.
Relational Model Basics
Describe the fundamental components of the relational model, including tables, rows, columns, and primary keys.
Basic SQL Queries
Write simple SQL statements to retrieve (SELECT), insert (INSERT), modify (UPDATE), and remove (DELETE) data.
NoSQL Database Awareness
Recognize the existence and general purpose of different types of NoSQL databases.
Data Management Principles
Understand basic principles of organizing and managing data.