Comptia Data Terms Part 2
English → English · 14 words
| English | English |
|---|---|
| Qlik | A data visualization tool |
| IBM SPSS | A statistical tool |
| Tableau Prep | A data transformation tool |
| Publicly Available Info vs Public Data | Publicly available info is made public through no legal requirement unlike public data |
| An email is what type of data? | Semi-structured |
| Data Verification vs Data Validation | Data verification is the process of confirming the data is accurate or true. Data validation is the process of confirming the type, structure and accurate representation of data. |
| Entity Integrity | The unique identifier of a record as defined by a primary key field |
| Domain Integrity | The acceptable values for a field |
| Referential Integrity | The integrity of data between two tables |
| User Defined Integrity | Based on business rules not covered by other data integrity settings |
| Cross Join | When tables are added to a query and no join is specified, each record in each table is tied together |
| Full Join | Only displays records that exist in both tables |
| Left Outer Join | Displays all results of left table and matching records in the right table |
| Right Outer Join | Displays all results of right table and matching records in the left table |