- 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
0. SQL is a language and MySQL is an open-source database server.
4-
AVG, that calculates the average of the specified columns in a set of rows,
COUNT, calculating the number of rows in a set.
MAX, calculating the maximum,
MIN, calculating the minimum,
STDDEV, calculating the standard deviation,
SUM, calculating the sum,
VARIANCE, calculating the variance.
5-
Group functions are mathematical functions to operate on sets of rows to give one result per set.
6-
a relationship is formed by correlating rows belonging to different tables. A table relationship is established when a child table defines a Foreign Key column that references the Primary Key column of its parent table.