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.

Escribe tu comentario
+ 2