3 Flashcards

1
Q

2 type of data storage

A

The main type of data storage are HDDs and SSDs for personal computers

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

What is SQL

A

SQL or structured Query language, is a programming language used for managing database, allowing efficient handling data store in table through clear syntax

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

example of SQL ORDER BY
With example

A

order by sort result in ascending order or descending order

For example sort customer by name

SELECT * FROM Customer ORDER BY Name;

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

example of SQL WHERE
With example

A

WHERE: It filter data based on the condition

For example: Find These customer who are in NEW YORK

SELECT * FROM customer WHERE city = “New York”;

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

example of SQL Logical Operators (AND,OR,NOT)
With example

A

Logical operator, It combines condition for complex search

For example: find customer who is over the age of 25 in NEW YORK

SELECT * FROM Customer WHERE Age > 25 AND City = “New York”;

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