Intermediate SQL (Glossary)

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.