Important Topics Studied
- SQL Queries
- DDL an DML queries
- Joins and Subqueries
- Aggregate Functions
- stored procedures and functions
- Window Functions
- OLAP queries
- Relational Algebra
- Normalization and Functional Dependencies
- ERD and Database Design
Project Developed
-
Throughout the course I collaborate with other two students to develop a project consist of 5 deliverables. The project was about the E-newspaper management System like nytimes where we designed the complex ERD of more than 13 tables, wrote SQL queries to create the database and insert the values. Performed various SQL queries on the data to better experiement with what we learned in the class. Finally we created UI and API to interact with the database effectively.
-
We used PostgreSQL and MySQL as the database. Also used the Nodejs and React for backend and frontend respectively.