--> MySQL workbench 실행 후 Connect to Database탭 실행
(참고)
-- SELECT * FROM orderdetails
-- SELECT orderNumber, orderLinenumber, quantityOrdered * priceEach AS subTotal
-- FROM orderdetails
-- ORDER BY subTotal DESC
-- SELECT firstName, lastName, reportsTo
-- FROM employees
-- ORDER BY reportsTo DESC
-- SELECT
-- FROM
-- WHERE
-- GROUP BY
-- HAVING
-- ORDER BY
-- SELECT
-- DISTINCT
-- e.firstName,
-- e.lastName
-- FROM
-- employees AS e
-- WHERE
-- jobtitle = 'Sales Rep' AND officeCode = 1
-- jobtitle = 'Sales Rep' OR officeCode = 1
-- officeCode BETWEEN 1 AND 3
-- lastName LIKE '%son%'
-- officeCode = 1 OR officeCode = 3--
-- officeCode IN (1,3)
-- reportsTo IS NULL
-- jobtitle = 'Sales Rep'
-- jobtitle <> 'Sales Rep'
-- -- officeCode > 6
-- ORDER BY
-- e.firstName
-- SELECT
-- c.customerName,
-- COUNT(*) as orderCount
-- FROM
-- customers as c
-- INNER JOIN
-- orders as o ON c.customerNumber = o.customerNumber
-- GROUP BY
-- customerName
-- ORDER BY
-- orderCount
-- SELECT
-- orderNumber,
-- SUM(quantityOrdered) AS itemsCount,
-- SUM(priceEach * quantityOrdered) AS total
-- FROM
-- orderdetails
-- GROUP BY
-- orderNumber
-- HAVING
-- total > 1000 AND itemsCount > 600
-> DDL, DML, DCL 관련해서 따로 공부해두면 좋음
<ol>
<li>Azure MySQL server를 제공해줌</li>
<li>MySQL workbench는 따로 다운로드해서 연동해야함</li>
<li>DBMS의 핵심은 Query문!</li>
<li>DDL, DML, DCL !!!</li>
<li>UPDATE, DELETE 구문은 실전에서 세상 주의해서 사용해야함.</li>
<li>Primary 키와 Foreign 키의 관계를 이해하고, INDEX 설정도 공부하자</li>
<li>VIEW에 대해서도 따로 공부하면 좋다(학교에선 안다룸)</li>
</ol>