Transactional
Operational
- Historical
Analytical
- Query
Relational Database
- Still used because it’s costly to change
- Relationship between entities
Customer has many order and each order belongs to 1. Underlined customer is unique
customer ID. Primary Key – Order Number. Customer ID – Foreign Key. Each product can
associate with at least 1 up to many. Order to Product (many to many relationship)
SQL – Structured Query Language
SELECT (Column Name)
FROM (Table Name)
WHERE
%C% all names with letter C
C% all names that start with C
1. select count(first_name)
from actor
2.
select count(*)
from actor
where first_name = 'Julia'
3. select count(*)
from actor
where last_name like 'C%'
4. select count(*)
from film
where description like '%dog%'
5. select title, length
from film
where length in
(select max(length) from film);
or
select title, length
from film
order by length desc
6. select rating, count(film_id)
from film
group by rating
Powered by TCPDF (www.tcpdf.org)
