[DAY14]_개발일지: Microsoft Azure(3)

1. 학습내용

1. Azure Storage
2. Azure SQL DB 서비스
3. Azure MySQL 서비스
4. Query 문
5. MySQL workbench 설치 - 별개활동

2. 상세내용

Azure Storage

---

Azure SQL DB 서비스

Azure MySQL 서비스

--> MySQL workbench 실행 후 Connect to Database탭 실행

(참고)

쿼리관련 사이트 바로가기

QUERY*

-- 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

---

MySQL workbench 설치 - 별개활동

-> DDL, DML, DCL 관련해서 따로 공부해두면 좋음

---

---

3. 금일소감

<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>