Title Page
విజ్ఞాన శాస్త్ర సాంకేతిక పరిశోధనా సంస్థ / विज्ञान शास्त्र प्रौद्योगिकी और परिशोधन संगठन
Events
Guest Lecture
Database management and data engineering for scalable systems
Mar
4
Tuesday
09:00
AM
- 12:20
PM
Summary
Mr. Raghava Manchala began the lectures by explaining the basics and importance of database management systems. He discussed different types of databases such as SQL, NoSQL, and NewSQL, and explained database architecture and schema design using normalization techniques. In the following sessions, he focused on data storage, indexing methods, and transaction management concepts including ACID properties and concurrency control. He also explained how data pipelines work using ETL processes and introduced tools like Apache Airflow, Kafka, and Data Bricks for managing real-time and batch data processing. Students learned about distributed systems, replication, load balancing, and scalability methods that are used in large-scale applications. The lectures also covered performance optimization techniques such as query tuning, caching, and indexing, along with data security practices like encryption and access control. The sessions included practical demonstrations using SQL Workbench, VS Code, GitHub, and cloud tools. Students also performed hands-on exercises on writing queries, designing ER diagrams, creating triggers, and optimizing queries. Overall, the lectures helped students gain a clear understanding of how databases work in real-world applications and how to build efficient, scalable, and secure data systems.
Read More
About Guest Lecture
The Department of Computer Science and Engineering at Vignan University conducted a Value-Added Course titled Database Management and Data Engineering for Scalable Systems from 4th to 8th March 2025. The sessions were handled by Mr. Raghava Manchala, Data Engineer at Deloitte and Founder and CEO of OrcadeHub. He has over three years of experience in training and corporate education and has mentored many aspiring developers in top institutions. His expertise includes MERN Stack, React Native, C, C++, Python, Java, SQL, and Data Structures. The course aimed to help students understand database management and data engineering concepts used in building scalable and high-performance systems. It covered both SQL and NoSQL databases, data pipelines, and modern tools used in the industry. Students gained hands-on experience in schema design, query optimization, data processing, and cloud-based database management. By the end of the course, students were able to design databases, write SQL queries, apply normalization techniques, and understand transaction management and concurrency control. The course also focused on scalability, distributed systems, and data security. Through real-world case studies and practical sessions, students learned to manage and analyze large datasets effectively. The sessions were interactive and practical, helping students strengthen their knowledge in database systems and data engineering. The workshop provided both theoretical and technical skills, preparing students to design scalable systems used in real-time applications.

Read More
Venue
N Block
Dept.of Computer Science and Engineering
About Speakers
Mr. Raghava Manchala
Data Engineer, Deloitte.
Event Coordinator
Mr.K.Pavan Kumar
Assistant Professor
Contact Us
Vignan's Foundation for Science, Technology and Research
(Deemed to be University), Vadlamudi, Guntur-522213
info@vignan.ac.in
0863-2344700 / 701
Be The First to Know.
Copyrights © 2026 Vignan University. All rights reserved.