- 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.
1- SQL is Structured Query Language while mysql is a database system
2- DBMS mean data base management system. MySQL is an example of it. It is a system that allows the user to manage data
Relational Database Management Systems (RDBMS)
NoSQL Databases
In-Memory Databases
Columnar Databases
Document Stores
Graph Databases
Time-Series Databases
NewSQL Databases
3-INNER JOIN: Returns rows when there is a match in both tables.
LEFT JOIN (or LEFT OUTER JOIN): Returns all rows from the left table and matched rows from the right table.
RIGHT JOIN (or RIGHT OUTER JOIN): Returns all rows from the right table and matched rows from the left table.
FULL JOIN (or FULL OUTER JOIN): Returns all rows when there is a match in either table.
SELF JOIN: Returns the Cartesian product of the two tables.
A primary key is a column or a set of columns in a relational database table that uniquely identifies each record (row) in that table. It must contain unique values, and no two rows can have the same primary key value. Additionally, a primary key column cannot contain NULL values.
4-Arithmetic Operators
Comparison Operators
Logical Operators
Compound Operators
bitwise operators
5-Group functions are vital in SQL for doing calculations on groups of rows rather than one row at a time. They help summarize data and create overall results from many rows.
6-Relationships in databases are logical connections between tables based on shared fields. There are four main types:
One-to-One (1:1)
One-to-Many (1:N)
Many-to-One (N:1)
Many-to-Many (N:M)
Rafeef Thamer, Mawj M.Basher, Shkar Gharib