Data+ Languages/Databases

IDE (Integrated Development Environment)

A full software application for writing, testing, and running code. Includes built-in tools like debugging and auto-complete.

Examples: RStudio, VS Code.

Think: a fully equipped workshop with all tools built in.

Text Editor

A simple tool for writing code/text without the extra built-in features an IDE has.

Example: Notepad, Sublime Text.

Think: a plain notebook, good for quick writing, no special tools.

Notebook (coding environment)

An interactive environment where you write code in small chunks/cells, run them one at a time, and see output (charts, tables) immediately below each chunk.

Example: Jupyter Notebook.

Think: a lab journal.

RStudio

An IDE made specifically for the R programming language. Used heavily for statistics work.

VS Code

A popular, flexible IDE/code editor that supports many programming languages (Python, R, SQL, and more).

Business Intelligence (BI) Software

Tools used to visualize and explore data, usually with little/no coding required.

Examples: Tableau, Power BI, Looker.

Tableau

A BI tool known for drag-and-drop, highly visual dashboard creation.

Power BI

Microsoft's BI tool. Integrates well with Excel and other Microsoft products.

Looker

A BI tool owned by Google, known for working closely with cloud databases and creating reusable data models.

Anaconda

A distribution/platform that bundles Python, R, and hundreds of data science packages together in one install.

Think: the whole toolbox kit.

pandas

A Python library/package for working with data tables (like spreadsheets). Used for cleaning, filtering, and analyzing data.

tidyverse

A collection of packages for the R language, designed for cleaning and visualizing data in a consistent way.

Anaconda vs pandas vs tidyverse

Anaconda is the whole toolbox kit bundling many tools/languages together. pandas is one specific tool inside the kit, for Python.

Tidyverse is one specific tool kit inside the kit, for R.

SAS

A programming language/software historically used heavily in statistics, healthcare, and corporate/enterprise data analysis.

Python

An extremely popular, beginner-friendly, general-purpose language widely used in data science, automation, and machine learning.

R (programming language)

A language built specifically for statistics and data visualization. Favorite of statisticians and academic researchers.

Scala

A language often used for big data processing, frequently paired with tools like Apache Spark for handling massive datasets.

SQL (Structured Query Language)

The actual language used to talk to and query databases. Not a tool itself, it's the language the DBMS tools help you use.

SQL Server Management Studio (SSMS)

Microsoft's official tool for managing/querying SQL Server databases.

MySQL Workbench

The official tool for managing/querying MySQL databases.

MongoDB Compass

A visual tool for exploring/managing MongoDB databases. MongoDB is a NoSQL database, storing data as flexible documents instead of strict tables.

DBeaver

A universal database tool that works with many different types of databases, not locked to just one. Popular for its flexibility.

Toad

A database management tool, often used with Oracle databases, for querying/managing/development.

Azure Data Studio

Microsoft's modern, lightweight tool for working with databases, especially in cloud (Azure) environments.

Scala

A language often used for big data processing, frequently paired with tools like Apache Spark for handling massive datasets.