"Endure the pain and you will see the result"
#innerandouterjoin
Question: what is inner and outer join
Answer: Only those records are chosen using an inner join when the values in both tables match. Even if the values in the two tables do not match.
"The rider who suffers the most is the most likely to win the race"
#normalization
Question: What is normalization
Answer: Normalization is a database design approach that devides information into tables.
A:Based on a shared column between two or more columns, a JOIN clause is used to merge rows from those tables.Each function produces a single result and may be used to act on the entire table or a specified subset of entries
"When it's hurting you, that's when you can make a difference"
#eerd
Question: Definition of entity supertype
Answer: It is a sort of entity in which it is the subject of all connections with one or more subtypes.
"Never stay the same always try to improve"
#erd
Question: How are erd used?
Answer: to make a data store's content visible.
#basicsql
Question: What is an update statement
Answer: it is altered data in already existing rows.
"You can only change things when they are hurting you"
#datamodels
Question: The significance of data models
Answer: Establishes a focal point for deciding on scope
#basicsql
Question: Meaning of DMBS
Answer: Database Management System
We did our best however we did complete everything on the list. Just keep working and stop complaining, and everything will be done.
#databaseconcepts
Question: Is database fundamentals primary source?
Answer: Yes
#oracleAPEX
Question: Is an Oracle Apex workshop?
Answer: Yes