Learn about database architecture and implementation by exploring Structured Query Language (SQL), including topics like file structures and access methods; database modeling, design, and user interface; the components of database management systems; and information storage and retrieval.
Though we may not recognize them in our everyday activities, databases are everywhere. They are hidden behind your online banking profile, airline reservation systems, medical records, and even employment records. This course will provide a general overview of databases, introducing you to database history, modern database systems, the different models used to design a database, and Structured Query Language (SQL), which is the standard language used to access and manipulate databases. Many of the principles of database systems carry over to other areas in computer science, especially operating systems. Databases are often thought of as one of the core computer science topics since many other areas in the discipline have been derived from this area.
- Unit 1: Introduction to Modern Database Systems
- Unit 2: Database Architecture and Date Languages
- Unit 3: Database History
- Unit 4: The Entity-Relationship Model
- Unit 5: The Relational Database Model
- Unit 6: Relational Algebra
- Unit 7: Introduction to Data Normalization
- Unit 8: Introduction to SQL
- Unit 9: Basic Select Statements
- Unit 10: The Join Statement
- Draw a system diagram of a database management system showing its structure and functions;
- Identify the various people involved in database management systems;
- Explain the historical background of database management systems (DBMSes) and relate early DBMS problems and challenges to the current state of DBMS technology;
- Demonstrate the functions of a database management system;
- Develop an entity-relationship model based on user requirements;
- Perform the process of normalization;
- Convert an entity-relationship diagram to a set of normalized relations;
- Explain referential integrity and give an example of relations where it is not satisfied; and
- Use relational algebra to construct queries.