Introduction to databases, DBMS concepts, data abstraction, data models, database languages, architectures, users, and overview of data mining, data warehouse, big data, and data analytics.

Database design process, E-R model, constraints, E-R diagrams, and understanding weak and strong entity sets.

Relational model concepts, extended E-R features, specialization, keys, schema design, and E-R to relational model conversion.

Practical SQL operations including database and table management, data types, record manipulation, and constraints.

SQL queries, operators, joins, functions, aggregate functions, GROUP BY, HAVING, and sub-queries.