- What is the difference between SQL and MySQL?
- What do you mean by DBMS? What are its different types?
- What are the types of joins in SQL? Give an example for each one.
- What is a Primary key?
- What are the different operators available in SQL?
- What is the need for group functions in SQL?
- What is a Relationship and what are they?
Please discuss these questions with your partners and post your answers as a comment on this gist when you are finished.
Room 5: Belal, Ahmad Shalash, Mo'mena
0. What is the difference between SQL and MySQL?
SQL is a standardized language for managing data in relational databases, while MySQL is a relational database management system that uses SQL to manage data.
The main differences are:
1. What do you mean by DBMS? What are its different types?
DBMS is database management system software for defining, storing, managing, and querying data.
Types:
2. What are the types of joins in SQL? Give an example for each one.
3. What is a Primary key?
it's a column in a relational database that contains unique identifiers/key for each item/value/row of data in the database
4. What are the different operators available in SQL?
SQL operator is a special word or character used to perform tasks. There are six types of SQL operators:
5. What is the need for group functions in SQL?
Group functions in SQL are used to perform operations on a set of rows and return a single value. They are used to aggregate, calculate, and summarize data from multiple rows into a single result.
Group functions are useful for analyzing and summarizing data in a database.
6. What is a Relationship and what are they?
In the context of databases, a relationship refers to the connection between two or more tables. Relationships are used to link data in different tables together, allowing you to access and manipulate related data in a structured and organized way.
types of relationships: