- 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.
Kgomotso, Selepe, Mpho
SELECT employees.name, departments.department_name
FROM employees
INNER JOIN departments ON employees.department_id = departments.id;
LEFT JOIN (or LEFT OUTER JOIN): Returns all rows from the left table, and the matched rows from the right table. If no match is found, NULL values are returned for columns from the right table.
LEFT JOIN departments ON employees.department_id = departments.id;`
SELECT employees.name, departments.department_name
FROM employeesRIGHT JOIN (or RIGHT OUTER JOIN): Returns all rows from the right table, and the matched rows from the left table. If no match is found, NULL values are returned for columns from the left table.
SELECT employees.name, departments.department_name
FROM employees3.Unique identifier for a record in a relational database table
Arithmetic, Bitwise, Comparison, Compound, Logical and String.
SQL group functions are crucial for data analysis and summarization. With their help, you may process groups of rows based on shared attributes and display the results in a clearer, more understandable manner.
a relationship refers to the connection between two or more tables based on their data. One-to-many, one-to-one, many-to-many