- 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.
Mohammed Nazar, Maram Qais, Shvan Abdualhkareem, Abdulrahman Khalil.
0. SQL is structured query languages and MySQL is a database management system .
1.Database management system, and the types is NoSQL databases, Document databases, Graph databases.
2. INNER JOIN ,
SELECT ProductID, ProductName, CategoryName FROM Products INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID;
LEFT JOIN ,
SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;
RIGHT JOIN,
SELECT column_name(s) FROM table1 RIGHT JOIN table2 ON table1.column_name = table2.column_name;
FULL JOIN,
SELECT column_name(s) FROM table1 FULL OUTER JOIN table2 ON table1.column_name = table2.column_name WHERE condition;
SELF JOIN.
SELECT column_name(s) FROM table1 T1, table1 T2 WHERE condition;