Back to events
GUEST_LECTURE
Completed
Data Architecture 101: From Logic To SQL
A guest lecture focused on fundamental data architecture concepts, logical and physical data models, database design, normalization, and SQL-based implementations.
13 February 2026CP LAB-II0 views
Event Date
13 February 2026
Venue
CP LAB-II
Coordinator
not assigned
Status
COMPLETED
Organizer
#guest lecture#data architecture#SQL#database#DBMS#data modeling#normalization#database design
About this event
The guest lecture was organized for II-B.E CSE (A&B), IV Semester students of the Department of Computer Science and Engineering at PPG Institute of Technology. The session focused on understanding logical and physical data models, translating business requirements into structured data models, entity-relationship modeling, database design principles, relational databases, normalization, and SQL implementation. The documented outcomes included designing scalable database structures, normalization decisions, advanced SQL queries involving joins, subqueries and window functions, query performance using indexes and tuning methods, and supporting data warehouses and ETL processes.
The resource person was Mr. Gnansekar Rajagopal, Software Consultant, Coloruyt Group Pvt Ltd, Coimbatore.