Notes

**Day 1**

- FE
- website/mobile app -> UI/UX
- BE
- API: Application programming interface / data trasnfer
- Source:
- Data verification
- SSN
- Education
- degree number/year/college
- Medical license
- license type -> Dentist / New york / license number: 2522
- issue/expire/status/name/address/additional/disciplinary-action
- license type + state
- 51 states * 1 board/20 board
- ~200 websites
- Tech:
- C# -> dotnet
- Javascript -> web data scraping
- DB -> database
-> Mysql / SQL Server / Oracle DB
-> Language: [SQL](https://www.w3schools.com/sql/sql_intro.asp) -> Structured Query Language
-> SELECT * FROM STUDENTS WHERE AGE > 15;
-> SELECT * FROM STUDENTS WHERE DOB > '' & DOB < '';
-> SELECT * FROM STUDENTS WHERE DOB BETWEEN '' & '';
-> SELECT * FROM STUDENTS;
-> SELECT * FROM STUDENTS LIMIT 10;
-> SELECT * FROM STUDENTS ORDER BY AGE DESC LIMIT 10;
-> INSERT (DATA) INTO STUDENTS;
-> UPDATE STUDENTS SET NAME = 'Michael' WHERE ROLLNO = '7';
-> RELATIONAL DATABASE
- Certificates
- Board Certification
- NPI -> National provider identifier
- DEA -> Drug Enforcement Agency

**Generic Format**
select column_names_comma_seperated // what to return
from table_name // from which table
where conditions // data filter
order by column_name asc/desc // in what order
limit count // how much/quantity

**Generic Format**
select */column_names_comma_seperated
from table_name
join table_name ON condition
where conditions
order by column_name asc/desc
limit count

**Group by**
select column_names_comma_seperated
from table_name
where conditions
order by column_name asc/desc
group by column_name
limit count

Ex:
SELECT Country, Count(*)
FROM [Customers]
GROUP BY Country

SELECT CustomerID, Count(*) as orderCount
FROM [Orders]
GROUP BY CustomerID
ORDER BY orderCount DESC

SELECT SupplierID, CategoryID, Count(*) as productCount, AVG(Price) as AveragePrice
FROM [Products]
GROUP BY SupplierID, CategoryID