Wildcards and Strings
The wildcard used to include results from all columns in a table.
What is the *?
Each table has a unique identifier such as the GroupId in the Groups table.
This is the unique identifier for the Stations table.
What is StationId?
The keyword used to tie two tables together.
What is Join?
Illustration of intersecting circles that shows how a data set relates to other data sets.
What is a Venn Diagram?
What is a Data Set?
The wildcard used to represent one or more characters in a string.
What is %?
The name of the table that ties Stations to Machines
What is StationMachines?
The keyword to provide matching criteria when performing a join
What is 'On'?
Only the data that is shared by all data sets (Everything in between)
What is an 'Intersection'?
One of four types of SQL which is used to ask questions.
What is Data Query Language (DQL)?
The characters used to denote a string in a SQL query.
What are single quotes ' ' ?
The unique identifier that ties the Machines table with the MachineMetaData, LoginHistory, and Nics tables
What is MachineId?
A pseudonym or alias representing a table name when including multiple tables in a query.
What is a 'Table Alias'?
Everything outside of the data set.
What is a 'Complement'?
The two clauses of the select statement that are required.
What are the Select and From clauses?
The query to search for a Machine with a Hostname that begins with Math
SELECT * FROM Machines
WHERE Hostname like 'Math%'
The column you would look at in the Groups table to identify if the group belongs to a parent group.
What is 'ParentId'?
A query to return the Station Name and Group Name for all stations.
SELECT Stations.StationName, Groups.GroupName
FROM Stations
JOIN Groups
ON Groups.GroupId = Stations.GroupId
Everything in the first data set that is not also in the second data set.
What is a 'Difference'?
An additional clause in a SQL query that is used to filter the results in conjunction with an aggregate function such as Count.
What is the 'having' clause?