Intro to Data/Databases & SQL Flashcards

1
Q

What is SQL (Structured Query Language)

A

a programming language used to manage & manipulate databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What does SQL stands for?

A

Structured Query Language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the purpose of SQL?

A

it helps in retrieving, inserting, updating, and deleting data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Give a simple example of SQL in use!

A

is retrieving customer data from a database toshow on a website

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Brief History of SQL: When and “Who” was SQL developed?

A

In 1970s by IBM - it has become the standard lang. for interacting with relational databases.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Why should you learn SQL?

A
  • Is important because it allows you to interact w. databases, retrieve & manipulate dta, & highly valued in fields like data analysis, web development, & business intellignece.
  • It’s also essential for managing & understanding data in various professional settings.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is SQL?
- What does SQL stand for?
- Define what SQL is
- Give an example of SQL in use
- Brief History of SQL
- SQL Usage

A

1 - Stands for: Structured Query Language
2 - Define: Define: is a programming language used to manage and manipulate databases. It helps in retrieving, inserting, updating, and deleting data.
3 - Example in use : is retrieving customer data from a database to show on a website.
4 - History: SQL was developed in the 1970s by IBM, and it has become the standard language for interacting with relational databases.
5 - Usage: SQL is widely used in web development, data analysis, and in businesses to manage large amounts of data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly