Notes

Day 3 Day 4 Day 5 Day 6 Day 7

Day 3

Data

Raw, unprocessed facts and figures without context. Example: numbers, dates, strings.

Information

Processed data that has meaning and can be used for decision-making. Example: A report showing sales figures.

Meta Data

Data that describes other data. It provides information about data's structure, data type, and constraints. Example: Column names, data types.

Data Dictionary

A centralized repository of information about data such as meaning, relationships to other data, origin, usage, and format. It helps in managing data definitions.

Database

An organized collection of structured data, typically stored electronically in a computer system, and managed by a DBMS.

Table

A collection of related data entries consisting of rows and columns in a database. Each table represents a specific entity.

Tuple(s)

A single row in a table, which represents a single record of data.

Field(s)

A single piece of data; a column in a table. Each field represents an attribute of the entity described by the table.

Domain(s)

The set of permissible values that a field can take. Example: The domain of a field "age" might be 0-120.

Constraint(s)

Rules enforced on data in a table to ensure validity, integrity, and consistency. Examples: Primary key, foreign key, unique, not null.

Key(s)

A field or combination of fields used to uniquely identify a record in a table. Examples include primary key, foreign key, and unique key.

Day 4

Day 5

Day 6

How to create Gmail account?

  1. Go to google signup page
  2. Fill in the information
  3. Verify phone number
  4. Agree to the terms and conditions

How to create GitHub account?

  1. Go to github site
  2. Enter email to signup
  3. Fill in the information
  4. Fill the verification code from the email
  5. Agree to the terms and conditions

How to connect VS Code Editor to GitHub account?

  1. Go to VS Code extensions tab
  2. Download GitHub extension
  3. Login with GitHub account

How to clone/pull repository from GitHub?

  1. Copy the link of the repository
  2. Open terminal
  3. Use this command: git clone https://github.com/YOUR-USERNAME/YOUR-REPOSITORY

How to push repository/folder to GitHub?

  1. Open GitHub dashboard
  2. Click new repository on the upper right
  3. Name the repository and create it

How to publish the repo as live site?

  1. Go to settings of repository
  2. Go to pages section
  3. Choose root in dropdown menu
  4. Go back to the repository page and click the orange dot
  5. After processes complete,go to page settings again and the link will be available

Day 7