"Don't be afraid to change. You may lose something good but you may gain something better" #innerandouterjoin What is an outer join? -When a join returns the unmatched rows as well as the matched rows, it is called an outer join.

"The journey of a thousand miles begins with one step" #normalization What is anomaly? -An error or inconsistencies that may result when a user attempts to update a table that contains redundant data.

"Dont Wait for the right opportunity. Create it." #functionandjoin What is GROUP Functions? -In SQL, the following group functions can operate on a whole table or on a specific grouping of rows, and each function returns one result.

"Don't limit your challenges. Challenge your limits." #dqlSELECT What is a select statement? -The SELECT statement allows you to search for specific data, and it retrieves information from the database.

"If your dreams don't scare you, they are too small" #relationalmodel What is primary keys? -Primary keys are unique identifiers of the relation in question. Examples include employee numbers, social security numbers, etc. This is how we can guarantee that all rows are unique.

"Make your life a masterpiece, imagine no limitations on what you can be, have or do" #eerd What is Total Specialization Rule? -Total Specialization Rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship.

"Don't count the days, make the days count" #erd What is Entity Relationship Model? -A detailed, logical representation of the data for an organization or for a business area. ER Diagram is a graphical representation of an E-R Model.

"A winner is a dreamer who never gives up" #basicsql What is Data Definition Language (DDL)? -Data Definition Language(DDL) commands that define a database, including creating ,altering, and dropping tables and establishing constraints.

"The limits we set become the prison we live in" #databaseconcepts What is Entity Relationship Model? Graphical representation of entities and their relationships in a database structure.

"You make a life out of what you what you have, not what you're missing" #datamodels What is data models? Simple representations of complex real-world data structure Useful for supporting a specific problem domain

The journey of a thousand miles begins with one step #databaseconcepts What is metadata? -Data about data, which the end-user data are integrated and managed and describes data characteristics and relationships.

Nothing is impossible, the word itself says 'I'm possible'! #oracleAPEX What is oracle apex? -Oracle Application Express (APEX) is the tool that we will use to allow you to build tables and retrieve information from an Oracle database.