- 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.What is the difference between SQL and MySQL?
sql is structured query language which is a special kind of tool to deal with the database
2.What do you mean by DBMS? What are its different types?
DBMS stands for database management systems. It’s a system for storing, retrieving data. Its types are; relational and non-relational database.
3.What are the types of joins in SQL? Give an example for each one.
SQL Server supports many kinds of different joins including INNER JOIN, SELF JOIN, CROSS JOIN, and OUTER JOIN. In fact, each join type defines the way two tables are related in a query.A={1,2,3,3} B ={4,5,6,0,2} So inner join is {2}. Outer join is {0,1,2,2,3,3,4,5,6} Self join for A would be {3}. Cross join would be a cartesian join.
4.What is a Primary key? primary key is the column that contain values that uniquely identify each row in a table
5.What are the different operators available in SQL?
Arithmetic operators (+,- etc),logical operators, bitwise operators,compound, comparison, string
6.What is the need for group functions in SQL?
operate on sets of rows to give one result per set
7.What is a Relationship and what are they?
a relationship is formed by correlating rows belonging to different tables. one-to-one, many-to-many and one-to many are its types
Room 2