Section 1
Preview this deck
Aggregate Functions
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
0
All-time users
0
Favorites
0
Last updated
7 years ago
Date created
Mar 1, 2020
Cards (73)
Section 1
(50 cards)
Aggregate Functions
Built-in functions used to summarize data such as finding the average or sum of a column of values
As
Keyword used to rename a column in a result set
DCL (Data Control Language)
A part of SQL that is used to manage permissions to objects in a database.
Foreign Key
A field in a table that references the primary key in another table.
From
Keyword used to designate which table to query
Keywords
Words that have reserved
Or
Keyword used to combine filtering criteria in which at least one of the criteria must evaluate to true in order for the record to be included in the result set
Select
Keyword used to designate which columns to be returned in a query
GUID
Globally Unique Identifier, a 32 char hexadecimal string with over 1.2 septillion unique values
DBMS (Database Management System)
Software used to store and organize data in a logical and easily retrievable manner.
Is Not Null
Keywords used to select rows where the specified column does not contain a null value
Like
Keyword used to perform a "fuzzy" search and gives us the ability to use wildcards in our search criteria
<> OR
!= Not equal to... <> is ANSI SQL while != is SQL Server specific
Distinct
Keyword used to return only unique values in a result set
SQL (Structured Query Language)
A general language used to interact with relational databases.
Null
An unknown value (null is not 0 nor is null an empty string- null does NOT equal null)
Group By
Keyword used to indicate a column or set of columns in which to bundle values together (and must be used when combining aggregate and non-aggregate values in a select clause)
Statement
A set of SQL clauses that make up a single command set.
Order By
Keyword used to designate the sort order of a result set
Row
a record of related data in a database.
Count()
Built-in aggregate function used to return the total number of values in a column (will ignore null values)
Combination Key
A key made up of two or more non-unique fields that when combined are unique identifier for that row.
Sum()
Built in aggregate function used to calculate the total value of a column in a result set
Primary Key
A unique identifier for a row
Normalization
The process of following a standard set of rules to separate data into logical related groups.
Min()
Built-in aggregate functions used to find the smallest column value in a result set
Count(*)
Built in aggregate function used to return the total number of records in a table (will NOT ignore null values in columns)
Having
Keyword used to filter the results returned based on a group
Between
Keyword used to find values that fall inside a designated range
Where
Keyword used to filter the results returned in an SQL statement
Avg()
Built-in aggregate function used to calculate the average column value in a result set
Coalesce
Built in function used to convert a null value to some other specified value in the result set.
And
Keyword used to combine filtering criteria in which both of the criteria must evaluate to true in order for the record to be included in the result set
*
Identifier used to indicate that all columns should be returned in the result set
NullIf
Built in function used to convert a specified value to a null in the result set.
One-to-Many
The most common relationship type where one record in a table relates to many records in another table.
= <
> <= => Just like in math... equal, less than, greater then, less than or equal to, greater than or equal to
DML (Data Manipulation Language)
A part of SQL that is used query, insert, update and remove data from a database.
Identifiers
Words used to reference database objects such as tables, columns, etc
Clause
A portion of an SQL that begins with a keyword.
TCL (Transaction Control Language)
A part of SQL that is used to manage different transactions occurring within a database.
Column
A set of data having all the same datatypes in a table spanning all rows (records).
Is Null
Keywords used to select rows where the specified column contains a null value
Table
A container in a database made up of columns and rows to hold data.
SQL Server Management Studio
The IDE used to interact with Microsoft's commercial database management system SQL Server.
One-to-One
One record in a table relates to only one record in another table.
In
Keyword used to indicate a specified set of values to be compared against
Max()
Built-in aggregate function used to find the largest column value in a result set
Derived Column
A column that is created as a result of an arithmetic calculation or the use of a function.
DDL (Data Definition Language)
A part of SQL that is used to create and modify objects of a database such as tables, views, functions and stored procedures.
Section 2
(23 cards)