- 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.
Group : Dilan Ahmed | Amal Mohammed | Joan Kareem | Papula Ali
SQL it is a programming language used to interact with the relational database while MySQL is the most well known and popular open source database management system . Also, MySQL uses SQL for data querying.
DBMS is the Database Management System that allows users to interact with the data through a secured system. Also we have a few types of DBMS which are :
Relational DBMS examples: MySQL, PostgreSQL, Oracle Database, Microsoft SQL Server, and SQLite.
NoSQL DBMS examples: MongoDB, Cassandra, and Redis.
Object-Oriented DBMS examples: db4o and ObjectDB.
Hierarchical DBMS examples: Information Management System (IMS) and Windows Registry.
Network DBMS examples: Integrated Data Store (IDS) and CODASYL DBTG
Graph DBMS examples: Neo4j, Amazon Neptune, and TigerGraph.
We have a few types of Joins in SQL :
INER joins
OUTER Joins includes outer left and outer right.
CROSS Joins
SELF Joins .
Primary Key is a unique identifier for each rows in a table that we have.
we have different operators in SQL:
Comparison operators
Arithmetic (math) operators
Set Operators
Aggregate Functions
Assignment Operator
group functions in SQL are used for many different reasons , for example it can be used for summarizing data, statically analyzing data, and grouping data in different sets. this can be done by using MAX MIN or SUM functions to calculate different summarized data or analyzing by using AVG. Also we can use GROUP BY to group data based on specific criteria.
Relationships define how data in one table relates to data in another table. In other words, it is the way a data from a table can be associated with another table having same data , this is very useful in terms of data analysis and filtering in a meaningful way.