SQL and NoSQL Databases

TEACHING UNIT 1. INTRODUCTION TO DATABASES Basic concepts of databases Advantages of using databases in applications A brief history of Database Management Systems (DBMS) Types of Databases: SQL and NoSQL TEACHING UNIT 2. FUNDAMENTALS OF SQL Introduction to the SQL language Creating databases and tables Inserting and querying data Modifying and deleting data Advanced queries: JOIN operations Data aggregation and grouping functions TEACHING UNIT 3. QUERIES AND SUBQUERIES IN SQL Basic queries: SELECT, FROM, and WHERE Sorting results: the ORDER BY clause Filtering data: the LIKE and IN clauses Using subqueries in SQL Logical operators and combining conditions Query optimization LEARNING UNIT 4. RELATIONAL DATA MODELING Designing relational databases Modeling entities and relationships Database normalization Primary and Foreign Keys One-to-One, One-to-Many, and Many-to-Many Relationships LEARNING UNIT 5. MYSQL Installing and Configuring MySQL Creating and Administering Databases in MySQL Creating and Managing Tables in MySQL Advanced Queries in MySQL Transactions and Concurrency Control in MySQL Indexes and Query Optimization in MySQL LEARNING UNIT 6. MONGODB Introduction to MongoDB and NoSQL Databases Installing and Configuring MongoDB Creating and managing databases in MongoDB Collections and documents in MongoDB Queries and filters in MongoDB Indexes and performance in MongoDB TEACHING UNIT 7. OTHER RELEVANT SQL DBMSs Oracle Database: features and usage PostgreSQL: Features and Use SQL Server: Features and Use Comparison of Relational DBMSs TEACHING UNIT 8. OTHER RELEVANT NOSQL DBMSs Cassandra: Features and Use Redis: Features and Use Neo4j: Features and Use Comparison of NoSQL DBMSs LESSON 9. INTEGRATION OF SQL AND NoSQL DATABASES Advantages of SQL and NoSQL integration Data integration strategies Tools and techniques for integration Use cases for SQL and NoSQL integration