June 2024
Beginner to intermediate
352 pages
9h 29m
Korean
Content preview from 개발자를 위한 필수 수학
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
294
개발자를 위한 필수 수학
8.3.1
SQL
숙련도
SQL
은 테이블 데이터를 검색, 변환 및 작성하기 위한 쿼리
query
언어입니다. 관계형 데이터
베이스는 데이터를 구성하는 가장 일반적인 방법으로, 엑셀의
VLOOKUP
과 같이 서로 연
결된 테이블에 데이터를 저장합니다.
MySQL
, 마이크로소프트
SQL
서버, 오라클,
SQLite
,
PostgreSQL
과 같은 관계형 데이터베이스 플랫폼은
SQL
을 지원합니다.
SQL
과 관계형 데이
터베이스는 매우 밀접하게 연결되며 ‘
MySQL
’, ‘마이크로소프트
SQL
서버’와 같이 관계형 데이
터베이스의 이름에 ‘
SQL
’을 자주 사용합니다.
[예제
8
-
1
]은
CUSTOMER
테이블에서
STATE
가
'
TX
'
인 레코드의
CUSTOMER
_
ID
와
NAME
필드를
검색하는 간단한
SQL
쿼리입니다.
예제
8-1
간단한
SQL
쿼리
SELECT
CUSTOMER_ID,
NAME
FROM
CUSTOMER
WHERE
STATE
=
'TX'
간단히 말해
SQL
에 능숙하지 않으면 데이터 과학 전문가로서 성공하기 어렵습니다. 기업은 데
이터 웨어하우스
data
warehouse
를 사용하며, 거의 항상 데이터를 검색하는 수단으로
SQL
을 사용
합니다.
SELECT
,
WHERE
,
GROUP
BY
,
ORDER
BY
,
CASE
,
INNER
JOIN
,
LEFT ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.