4 : data types

Data that is defined through different numbers
- two sub categories : discrete data and continuous data

• # data

Quantitative data

a type of Quantitative data ….
Data that can be counted with a certain number of values

How many people you dated - Whole numbers you count. No decimals!

ex : drop down list

Discrete data

a type of Quantitative data ….

Data that can be counted but with changing values
- ex : earnings or sales = constantly changing

continuous data

Data is arranged into groups or categories based on some kind of quality

qualitative data

what are the two sub categories of qualitative data

nominal data ordinal data

this form of qualitative data is information that has no natural order

• ex : everyones favorite color

nominal data

this form of qualitative data is information that has a natural order

ex : good better best , low med high

ordinal data

When this data type is set as a text data type it is ? which allows the field to store any type of letter and/or number

alphanumeric

date data type can store the time as well . true or false?

true

this data type stores numbers, and does not allow for text

• allows for calculations

  • integers or decimals

number data types

this data type is commonly used for Yes/No, True/False, and On/Off responses. It is represented by a number that is either 1 or 0.

• two values

boolean

data is not static, it is ?

dynamic

this data is specific

• follows existing convention

• fits nicely into tables

  • can be restructured to fit into other structured data systems like data warehouses

structured data

this type of data is not organized in a predefined manner .

• text, images, or videos

  • if we want to work with this type of data we need to use a data lake or BLOB storage ( video, audio , and text )

unstructured data

This type of data does not meet the rigid standards of structured data, so it cannot be stored in a relational database. However, ? data does contain some structure through the use of tags and attributes that group the data and describe its storage methods.

• examples : XML files, emails, json files , zipped files

semi structured data

files in which some form of character (tab, comma) separates each field of data from the other data fields.

• most common type CSV file

delimited file

Delimited files that are exported out of a system ? files, they do not have a live connection to the database and require additional steps when the data is to be refreshed with a new file

• data has been exported from the database in real-time

flat file

? delimited file , This uses a ?, which has five spaces to be able to separate each of the fields in that file

▪ Uses a different character, like a pipe,
Ex : .CSV .TAV . TSV .TXT

tab

? data is limited to character data that exceeds 4000 bytes i.e storing pages in a book

CLOB

this data language …..,.

• most commonly used when interacting with a database

  • uses a series of statements to provide info to the database

sql

what are the two statements covered that provide information to the database

select statement, where keyword

this sql statement ….

The way you're going to query information from a database that selects the fields you want to select

select statement

this sql statement…..

Allows you to be able to select something where a certain condition happens

where statements

this data language…..

▪ The language that we use to write web pages and show them to the world i.e display info

▪ A semi-structured environment and we use tags to be able to dictate what parts of information is being displayed at any given time

HTML

this data language……

▪ Another text-based market language, much like HTML, but its purpose is different

▪ It interacts really well with JavaScript

▪ The goal here is to transfer data, not to display on the screen

• uses opening and closing tags

XML

this programming language is used to get data to and from websites

• interacts with java script

• key value pair

JSON