Introduction to Database and SQL

Course Code: ITC 5104

Academic Year: 2022-2023

The study of database design and management is an essential component of the IT business world today. Through this course, the student will gain a background in database design. The student will work with entity-relationship diagrams (ERD) to learn and implement basic database design. Using Oracle SQL, the students will apply the design principles to actually 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. Sub-queries will be used to enhance data retrieval. Date 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.