Aggregate Function - Allows you to perform a calculation on a set of values to return a single scalar value.
Common Table Expressions (CTE) - They are used within SQL Server to simplify complex joins and subqueries, and to provide a means to query hierarchical data such as an organizational chart.
Composite Key - Combination of more than one field or column of a given table.
Constraints - Used to specify rules for data in a table.
Database Seeding - Initial seeding of a database with data.
Entity Relational Diagram (ERD) - High-level conceptual data model diagram.
Explicit Join - Specified to join two tables.
Full Table Scan - When query has to examine all records on database table.
GROUP BY (Statement) - Groups rows that have the same values into summary rows.
Implicit Join - Specified to perform a left outer join of a table with a field from another table.
Indexes - Special lookup tables that the database search engine can use to speed up data retrieval.
Inner Join (Keyword) - Selects records that have matching values in both tables.
Laravel Tinker - It’s a REPL (read-eval-print loop).
Left Join (Keyword) - Returns all records from the left table (table1), and the matched records from the right table (table2).
Object-Relational Mapping (ORM) – It’s a programming technique for converting data between incompatible type systems using object-oriented programming languages.
Right Join (Keyword) - Returns all records from the right table (table2), and the matched records from the left table (table1).
Surrogate Key - System generated value with no business meaning that is used to uniquely identify a record in a table.
Trigger - A trigger is a stored procedure in a database which automatically invokes whenever a special event in the database occurs.
UNION (Operator) - It’s used to combine the result-set of two or more SELECT statements.
Views - They are virtual tables derived from provided query.