- 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.
Jana AbuHaltam, Musab Sakhreyah, Ahmad Mash, Lina Abumahfood ,Rinad Abu Qauod
Q0.SQL is a query programming language . MySQL is a relational database management system that uses SQL.
Q1 (DBMS) is a computer program designed to manage a large amount of structured data, and run operations on the desired data requested by the users.types include integer, float, characters, strings, and arrays.
Q2 Different Types of SQL JOINs (INNER) JOIN : Returns records that have matching values in both tables.
LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
RIGHT (OUTER) JOIN : Returns all records from the right table, and the matched records from the left table.
Q3 A primary key is the column or columns that contain values that uniquely identify each row in a table
Q4 1) Arithmetic Operators:
/ (Division)
% (Modulus)
= (Equal to)
!= or <> (Not equal to)
< (Less than)
Logical Operators:
AND (Logical AND)
OR (Logical OR)
NOT (Logical NOT)
Bitwise Operators:
• Perform operations on bit patterns of integer values.
• Operators: & (bitwise AND), | (bitwise OR), ^ (bitwise XOR), ~ (bitwise NOT), << (left shift), >> (right shift)
String Operators:
• Manipulate and compare string values.
• Operators: || (concatenation), LIKE (pattern matching)
Compound Operators:
• Combine assignment and arithmetic or bitwise operations.
• Operators: +=, -=, *=, /=, %=, &=, |=, ^=, <<=, >>=
Other Operators:
• BETWEEN: Checks if a value is within a specified range.
• IN: Checks if a value is present in a list of values.
• IS NULL: Checks if a value is null.
• EXISTS: Checks if a subquery returns any rows.
Q5 1. Summarizing Data
2. Data Analysis
3. Statistical Calculations
4. Data Reporting
5. Performance Optimization
6. Efficient Data Retrieval
Q6 a relationship refers to the connection between two or more tables in a relational database. These relationships define how data in one table is related to data in another table.
Rinad Abu Qauod 6:37 PM
6- a relationship refers to the connection between two or more tables in a relational database. These relationships define how data in one table is related to data in another table.
There are three main types of relationships:
1- One-to-One (1:1) Relationship
2- One-to-Many (1:N) Relationship
3- Many-to-Many (N:N) Relationship