Workshop on “Oracle Database and Administrations”

Expert Details Name: Mr. Manprit Singh Designation:Senior Developer Organization:Techlive Solution

Brief details of the event highlights: Department of Computer Applications, CBSA organized a workshop on “Oracle Database and Administrations” on 16th September, 2022. The aim of this event was to acquaint the audience to make them understand about system level tasks performed by Database and Administrations like installation, configuration, monitoring, tuning, security, etc.

Student Feedback:Students found this workshop very appealing, informative and helpful. They were filled with energy when they discovered how DBA monitor and optimize performance also enhance the slow execution or long running queries.

Faculty Coordinator Name, Designation, Dept.Name& Email ID: Ms.Anuradha Saini, Assistant Professor, DCA, anuradha.4868@cgc.edu.in Ms. Maneet Mander, Assistant Professor, DCA, maneet.4890@cgc.edu.in

Number of participants: Student count- 90 and Faculty count- 8

Learning Outcomes: Students got to know about the DBA importance and their role that contains system level privilege, DBA keeps Database environment up and running. DBA keeps an eye on Database uses, security, etc. DBA grants access to users. DBA's role includes system-level issue troubleshooting, Database Design, migration, Performance, Security, Installation, Configuration, Capacity Planning, backup, Recovery, hardware issue etc. Oracle Database Administration is very important role to perform tasks/jobs on the Database system level.A DBA is well expert and always try to find an alternate way to reduce the load on the production Database. DBA designs a Database in a way that can handle large volumes of data.

This event helped in attaining:

PO6: ProfessionalEthics: Understanding commit professional ethics and cyber regulations, responsibilities and norms of professional computing practices.

PO7: Life-long Learning: Recognize the need, and have the ability, to engage in independent learning for continual development as a computing professional.

PO11: Individual and Team Work: Function effectively as an individual and as a member or leader in diverse teams and in multidisciplinary environments.

PO12: Innovation and Entrepreneurship: Identify a timely opportunity and use innovation to pursue that opportunity to create value and wealth for the better mentor the individual and society at large.

PSO2: Develop techniques to improve skills for life long learning.

PSO3:Develop class environment congenial land competitive for generation of ideas, innovation and sharing.