3 Flashcards
2 type of data storage
The main type of data storage are HDDs and SSDs for personal computers
What is SQL
SQL or structured Query language, is a programming language used for managing database, allowing efficient handling data store in table through clear syntax
example of SQL ORDER BY
With example
order by sort result in ascending order or descending order
For example sort customer by name
SELECT * FROM Customer ORDER BY Name;
example of SQL WHERE
With example
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”;
example of SQL Logical Operators (AND,OR,NOT)
With example
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”;