In addition to ERD and DBMS, another fundamental component that played a pivotal role in our project is Structured Query Language, commonly referred to as SQL. This standard query language served as a linchpin for effectively working with the relational databases that our project heavily relied upon.
At its core, SQL provided our engineers with a robust framework to interact with our Database Management System (DBMS). This DBMS, was crucial for managing the organized collection of data, enabling easy access and manipulation. By leveraging SQL, our team was empowered to input and modify data seamlessly, ensuring that the database was always up-to-date and reflective of the latest user interactions and progress.
SQL stands for “Structured Query Language”
A standard query language that is used to work with relational databases.
A relational database management system used in web applications.
Display all columns
SELECT * FROM {tableName}
Display specific columns
SELECT column1, column2 FROM {tableName}
Query data with conditions and operators