Course Code: CPAN 121
Academic Year: 2023-2024
The study of database design and management of a database is an essential component of the business IT world today. Using Oracle SQL, the students will apply the design principles to create and develop a working database. This course is designed to help students integrate theoretical material with practical knowledge to implement a database. Students will also use SQL commands to query single and multiple tables. Single and group functions will also be used to enhance queries. Subqueries will be used to enhance data retrieval. Data manipulation of data will also be covered to change the data in the database. We will discuss the connection of an application program to the database to store and retrieve data.