|
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 |
Anadolu Info Package 
Turkish 
English