# on 12-Nov-2019 (Tue)

#### Annotation 4529957244172

 Art. 64. A ordem de pagamento é o despacho exarado por autoridade competente, determinando que a despesa seja paga.

#### pdf

cannot see any pdfs

#### Flashcard 4536022732044

Question
Write down the simplest SELECT syntax ?
SELECT expressions FROM tables [WHERE conditions];

status measured difficulty not learned 37% [default] 0
SQL Server: SELECT Statement
SELECT statement is used to retrieve records from one or more tables in a SQL Server database. Syntax In its simplest form, the syntax for the SELECT statement in SQL Server (Transact-SQL) is: <span>SELECT expressions FROM tables [WHERE conditions]; However, the full syntax for the SELECT statement in SQL Server (Transact-SQL) is: SELECT [ ALL | DISTINCT ] [ TOP (top_value) [ PERCENT ] [ WITH TIES ] ] expressions FROM tables [WHERE

#### Flashcard 4536025091340

Question
Write doen the syntax for a complex SELECT syntax ?
SELECT [ ALL | DISTINCT ] [ TOP (top_value) [ PERCENT ] [ WITH TIES ] ] expressions FROM tables [WHERE conditions] [GROUP BY expressions] [HAVING condition] [ORDER BY expression [ ASC | DESC ]];

status measured difficulty not learned 37% [default] 0
SQL Server: SELECT Statement
x for the SELECT statement in SQL Server (Transact-SQL) is: SELECT expressions FROM tables [WHERE conditions]; However, the full syntax for the SELECT statement in SQL Server (Transact-SQL) is: <span>SELECT [ ALL | DISTINCT ] [ TOP (top_value) [ PERCENT ] [ WITH TIES ] ] expressions FROM tables [WHERE conditions] [GROUP BY expressions] [HAVING condition] [ORDER BY expression [ ASC | DESC ]]; Parameters or Arguments ALL Optional. Returns all matching rows. DISTINCT Optional. Removes duplicates from the result set. Learn more about the DISTINCT clause TOP (top_value) Optional

#### Flashcard 4536027712780

Tags
#SQL #Server #Technet #Transact
Question
Example - Select all fields from one table from table inventory with quantity > 5 and sort the results in ascending order ordered b< inventory_id
SELECT * FROM inventory WHERE quantity > 5 ORDER BY inventory_id ASC;

status measured difficulty not learned 37% [default] 0
SQL Server: SELECT Statement
ASC sorts in ascending order and DESC sorts in descending order. Example - Select all fields from one table Let's look at how to use a SQL Server SELECT query to select all fields from a table. <span>SELECT * FROM inventory WHERE quantity > 5 ORDER BY inventory_id ASC; In this SQL Server SELECT statement example, we've used * to signify that we wish to select all fields from the inventory table where the quantity is greater than 5. The result set is s

#### Flashcard 4536029547788

Tags
#SQL #Server #Technet #Transact
Question
Example - Select all fields from one table

Example - Select all fields from one table

Let's look at how to use a SQL Server SELECT query to select all fields from a table.

 SELECT *
FROM inventory
WHERE quantity > 5 ORDER BY inventory_id ASC; 

status measured difficulty not learned 37% [default] 0
SQL Server: SELECT Statement
rows to only those whose the condition is TRUE. ORDER BY expression Optional. It is used to sort the records in your result set. ASC sorts in ascending order and DESC sorts in descending order. <span>Example - Select all fields from one table Let's look at how to use a SQL Server SELECT query to select all fields from a table. SELECT * FROM inventory WHERE quantity > 5 ORDER BY inventory_id ASC; In this SQL Server SELECT statement example, we've used * to signify that we wish to select all fields from the inventory table where the quantity is greater than 5. The result set is s

#### Flashcard 4536031382796

Tags
#SQL #Server #Technet #Transact
Question

## Example - Select individual fields from one table

Example - Select individual fields from one table

You can also use the SQL Server SELECT statement to select individual fields from the table, as opposed to all fields from the table.

For example:

SELECT inventory_id, inventory_type, quantity
FROM inventory
WHERE inventory_id >= 555
AND inventory_type = 'Software'
ORDER BY quantity DESC, inventory_id ASC;

status measured difficulty not learned 37% [default] 0
SQL Server: SELECT Statement
nt example, we've used * to signify that we wish to select all fields from the inventory table where the quantity is greater than 5. The result set is sorted by inventory_id in ascending order. <span>Example - Select individual fields from one table You can also use the SQL Server SELECT statement to select individual fields from the table, as opposed to all fields from the table. For example: SELECT inventory_id, inventory_type, quantity FROM inventory WHERE inventory_id >= 555 AND inventory_type = 'Software' ORDER BY quantity DESC, inventory_id ASC; This SQL Server SELECT example would return only the inventory_id, inventory_type, and quantity fields from the inventory table where the inventory_id is greater than or equal to 555 an

#### Flashcard 4536033217804

Tags
#SQL #Server #Technet #Transact
Question
Example - Select fields from multiple tables

Example - Select fields from multiple tables

You can also use the SQL Server SELECT statement to retrieve fields from multiple tables by using a join.

For example:

SELECT inventory.inventory_id, products.product_name, inventory.quantity
FROM inventory
INNER JOIN products
ON inventory.product_id = products.product_id
ORDER BY inventory_id;

status measured difficulty not learned 37% [default] 0
SQL Server: SELECT Statement
ble where the inventory_id is greater than or equal to 555 and the inventory_type is 'Software'. The results are sorted by quantity in descending order and then inventory_id in ascending order. <span>Example - Select fields from multiple tables You can also use the SQL Server SELECT statement to retrieve fields from multiple tables by using a join. For example: SELECT inventory.inventory_id, products.product_name, inventory.quantity FROM inventory INNER JOIN products ON inventory.product_id = products.product_id ORDER BY inventory_id; This SQL Server SELECT example joins two tables together to gives us a result set that displays the inventory_id, product_name, and quantity fields where the product_id value matches in

#### Flashcard 4536035052812

Tags
#SQL #Server #Technet #Transact
Question
Example - Using TOP keyword

Example - Using TOP keyword

Let's look at a SQL Server example, where we use the TOP keyword in the SELECT statement.

For example:

SELECT TOP(3)
inventory_id, inventory_type, quantity
FROM inventory
WHERE inventory_type = 'Software'
ORDER BY inventory_id ASC;

status measured difficulty not learned 37% [default] 0
SQL Server: SELECT Statement
plays the inventory_id, product_name, and quantity fields where the product_id value matches in both the inventory and products table. The results are sorted by inventory_id in ascending order. <span>Example - Using TOP keyword Let's look at a SQL Server example, where we use the TOP keyword in the SELECT statement. For example: SELECT TOP(3) inventory_id, inventory_type, quantity FROM inventory WHERE inventory_type = 'Software' ORDER BY inventory_id ASC; This SQL Server SELECT example would select the first 3 records from the inventory table where the inventory_type is 'Software'. If there are other records in the inventory table that h

#### Flashcard 4536036887820

Tags
#SQL #Server #Technet #Transact
Question
Example - Using TOP PERCENT keyword

Example - Using TOP PERCENT keyword

Let's look at a SQL Server example, where we use the TOP PERCENT keyword in the SELECT statement.

For example:

SELECT TOP(10) PERCENT
inventory_id, inventory_type, quantity
FROM inventory
WHERE inventory_type = 'Software'
ORDER BY inventory_id ASC;

status measured difficulty not learned 37% [default] 0
SQL Server: SELECT Statement
able where the inventory_type is 'Software'. If there are other records in the inventory table that have a inventory_type value of 'Software', they will not be returned by the SELECT statement. <span>Example - Using TOP PERCENT keyword Let's look at a SQL Server example, where we use the TOP PERCENT keyword in the SELECT statement. For example: SELECT TOP(10) PERCENT inventory_id, inventory_type, quantity FROM inventory WHERE inventory_type = 'Software' ORDER BY inventory_id ASC; This SQL Server SELECT example would select the first 10% of the records from the full result set. So in this example, the SELECT statement would return the top 10% of records from the

#### Flashcard 4536041344268

Tags
#Clause #FROM #SQL #Server #Transact
Question
FROM clause in SQL Server

The syntax for the FROM clause in SQL Server (Transact-SQL) is:

FROM table1
[ { INNER JOIN | LEFT OUTER JOIN | RIGHT OUTER JOIN | FULL OUTER JOIN } table2
ON table1.column1 = table2.column1 ]

status measured difficulty not learned 37% [default] 0
SQL Server: FROM Clause
n SQL Server (Transact-SQL) with syntax and examples. Description The SQL Server (Transact-SQL) FROM clause is used to list the tables and any joins required for the query in SQL Server. Syntax <span>The syntax for the FROM clause in SQL Server (Transact-SQL) is: FROM table1 [ { INNER JOIN | LEFT OUTER JOIN | RIGHT OUTER JOIN | FULL OUTER JOIN } table2 ON table1.column1 = table2.column1 ] Parameters or Arguments table1 and table2 The tables used in the SQL statement. The two tables are joined based on table1.column1 = table2.column1. Note There must be at least one table

#### Flashcard 4536043179276

Tags
#Clause #FROM #SQL #Server #Transact
Question
FROM clause with one table
SELECT * FROM employees WHERE first_name = 'Jane';

status measured difficulty not learned 37% [default] 0
SQL Server: FROM Clause
It is difficult to explain the syntax for the SQL Server FROM clause, so let's look at some examples. We'll start by looking at how to use the FROM clause with only a single table. For example: <span>SELECT * FROM employees WHERE first_name = 'Jane'; In this SQL Server FROM clause example, we've used the FROM clause to list the table called employees. There are no joins performed since we are only using one table. Example - Two tabl

#### Flashcard 4536045014284

Tags
#Clause #FROM #SQL #Server #Transact
Question
From clause with two tables

Example - Two tables with INNER JOIN

Let's look at how to use the FROM clause with two tables and an INNER JOIN.

For example:

SELECT suppliers.supplier_id, suppliers.supplier_name, orders.order_date
FROM suppliers INNER JOIN orders
ON suppliers.supplier_id = orders.supplier_id;

status measured difficulty not learned 37% [default] 0
SQL Server: FROM Clause
WHERE first_name = 'Jane'; In this SQL Server FROM clause example, we've used the FROM clause to list the table called employees. There are no joins performed since we are only using one table. <span>Example - Two tables with INNER JOIN Let's look at how to use the FROM clause with two tables and an INNER JOIN . For example: SELECT suppliers.supplier_id, suppliers.supplier_name, orders.order_date FROM suppliers INNER JOIN orders ON suppliers.supplier_id = orders.supplier_id; This SQL Server FROM clause example uses the FROM clause to list two tables - suppliers and orders. And we are using the FROM clause to specify an INNER JOIN between the suppliers and o

#### Flashcard 4536046849292

Tags
#Clause #FROM #SQL #Server #Transact
Question
FROM clause with OUTER JOINS

Example - Two Tables with OUTER JOIN

Let's look at how to use the FROM clause when we join two tables together using an OUTER JOIN. In this case, we will look at the LEFT OUTER JOIN.

For example:

SELECT employees.employee_id, contacts.last_name
FROM employees
LEFT OUTER JOIN contacts
ON employees.employee_id = contacts.contact_id
WHERE employees.first_name = 'Sarah';

This SQL Server FROM clause example uses the FROM clause to list two tables - employees and contacts. And we are using the FROM clause to specify a LEFT OUTER JOIN between the employees and contacts tables based on the employee_id column in both tables.

status measured difficulty not learned 37% [default] 0
SQL Server: FROM Clause

#### Flashcard 4536049995020

Question

DO THIS !

SQL Server WHERE clause example uses the WHERE clause to join multiple tables together in a single SELECT statement. This SELECT statement would return all rows where the first_name in the employees table is 'Sarah'. And the employees and contacts tables are joined on the employee_id from the employees table and the contact_id from the contacts table.

Example - Joining Tables

Let's look at how to use the WHERE clause when we join multiple tables together.

For example:

SELECT employees.employee_id, contacts.last_name
FROM employees
INNER JOIN contacts
ON employees.employee_id = contacts.contact_id
WHERE employees.first_name = 'Sarah';

This SQL Server WHERE clause example uses the WHERE clause to join multiple tables together in a single SELECT statement. This SELECT statement would return all rows where the first_name in the employees table is 'Sarah'. And the employees and contacts tables are joined on the employee_id from the employees table and the contact_id from the contacts table.

status measured difficulty not learned 37% [default] 0
SQL Server: WHERE Clause

#### Flashcard 4536054451468

Question

Traditionally write this SQL as follows using a proper INNER JOIN.

DO THIS

shows how the AND condition can be used to join multiple tables in a SELECT statement.

Our next SQL Server AND example shows how the AND condition can be used to join multiple tables in a SELECT statement.

For example:

SELECT employees.employee_id, contacts.last_name
FROM employees, contacts
WHERE employees.employee_id = contacts.contact_id
AND employees.first_name = 'Sarah';

Though the above SQL works just fine, you would more traditionally write this SQL as follows using a proper INNER JOIN.

status measured difficulty not learned 37% [default] 0
SQL Server: AND Condition
ame of 'Smith' and have an employee_id less than 499. Because the * is used in the SELECT statement, all fields from the employees table would appear in the result set. Example - JOINING Tables <span>Our next SQL Server AND example shows how the AND condition can be used to join multiple tables in a SELECT statement. For example: SELECT employees.employee_id, contacts.last_name FROM employees, contacts WHERE employees.employee_id = contacts.contact_id AND employees.first_name = 'Sarah'; Though the above SQL works just fine, you would more traditionally write this SQL as follows using a proper INNER JOIN. For example: SELECT employees.employee_id, contacts.last_name FROM employees INNER JOIN contacts ON employees.employee_id = contacts.contact_id WHERE employees.first_name = 'Sarah'; Thi

#### Flashcard 4536057072908

Question

DO:

This SQL Server AND condition example would return all rows where the first_name in the employees table is 'Sarah'. And the employees and contacts tables are joined on the employee_id from the employees table and the contact_id from the contacts table. You will notice that all of the fields are prefixed with the table names (ie: contacts.last_name). This is required to eliminate any ambiguity as to which field is being referenced; as the same field name can exist in both the employees and the contacts tables.

In this case, the result set would only display the employee_id and last_name fields (as listed in the first part of the SELECT statement.).

SELECT employees.employee_id, contacts.last_name
FROM employees
INNER JOIN contacts
ON employees.employee_id = contacts.contact_id
WHERE employees.first_name = 'Sarah';

This SQL Server AND condition example would return all rows where the first_name in the employees table is 'Sarah'. And the employees and contacts tables are joined on the employee_id from the employees table and the contact_id from the contacts table. You will notice that all of the fields are prefixed with the table names (ie: contacts.last_name). This is required to eliminate any ambiguity as to which field is being referenced; as the same field name can exist in both the employees and the contacts tables.

In this case, the result set would only display the employee_id and last_name fields (as listed in the first part of the SELECT statement.).

status measured difficulty not learned 37% [default] 0
SQL Server: AND Condition
id = contacts.contact_id AND employees.first_name = 'Sarah'; Though the above SQL works just fine, you would more traditionally write this SQL as follows using a proper INNER JOIN. For example: <span>SELECT employees.employee_id, contacts.last_name FROM employees INNER JOIN contacts ON employees.employee_id = contacts.contact_id WHERE employees.first_name = 'Sarah'; This SQL Server AND condition example would return all rows where the first_name in the employees table is 'Sarah'. And the employees and contacts tables are joined on the employee_id from the employees table and the contact_id from the contacts table. You will notice that all of the fields are prefixed with the table names (ie: contacts.last_name). This is required to eliminate any ambiguity as to which field is being referenced; as the same field name can exist in both the employees and the contacts tables. In this case, the result set would only display the employee_id and last_name fields (as listed in the first part of the SELECT statement.). Example - With INSERT Statement This next SQL Server AND example demonstrates how the AND condition can be used in the INSERT statement . For example: INSERT INTO contacts (contact_id,

#### Flashcard 4536058907916

Question

DO:

This SQL Server AND condition example would insert into the contacts table, all employee_id, last_name, and first_name records from the employees table where the first_name is 'Joanne' and the employee_id is greater than or equal to 800.

INSERT INTO contacts
(contact_id, last_name, first_name)
SELECT employee_id, last_name, first_name
FROM employees
WHERE first_name = 'Joanne'
AND employee_id >= 800;

This SQL Server AND condition example would insert into the contacts table, all employee_id, last_name, and first_name records from the employees table where the first_name is 'Joanne' and the employee_id is greater than or equal to 800.

status measured difficulty not learned 37% [default] 0
SQL Server: AND Condition
the first part of the SELECT statement.). Example - With INSERT Statement This next SQL Server AND example demonstrates how the AND condition can be used in the INSERT statement . For example: <span>INSERT INTO contacts (contact_id, last_name, first_name) SELECT employee_id, last_name, first_name FROM employees WHERE first_name = 'Joanne' AND employee_id >= 800; This SQL Server AND condition example would insert into the contacts table, all employee_id, last_name, and first_name records from the employees table where the first_name is 'Joanne' and the employee_id is greater than or equal to 800. Example - With UPDATE Statement This SQL Server AND condition example shows how the AND condition can be used in the UPDATE statement . For example: UPDATE employees SET last_name = 'Jo

#### Flashcard 4536060742924

Question

DO THIS:

This SQL Server AND condition example would insert into the contacts table, all employee_id, last_name, and first_name records from the employees table where the first_name is 'Joanne' and the employee_id is greater than or equal to 800.

For example:

UPDATE employees
SET last_name = 'Johnson'
WHERE last_name = 'TBD'
AND employee_id < 300;

This SQL Server AND condition example would update all last_name values in the employees table to 'Johnson' where the last_name is 'TBD' and the employee_id is less than 300.

status measured difficulty not learned 37% [default] 0
SQL Server: AND Condition
nne' and the employee_id is greater than or equal to 800. Example - With UPDATE Statement This SQL Server AND condition example shows how the AND condition can be used in the UPDATE statement . <span>For example: UPDATE employees SET last_name = 'Johnson' WHERE last_name = 'TBD' AND employee_id < 300; This SQL Server AND condition example would update all last_name values in the employees table to 'Johnson' where the last_name is 'TBD' and the employee_id is less than 300. Example - With DELETE Statement Finally, this last SQL Server AND example demonstrates how the AND condition can be used in the DELETE statement . For example: DELETE FROM employees WHE

#### Flashcard 4536062577932

Question

DO THIS:

This SQL Server AND condition example would insert into the contacts table, all employee_id, last_name, and first_name records from the employees table where the first_name is 'Joanne' and the employee_id is greater than or equal to 800.

DELETE FROM employees
WHERE first_name = 'Darlene'
AND last_name = 'Henderson';

This SQL Server AND condition example would delete all records from the employees table whose first_name is 'Darlene' and last_name is 'Henderson'.

status measured difficulty not learned 37% [default] 0
SQL Server: AND Condition

#### Flashcard 4536065723660

Question

DO THIS:

This SQL Server IN condition example would return all rows from the employees table where the last_name is either 'Smith', 'Anderson', or 'Johnson'. Because the * is used in the SELECT, all fields from the employees table would appear in the result set.

SELECT *
FROM employees
WHERE last_name IN ('Smith', 'Anderson', 'Johnson');

This SQL Server IN condition example would return all rows from the employees table where the last_name is either 'Smith', 'Anderson', or 'Johnson'. Because the * is used in the SELECT, all fields from the employees table would appear in the result set.

status measured difficulty not learned 37% [default] 0
SQL Server: IN Condition
r. Example - With string Let's look at a SQL Server IN condition example using string values. The following is a SQL Server SELECT statement that uses the IN condition to compare string values: <span>SELECT * FROM employees WHERE last_name IN ('Smith', 'Anderson', 'Johnson'); This SQL Server IN condition example would return all rows from the employees table where the last_name is either 'Smith', 'Anderson', or 'Johnson'. Because the * is used in the SELECT, all fields from the employees table would appear in the result set. The above IN example is equivalent to the following SELECT statement: SELECT * FROM employees WHERE last_name = 'Smith' OR last_name = 'Anderson' OR last_name = 'Johnson'; As you can se

#### Flashcard 4536068082956

Question

DO THIS:

This SQL Server IN condition example would return all rows from the employees table where the first_name is not 'Sarah', 'John', or 'Dale' Sometimes, it is more efficient to list the values that you do not want, as opposed to the values that you do want.

SELECT *
FROM employees
WHERE first_name NOT IN ('Sarah', 'John', 'Dale');

This SQL Server IN condition example would return all rows from the employees table where the first_name is not 'Sarah', 'John', or 'Dale' Sometimes, it is more efficient to list the values that you do not want, as opposed to the values that you do want.

status measured difficulty not learned 37% [default] 0
SQL Server: IN Condition
yee_id = 2 OR employee_id = 3 OR employee_id = 4 OR employee_id = 10; Example - Using NOT operator Finally, let's look at an IN condition example using the SQL Server NOT operator. For example: <span>SELECT * FROM employees WHERE first_name NOT IN ('Sarah', 'John', 'Dale'); This SQL Server IN condition example would return all rows from the employees table where the first_name is not 'Sarah', 'John', or 'Dale' Sometimes, it is more efficient to list the values that you do not want, as opposed to the values that you do want. The above IN example is equivalent to the following SELECT statement: SELECT * FROM employees WHERE first_name <> 'Sarah' AND first_name <> 'John' AND first_name <> 'D

#### Flashcard 4536071228684

Question

LIKE Pattern

Wildcard Explanation ?

WildcardExplanation
%Allows you to match any string of any length (including zero length)
_Allows you to match on a single character
[ ]Allows you to match on any character in the [ ] brackets (for example, [abc] would match on a, b, or c characters)
[^]Allows you to match on any character not in the [^] brackets (for example, [^abc] would match on any character that is not a, b, or c characters)

status measured difficulty not learned 37% [default] 0
SQL Server: LIKE Condition
] Parameters or Arguments expression A character expression such as a column or field. pattern A character expression that contains pattern matching. The patterns that you can choose from are: <span>Wildcard Explanation % Allows you to match any string of any length (including zero length) _ Allows you to match on a single character [ ] Allows you to match on any character in the [ ] brackets (for example, [abc] would match on a, b, or c characters) [^] Allows you to match on any character not in the [^] brackets (for example, [^abc] would match on any character that is not a, b, or c characters) escape_character Optional. It allows you to test for literal instances of a wildcard character such as % or _. Example - Using % wildcard (percent sign wildcard) The first SQL Server LI

#### Flashcard 4536073587980

Question
LIKE condition example, we are looking for all employees whose last_name contains the letter 'o'.
SELECT *
FROM employees
WHERE last_name LIKE '%o%';

In this SQL Server LIKE condition example, we are looking for all employees whose last_name contains the letter 'o'.

status measured difficulty not learned 37% [default] 0
SQL Server: LIKE Condition
employees whose last_name begins with 'B'. For example: SELECT * FROM employees WHERE last_name LIKE 'B%'; You can also using the % wildcard multiple times within the same string. For example, <span>SELECT * FROM employees WHERE last_name LIKE '%o%'; In this SQL Server LIKE condition example, we are looking for all employees whose last_name contains the letter 'o'. Example - Using _ wildcard (underscore wildcard) Next, let's explain how the _ wildcard (underscore wildcard) works in the SQL Server LIKE condition. Remember that _ wildcard is looking

#### Flashcard 4536075422988

Question
LIKE condition example would return all employees whose first_name is 4 characters long, where the first two characters is 'Ad' and the last character is 'm'. For example, it could return employees whose first_name is 'Adam', 'Adem', 'Adim', 'Adom', 'Adum', etc.
SELECT *
FROM employees
WHERE first_name LIKE 'Ad_m';

This SQL Server LIKE condition example would return all employees whose first_name is 4 characters long, where the first two characters is 'Ad' and the last character is 'm'. For example, it could return employees whose first_name is 'Adam', 'Adem', 'Adim', 'Adom', 'Adum', etc.

status measured difficulty not learned 37% [default] 0
SQL Server: LIKE Condition
nderscore wildcard) Next, let's explain how the _ wildcard (underscore wildcard) works in the SQL Server LIKE condition. Remember that _ wildcard is looking for only one character. For example: <span>SELECT * FROM employees WHERE first_name LIKE 'Ad_m'; This SQL Server LIKE condition example would return all employees whose first_name is 4 characters long, where the first two characters is 'Ad' and the last character is 'm'. For example, it could return employees whose first_name is 'Adam', 'Adem', 'Adim', 'Adom', 'Adum', etc. Here is another example: SELECT * FROM employees WHERE employee_number LIKE '123_'; You might find that you are looking for an employee_number, but you only have 3 of the 4 digits. The

#### Flashcard 4536077257996

Question

You might find that you are looking for an employee_number, but you only have 3 of the 4 digits. The example above, would retrieve potentially 10 records back (where the missing value could equal anything from 0 to 9). For example, it could return employees whose employee numbers are:

1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239

SELECT *
FROM employees
WHERE employee_number LIKE '123_';

You might find that you are looking for an employee_number, but you only have 3 of the 4 digits. The example above, would retrieve potentially 10 records back (where the missing value could equal anything from 0 to 9). For example, it could return employees whose employee numbers are:

1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239

status measured difficulty not learned 37% [default] 0
SQL Server: LIKE Condition
the first two characters is 'Ad' and the last character is 'm'. For example, it could return employees whose first_name is 'Adam', 'Adem', 'Adim', 'Adom', 'Adum', etc. Here is another example: <span>SELECT * FROM employees WHERE employee_number LIKE '123_'; You might find that you are looking for an employee_number, but you only have 3 of the 4 digits. The example above, would retrieve potentially 10 records back (where the missing value could equal anything from 0 to 9). For example, it could return employees whose employee numbers are: 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239 Example - Using [ ] wildcard (square brackets wildcard) Next, let's explain how the [ ] wildcard (square brackets wildcard) works in the SQL Server LIKE condition. Remember that what is

#### Flashcard 4536079093004

Question
This SQL Server LIKE condition example would return all employees whose first_name is 5 characters long, where the first two characters is 'Sm' and the last two characters is 'th', and the third character is either 'i' or 'y'. So in this case, it would match on either 'Smith' or 'Smyth'.
SELECT *
FROM employees
WHERE first_name LIKE 'Sm[iy]th';

This SQL Server LIKE condition example would return all employees whose first_name is 5 characters long, where the first two characters is 'Sm' and the last two characters is 'th', and the third character is either 'i' or 'y'. So in this case, it would match on either 'Smith' or 'Smyth'.

status measured difficulty not learned 37% [default] 0
SQL Server: LIKE Condition
ldcard (square brackets wildcard) works in the SQL Server LIKE condition. Remember that what is contained within the square brackets are characters that you are trying to match on. For example: <span>SELECT * FROM employees WHERE first_name LIKE 'Sm[iy]th'; This SQL Server LIKE condition example would return all employees whose first_name is 5 characters long, where the first two characters is 'Sm' and the last two characters is 'th', and the third character is either 'i' or 'y'. So in this case, it would match on either 'Smith' or 'Smyth'. Example - Using [^] wildcard (square brackets with ^ wildcard) Next, let's explain how the [^] wildcard (square brackets with ^ wildcard) works in the SQL Server LIKE condition. Remembe

#### Flashcard 4536080928012

Question
This SQL Server LIKE condition example would return all employees whose first_name is 5 characters long, where the first two characters is 'Sm' and the last two characters is 'th', and the third character is neither 'i' or 'y'. So in this case, it would match on values such as 'Smath', 'Smeth', 'Smoth', etc. But it would not match on either 'Smith' or 'Smyth'.
SELECT *
FROM employees
WHERE first_name LIKE 'Sm[^iy]th';

This SQL Server LIKE condition example would return all employees whose first_name is 5 characters long, where the first two characters is 'Sm' and the last two characters is 'th', and the third character is neither 'i' or 'y'. So in this case, it would match on values such as 'Smath', 'Smeth', 'Smoth', etc. But it would not match on either 'Smith' or 'Smyth'.

status measured difficulty not learned 37% [default] 0
SQL Server: LIKE Condition
square brackets with ^ wildcard) works in the SQL Server LIKE condition. Remember that what is contained within the square brackets are characters that you do NOT want to match on. For example: <span>SELECT * FROM employees WHERE first_name LIKE 'Sm[^iy]th'; This SQL Server LIKE condition example would return all employees whose first_name is 5 characters long, where the first two characters is 'Sm' and the last two characters is 'th', and the third character is neither 'i' or 'y'. So in this case, it would match on values such as 'Smath', 'Smeth', 'Smoth', etc. But it would not match on either 'Smith' or 'Smyth'. Example - Using NOT Operator Next, let's look at how you would use the SQL Server NOT Operator with wildcards. Let's use the % wilcard with the NOT Operator. You could also use the SQL

#### Flashcard 4536082763020

Question
This SQL Server LIKE condition example identifies the ! character as an escape character. This statement will return all employees whose secret_hint is 123%455.
SELECT *
FROM employees
WHERE secret_hint LIKE '123!%455' ESCAPE '!';

This SQL Server LIKE condition example identifies the ! character as an escape character. This statement will return all employees whose secret_hint is 123%455.

status measured difficulty not learned 37% [default] 0
SQL Server: LIKE Condition
character in the SQL Server LIKE condition. You can do this using an Escape character. Please note that you can only define an escape character as a single character (length of 1). For example: <span>SELECT * FROM employees WHERE secret_hint LIKE '123!%455' ESCAPE '!'; This SQL Server LIKE condition example identifies the ! character as an escape character. This statement will return all employees whose secret_hint is 123%455. Here is another more complicated example using escape characters in the SQL Server LIKE condition. SELECT * FROM employees WHERE secret_hint LIKE 'H%!%' ESCAPE '!'; This SQL Server LIKE

#### Flashcard 4536084598028

Question
This SQL Server LIKE condition example returns all employees whose secret_hint starts with H and ends in %. For example, it would return a value such as 'Help%'.
SELECT *
FROM employees
WHERE secret_hint LIKE 'H%!%' ESCAPE '!';

This SQL Server LIKE condition example returns all employees whose secret_hint starts with H and ends in %. For example, it would return a value such as 'Help%'.

status measured difficulty not learned 37% [default] 0
SQL Server: LIKE Condition
as an escape character. This statement will return all employees whose secret_hint is 123%455. Here is another more complicated example using escape characters in the SQL Server LIKE condition. <span>SELECT * FROM employees WHERE secret_hint LIKE 'H%!%' ESCAPE '!'; This SQL Server LIKE condition example returns all employees whose secret_hint starts with H and ends in %. For example, it would return a value such as 'Help%'. You can also use the escape character with the _ character in the SQL Server LIKE condition. For example: SELECT * FROM employees WHERE secret_hint LIKE 'H%!_' ESCAPE '!'; This SQL Serv

#### Flashcard 4536086433036

Question
This SQL Server LIKE condition example returns all employees whose secret_hint starts with H and ends in _. For example, it would return a value such as 'Help_'.
SELECT *
FROM employees
WHERE secret_hint LIKE 'H%!_' ESCAPE '!';

This SQL Server LIKE condition example returns all employees whose secret_hint starts with H and ends in _. For example, it would return a value such as 'Help_'.

status measured difficulty not learned 37% [default] 0
SQL Server: LIKE Condition

#### Flashcard 4536089578764

Question
This SQL Server NOT example would return all rows from the employees table where the first_name is not 'John', 'Dale', or 'Susan'. Sometimes, it is more efficient to list the values that you do not want, as opposed to the values that you do want.
SELECT *
FROM employees
WHERE first_name NOT IN ( 'John', 'Dale', 'Susan' );

This SQL Server NOT example would return all rows from the employees table where the first_name is not 'John', 'Dale', or 'Susan'. Sometimes, it is more efficient to list the values that you do not want, as opposed to the values that you do want.

status measured difficulty not learned 37% [default] 0
SQL Server: NOT Condition
e condition be must be met for the record to be included in the result set. Example - Combine With IN condition The SQL Server NOT condition can be combined with the IN condition . For example: <span>SELECT * FROM employees WHERE first_name NOT IN ( 'John', 'Dale', 'Susan' ); This SQL Server NOT example would return all rows from the employees table where the first_name is not 'John', 'Dale', or 'Susan'. Sometimes, it is more efficient to list the values that you do not want, as opposed to the values that you do want. Example - Combine With IS NULL condition The SQL Server NOT condition can also be combined with the IS NULL condition . For example, SELECT * FROM employees WHERE last_name IS NOT NULL;

#### Flashcard 4536091938060

Question
This SQL Server NOT example would return all records from the employees table where the last_name does not contain a NULL value.
SELECT *
FROM employees
WHERE last_name IS NOT NULL;

This SQL Server NOT example would return all records from the employees table where the last_name does not contain a NULL value.

status measured difficulty not learned 37% [default] 0
SQL Server: NOT Condition
you do not want, as opposed to the values that you do want. Example - Combine With IS NULL condition The SQL Server NOT condition can also be combined with the IS NULL condition . For example, <span>SELECT * FROM employees WHERE last_name IS NOT NULL; This SQL Server NOT example would return all records from the employees table where the last_name does not contain a NULL value. Example - Combine With LIKE condition The SQL Server NOT condition can also be combined with the LIKE condition . For example: SELECT employee_id, last_name, first_name FROM employees W

#### Flashcard 4536093773068

Question
By placing the SQL Server NOT Operator in front of the LIKE condition, you are able to retrieve all employees whose last_name does not start with 'A'.
SELECT employee_id, last_name, first_name
FROM employees
WHERE last_name NOT LIKE 'A%';

By placing the SQL Server NOT Operator in front of the LIKE condition, you are able to retrieve all employees whose last_name does not start with 'A'.

status measured difficulty not learned 37% [default] 0
SQL Server: NOT Condition
employees table where the last_name does not contain a NULL value. Example - Combine With LIKE condition The SQL Server NOT condition can also be combined with the LIKE condition . For example: <span>SELECT employee_id, last_name, first_name FROM employees WHERE last_name NOT LIKE 'A%'; By placing the SQL Server NOT Operator in front of the LIKE condition, you are able to retrieve all employees whose last_name does not start with 'A'. Example - Combine With BETWEEN condition The SQL Server NOT condition can also be combined with the BETWEEN condition . Here is an example of how you would combine the NOT Operator with

#### Flashcard 4536095608076

Question
This SQL Server NOT example would return all rows from the employees table where the employee_id was NOT between 200 and 250, inclusive. It would be equivalent to the following SQL Server SELECT statement:
SELECT *
FROM employees
WHERE employee_id NOT BETWEEN 200 AND 250;

This SQL Server NOT example would return all rows from the employees table where the employee_id was NOT between 200 and 250, inclusive. It would be equivalent to the following SQL Server SELECT statement:

status measured difficulty not learned 37% [default] 0
SQL Server: NOT Condition
EN condition The SQL Server NOT condition can also be combined with the BETWEEN condition . Here is an example of how you would combine the NOT Operator with the BETWEEN condition. For example: <span>SELECT * FROM employees WHERE employee_id NOT BETWEEN 200 AND 250; This SQL Server NOT example would return all rows from the employees table where the employee_id was NOT between 200 and 250, inclusive. It would be equivalent to the following SQL Server SELECT statement: SELECT * FROM employees WHERE employee_id < 200 OR employee_id > 250; Example - Combine With EXISTS condition The SQL Server NOT condition can also be combined with the EXISTS con

#### Flashcard 4536097443084

Question
This SQL Server NOT example would return all records from the employees table where there are no records in the contacts table for the matching last_name and first_name.
SELECT *
FROM employees
WHERE NOT EXISTS (SELECT * FROM contacts WHERE employees.last_name = contacts.last_name AND employees.first_name = contacts.first_name);

This SQL Server NOT example would return all records from the employees table where there are no records in the contacts table for the matching last_name and first_name.

status measured difficulty not learned 37% [default] 0
SQL Server: NOT Condition

#### Flashcard 4536102423820

Question
What is SiB / Seeing is Believing?
A SiB (an acronym for Seeing is Believing) is the proof-of-concept session in which, during the pre-sale process, the technical capabilities of the QlikView software are demonstrated to the prospective customer. The way we demo QlikView at this stage usually involves creating a targeted QlikView document that uses the customer's actual data in a limited amount of time.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536104258828

Question
What is a Data Model?
The heart of a QlikView application is its data model. It is composed of the different source tables that contain the information and data used to measure a company's performance. The data model is constructed by using QlikView's scripting language. A correctly-built data model will associate all of its tables in a way which allows us to manipulate the data however we like. This means that the creation of analysis objects (charts) across different dimensions depends mainly on how the data model is built and how its tables are associated (how they are linked to each other).

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536109501708

Question
The point of clustering is to *** things or observations that are *** and *** them into ***.
The point of clustering is to organize things or observations that are close together and separate them into groups.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536111598860

Question
Hierarchical clustering involves *** your data into a kind of ***
Hierarchical clustering involves organizing your data into a kind of hierarchy

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536113696012

Question
The common approach to hierarchical clustering is what’s called an *** approach.
The common approach to hierarchical clustering is what’s called an agglomerative approach.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536115793164

Question
wrt hierarchical clustering, an agglomerative approach is a kind of *** approach, where you start by thinking of the data as *** data points. Then you start lumping them together into clusters *** by *** until eventually your entire data set is just one big ***.
wrt hierarchical clustering, an agglomerative approach is a kind of bottom up approach, where you start by thinking of the data as individual data points. Then you start lumping them together into clusters little by little until eventually your entire data set is just one big cluster.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536117890316

Question
Imagine there’s all these little particles floating around (your data points), and you start kind of grouping them together into little balls. And then the balls get grouped up into bigger balls, and the bigger balls get grouped together into one big massive cluster. That’s the *** approach to ***.
Imagine there’s all these little particles floating around (your data points), and you start kind of grouping them together into little balls. And then the balls get grouped up into bigger balls, and the bigger balls get grouped together into one big massive cluster. That’s the agglomerative approach to clustering.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536119987468

Question
The hierarchical clustering methodology requires that you have a way to measure the *** between two points and that you have an approach to *** two points to create a new “point”.
The hierarchical clustering methodology requires that you have a way to measure the distance between two points and that you have an approach to merging two points to create a new “point”.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536122084620

Question
A benefit of the hierarchical clustering methodology is that you can produce a tree showing ***.
A benefit of the hierarchical clustering methodology is that you can produce a tree showing how close things are to each other.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536124181772

Question
you won’t get any useful information out of the clustering if you don’t use a *** metric that makes sense for your data.
you won’t get any useful information out of the clustering if you don’t use a distance metric that makes sense for your data.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536126278924

Question
a continuous metric which can be thought of in geometric terms as the “straight-line” distance between two points : *** distance.
a continuous metric which can be thought of in geometric terms as the “straight-line” distance between two points : Euclidean distance.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536128376076

Question
Euclidean distance: A *** metric which can be thought of in geometric terms as the “***” distance between two points
Euclidean distance: A continuous metric which can be thought of in geometric terms as the “straight-line” distance between two points

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536130473228

Question
“Manhattan” distance: on a *** or ***, how many “***” would you have to travel to get from point A to point B?
“Manhattan” distance: on a grid or lattice, how many “city blocks” would you have to travel to get from point A to point B?

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536132570380

Question
on a grid or lattice, how many “city blocks” would you have to travel to get from point A to point B? : “***” distance
on a grid or lattice, how many “city blocks” would you have to travel to get from point A to point B? : “Manhattan” distance

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536134667532

Question
There are a number of commonly used metrics for characterizing distance or its inverse, ***.
There are a number of commonly used metrics for characterizing distance or its inverse, similarity.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536138337548

Question
a distance matrix can be computed with the ***() function in R.
a distance matrix can be computed with the dist() function in R.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536140434700

Question
the dist() function in R computes a ***.
the dist() function in R computes a distance matrix.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536142531852

Question
The default distance metric used by the dist() function in R is *** distance.
The default distance metric used by the dist() function in R is Euclidean distance.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536144629004

Question
in R, the function to perform hierarchical clustering is ***().
in R, the function to perform hierarchical clustering is hclust().

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536146726156

Question
One method of merging points in hierarchical clustering, called “complete” is to measure the distance between two groups of points by the *** distance between the two groups.
One method of merging points in hierarchical clustering, called “complete” is to measure the distance between two groups of points by the maximum distance between the two groups.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536148823308

Question
take all points in group 1 and all points in group 2 and find the two points that are furthest apart–that’s the "****" distance between the groups, when merging wrt hierarchical clustering.
take all points in group 1 and all points in group 2 and find the two points that are furthest apart–that’s the "complete" distance between the groups, when merging wrt hierarchical clustering.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536150920460

Question
to find the "complete" distance between the groups, when merging wrt hierarchical clustering: take all *** in group 1 and all *** in group 2 and find the *** that are ***.
to find the "complete" distance between the groups, when merging wrt hierarchical clustering: take all points in group 1 and all points in group 2 and find the two points that are furthest apart.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536153017612

Question
the default merging method in the hclust() function in R is "***" merging.
the default merging method in the hclust() function in R is "complete" merging.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536155114764

Question
wrt hierarchical clustering, average merging takes the *** of the *** values in each group and measures the *** between these two ***.
wrt hierarchical clustering, average merging takes the average of the coordinate values in each group and measures the distance between these two averages.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536157211916

Question
wrt hierarchical clustering, taking the average of the coordinate values in each group and measures the distance between these two averages defines "***" merging.
wrt hierarchical clustering, taking the average of the coordinate values in each group and measures the distance between these two averages defines "average" merging.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536159309068

Question
Concerning hierarchical clustering; while there’s not necessarily a correct merging approach for any given application, it’s important to note that the resulting ***/*** that you get can be sensitive to the *** approach that you use
Concerning hierarchical clustering; while there’s not necessarily a correct merging approach for any given application, it’s important to note that the resulting tree/hierarchy that you get can be sensitive to the merging approach that you use

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536161406220

Question
in R, heatmap() sorts the rows and columns of a *** according to the *** determined by a call to ***().
in R, heatmap() sorts the rows and columns of a matrix according to the clustering determined by a call to hclust().

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536163503372

Question
in R, to sort the rows and columns of a matrix according to the clustering determined by a call to hclust(), use ***().
in R, to sort the rows and columns of a matrix according to the clustering determined by a call to hclust(), use heatmap().

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536165600524

Question
in R, conceptually, heatmap() first treats the *** of a matrix as observations and calls hclust() on them, then it treats the *** of a matrix as observations and calls hclust() on those values.
in R, conceptually, heatmap() first treats the rows of a matrix as observations and calls hclust() on them, then it treats the columns of a matrix as observations and calls hclust() on those values.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536167697676

Question
the end result of calling heatmap() in R is that you get a *** associated with both the rows and columns of a ***, which can help you to spot obvious *** in the data.
the end result of calling heatmap() in R is that you get a dendrogram associated with both the rows and columns of a matrix, which can help you to spot obvious patterns in the data.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536169794828

Question
a dendrogram associated with both the rows and columns of a matrix is the end result of calling ***() in R.
a dendrogram associated with both the rows and columns of a matrix is the end result of calling heatmap() in R.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536171891980

Question
caution should be used with clustering as often the picture that you produce can be ***.
caution should be used with clustering as often the picture that you produce can be unstable.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536173989132

Question
wrt hierarchical clustering, choosing where to “***” the tree to determine the number of clusters isn’t always obvious.
wrt hierarchical clustering, choosing where to “cut” the tree to determine the number of clusters isn’t always obvious.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536176086284

Question
wrt hierarchical clustering, choosing where to “cut” the tree to determine the *** isn’t always obvious.
wrt hierarchical clustering, choosing where to “cut” the tree to determine the number of clusters isn’t always obvious.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536178183436

Question
wrt hierarchical clustering, choosing where to “cut” the tree to determine the number of clusters isn’t always ***.
wrt hierarchical clustering, choosing where to “cut” the tree to determine the number of clusters isn’t always obvious.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536180280588

Question
in light of it's limitations, hierarchical clustering should be primarily used for ***.
in light of it's limitations, hierarchical clustering should be primarily used for exploration of data.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536182377740

Question
The K-means approach, like many clustering methods, is highly *** (can’t be summarized in a formula) and is ***.
The K-means approach, like many clustering methods, is highly algorithmic (can’t be summarized in a formula) and is iterative.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536184474892

Question
The K-means approach, like many clustering methods, is highly algorithmic (can’t be summarized in a ***) and is iterative.
The K-means approach, like many clustering methods, is highly algorithmic (can’t be summarized in a formula) and is iterative.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536186572044

Question
The basic idea of K-means clustering is that you are trying to find the *** of a *** number of clusters of points in a *** space.
The basic idea of K-means clustering is that you are trying to find the centroids of a fixed number of clusters of points in a high-dimensional space.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536188669196

Question
trying to find the centroids of a fixed number of clusters of points in a high-dimensional space is the basic idea of *** clustering.
trying to find the centroids of a fixed number of clusters of points in a high-dimensional space is the basic idea of K-means clustering.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536190766348

Question
in two dimensions, you can imagine that there are a bunch of clouds of points on the plane and you want to figure out where the centers of each one of those clouds is. this is a 2-dimensional description of *** clustering.
in two dimensions, you can imagine that there are a bunch of clouds of points on the plane and you want to figure out where the centers of each one of those clouds is. this is a 2-dimensional description of K-means clustering.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536192863500

Question
The K-means approach is a *** approach, whereby the data are *** into groups at each iteration of the algorithm.
The K-means approach is a partitioning approach, whereby the data are partitioned into groups at each iteration of the algorithm.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536194960652

Question
One requirement of the K-means appraoch is that you must pre-specify how many *** there are.
One requirement of the K-means appraoch is that you must pre-specify how many clusters there are.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Annotation 4536197057804

 The outline of the algorithm is 1. Fix the number of clusters at some integer greater than or equal to 2 2. Start with the “centroids” of each cluster; initially you might just pick a random set of points as the centroids 3. Assign points to their closest centroid; cluster membership corresponds to the centroid assignment 4. Reclaculate centroid positions and repeat.

#### pdf

cannot see any pdfs

#### Flashcard 4536198630668

Question
The K-means clustering algortihm requires a defined *** metric, a fixed number of ***, and an initial guess as to the cluster ***.
The K-means clustering algortihm requires a defined distance metric, a fixed number of clusters, and an initial guess as to the cluster centroids.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536200727820

Question

the K-means clustering algorithm produces :

• A final estimate of cluster *** (i.e. their ***)

• An assignment of each point to their respective ***

the K-means clustering algorithm produces :

• A final estimate of cluster centroids (i.e. their coordinates)

• An assignment of each point to their respective cluster

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536206232844

Question
The kmeans() function in R implements the *** algorithm and can be found in the *** package.
The kmeans() function in R implements the K-means algorithm and can be found in the stats package.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536209378572

Question
the K-means algorithm can be implemented via ***() in the stats package in R.
the K-means algorithm can be implemented via kmeans() in the stats package in R.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536212000012

Question
key parameters for kmeans() in R that you have to specify are '***', which is a matrix or data frame of data, and '***' which is either an integer indicating the number of clusters or a matrix indicating the locations of the initial cluster centroids.
key parameters for kmeans() in R that you have to specify are 'x', which is a matrix or data frame of data, and 'centers' which is either an integer indicating the number of clusters or a matrix indicating the locations of the initial cluster centroids.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536214621452

Question
key parameters for kmeans() in R that you have to specify are 'x', which is ***, and 'centers'.
key parameters for kmeans() in R that you have to specify are 'x', which is a matrix or data frame of data, and 'centers'.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536216718604

Question
key parameters for kmeans() in R that you have to specify are 'x', and 'centers' which is either an *** indicating the *** or a *** indicating the ***.
key parameters for kmeans() in R that you have to specify are 'x', and 'centers' which is either an integer indicating the number of clusters or a matrix indicating the locations of the initial cluster centroids.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536218815756

Question
You can see which cluster each data point got assigned to by looking at the '***' element of the list returned by the kmeans() function in R.
You can see which cluster each data point got assigned to by looking at the 'cluster' element of the list returned by the kmeans() function in R.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536220912908

Question
The key aspect of matrix data is that every element of the matrix is the same *** and represents the same kind of ***.
The key aspect of matrix data is that every element of the matrix is the same type and represents the same kind of measurement.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536223010060

Question
that every element of the matrix is the same type and represents the same kind of measurement is the key aspect of *** data.
that every element of the matrix is the same type and represents the same kind of measurement is the key aspect of matrix data.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536225107212

Question
the key aspect of matrix data is in contrast to a ***, where every column of a *** can potentially be of a different ***.
the key aspect of matrix data is in contrast to a data frame, where every column of a data frame can potentially be of a different class.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Flashcard 4536228252940

Question
O que é Excelência no atendimento?
É o conjunto de atividades desenvolvidas por uma organização direcionadas a identificar as necessidades dos seus usuários, procurando atender suas expectativas, criando ou elevando o seu nível de satisfação.

status measured difficulty not learned 37% [default] 0

#### pdf

cannot see any pdfs

#### Annotation 4536231136524

 Essa cartilha tem como objetivo ressaltar e disseminar, no âmbito da Prefeitura Municipal de Vitória - PMV, a prática da qualidade e da excelência, por meio de informações e conceitos, trazendo uma reflexão sobre a importância do nosso papel enquanto servidor público na manutenção da qualidade dos serviços e do envolvimento de todos em busca da excelência

#### pdf

cannot see any pdfs

#### Annotation 4536240049420

 deias para Dishonored 2 foram concebidas durante o desenvolvimento dos conteúdos para download do jogo original, o que levou a decisão de dar voz ao personagem de Corvo depois de ele ter permanecido um personagem silencioso durante toda a história.

Dishonored 2 – Wikipédia, a enciclopédia livre
quanto Corvo empregam suas próprias habilidades sobrenaturais únicas para poder completar missões e eliminar alvos por meio de furtividade ou violência, navegando através de ambientes abertos. I<span>deias para Dishonored 2 foram concebidas durante o desenvolvimento dos conteúdos para download do jogo original, o que levou a decisão de dar voz ao personagem de Corvo depois de ele ter permanecido um personagem silencioso durante toda a história. O avanço na linha temporal ocorreu assim que foi proposto que Emily, que era apenas uma criança em Dishonored, se tornasse uma personagem jogável. O visual do título foi inspirado em ob

#### Annotation 4536875224332

 Existe uma trindade sagrada da segurança da informação. São três princípios ou propriedades: Confidencialidade, Integridade e Disponibilidade – conhecidos como CID. Se um ou mais desses princípios forem desrespeitados em algum momento, significa que houve um incidente de segurança da informação.