- 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.
@hunny-bee
@mpilomthiyane97
@kokigod
SQL is the Structured Query Language used to create, modify and update databases, whilst MySQL is a database management system that uses SQL
DBMS - Database Management System is a software that interacts with end users, applications, and the database to capture and analyze data. It allows users to create, read, update, and delete data in a database. There are hierarchical, relational, network, object-oriented, document-oriented, graph, etc DBMSs
Inner join - collects rows from both tables that have at least one match.
Left join - returns the matching rows from the right table and the rows from the left table.
Right join - returns rows from the left table that match the rows from the right table.
Full join - returns rows from either of the two tables that match.
A primary key is used to uniquely identify a row in a table
IN: Figures out if a value falls inside a range of values.
BETWEEN: Figures out whether a value falls inside a range of values.
LIKE: looks for a given pattern within a column.
EXISTS: Checks if any rows are returned by another query, preventing duplicates
Group functions help in SQL for summarizing, analyzing, and reporting data efficiently and effectively. They help transform large datasets into meaningful insights and summaries, facilitating better data-driven decision-making.
Relationship is a connection between two or more tables based on one or more columns