|
Week - 1
|
|
What is a database? Differences from file systems
Database management systems (DBMS)
The concepts of data, information, and metadata
The role of databases in the context of big data |
|
|
Week - 2
|
|
Centralized, client–server, distributed databases
Cloud-based database architectures
OLTP and OLAP systems |
|
|
Week - 3
|
|
Entity-relationship (ER) diagrams
Fundamentals of the relational model (tables, keys, relationships)
The concept of normalization |
|
|
Week - 4
|
|
Introduction to SQL
Data Definition Language (DDL) – CREATE, ALTER, DROP
Data types and creating tables |
|
|
Week - 5
|
|
Data Manipulation Language (DML) – INSERT, UPDATE, DELETE
Data Query Language (SELECT)
WHERE, ORDER BY, GROUP BY, HAVING |
|
|
Week - 6
|
|
JOIN types (INNER, LEFT, RIGHT, FULL)
Subqueries, creating VIEWS
INDEX, TRIGGER, STORED PROCEDURE concepts |
|
|
Week - 7
|
|
Primary key, foreign key, UNIQUE, CHECK constraints
Access control, user management
SQL Injection and data security measures |
|
|
Week - 8
|
|
Query optimization
Indexing strategies
Performance issues in large data sets |
|
|
Week - 9
|
|
Transaction concept, ACID properties
Concurrency control
Backup, recovery, replication |
|
|
Week - 10
|
|
What is NoSQL, and why did it emerge?
NoSQL database types: Key-Value, Document, Column, Graph
RDBMS vs. NoSQL comparison |
|
|
Week - 11
|
|
Applications with MongoDB
Fast data processing with Redis
JSON-based data structures |
|
|
Week - 12
|
|
Cassandra / HBase fundamentals
Graph database applications with Neo4j
Social networks, roadmaps, and relational analysis examples |
|
|
Week - 13
|
|
Data storage on Hadoop and HDFS
Using Hive and HBase
Data processing with Spark SQL |
|
|
Week - 14
|
|
Students develop a mini project based on SQL/NoSQL using a data set they select
Evaluation from a big data analytics perspective
General summary of the course and future technologies |
|