Articles
117
Tags
37
Categories
13
Home
About
Tech
Showcase
Resume
Danny's Blog
Coding_Quiz_SQL_1
Back to Home
Home
About
Tech
Showcase
Resume
Coding_Quiz_SQL_1
Created
2025-09-17
|
Updated
2025-11-20
|
DEV
CODING_QUIZ_SQL
|
Post Views:
Author:
Danny Ki
Link:
https://kish191919.github.io/2025/09/17/Coding-Quiz-SQL-1/
Copyright Notice:
All articles on this blog are licensed under
CC BY-NC-SA 4.0
unless otherwise stated.
LEETCODE
SQL
Previous
TERADATA(1)-Overview of Teradata Studio Modules
๐ Teradata Studio ๊ธฐ๋ณธ ํ๋ฉด ์ดํดํ๊ธฐ๊ธฐ์ด UI ์ค๋ช + SQL ์คํ ๋ฐฉ๋ฒ + ํธ๋์ญ์ ๋ชจ๋ ๊ฐ๋ ๐ 1. Teradata Studio ์ฒซ ํ๋ฉด ๊ตฌ์ฑTeradata Studio๋ฅผ ์คํํ๋ฉด ๋ค์๊ณผ ๊ฐ์ ์ฃผ์ ์์ญ์ ๋ณด๊ฒ ๋ฉ๋๋ค. ๐น 1) ์๋จ ๋ฉ๋ด(File / Edit / Window ๋ฑ)์ผ๋ฐ์ ์ธ ํ์ผ ๊ด๋ฆฌ, ๋ณด๊ธฐ ์ค์ , ํ๊ฒฝ์ค์ ๋ณ๊ฒฝ ๋ฑ์ ์ํํฉ๋๋ค. ๐น 2) Studio Toolbar์ฟผ๋ฆฌ ์คํ, ์ ์ฅ, ์ ์ฐ๊ฒฐ ์์ฑ ๋ฑ ์์ฃผ ์ฌ์ฉํ๋ ๊ธฐ๋ฅ ์์ด์ฝ๋ค์ด ์์นํฉ๋๋ค. ๐น 3) Data Source Explorer (์ข์ธก ์์ญ)Teradata์ ์ฐ๊ฒฐ๋ ๋ฐ์ดํฐ๋ฒ ์ด์ค / ์ ์ / ํ ์ด๋ธ / ๋ทฐ ๋ฑ์ ํ์ํ ์ ์๋ ๊ฐ์ฅ ์ค์ํ ํจ๋์ ๋๋ค. ๐น 4) Project ExplorerSQL ํ์ผ์ด๋ ํ๋ก์ ํธ๋ฅผ ๋ก์ปฌ์ ์ ์ฅํ์ฌ ๊ด๋ฆฌํ ๋ ์ฌ์ฉํฉ๋๋ค. ๐น 5) SQL Editor (์ค์ ์๋จ)SQL์ ์์ฑํ๋ ๊ณต๊ฐ์ ๋๋ค.์: 1...
Next
Coding_Quiz_Python_1
1. Two SumLink : https://leetcode.com/problems/two-sum/description/?difficulty=EASY Hash Map (๋์ ๋๋ฆฌ ์ด์ฉ)๋ณด์กฐ ๊ณต๊ฐ์ ์ด์ฉํด ๋น ๋ฅด๊ฒ ์ฐจ์ด๋ฅผ ์ฐพ๋ ๋ฐฉ์. ์๊ฐ ๋ณต์ก๋: O(n) ๊ณต๊ฐ ๋ณต์ก๋: O(n) 1234567891011class Solution: def twoSum(self, nums: List[int], target: int) -> List[int]: num_map = {} for index, num in enumerate(nums): diff = target - num if diff in num_map: return [num_map[diff], index] num_map[num] = index Sorting + Two Pointers...
Related Articles
2025-09-17
Coding_Quiz_Python_1
1. Two SumLink : https://leetcode.com/problems/two-sum/description/?difficulty=EASY Hash Map (๋์ ๋๋ฆฌ ์ด์ฉ)๋ณด์กฐ ๊ณต๊ฐ์ ์ด์ฉํด ๋น ๋ฅด๊ฒ ์ฐจ์ด๋ฅผ ์ฐพ๋ ๋ฐฉ์. ์๊ฐ ๋ณต์ก๋: O(n) ๊ณต๊ฐ ๋ณต์ก๋: O(n) 1234567891011class Solution: def twoSum(self, nums: List[int], target: int) -> List[int]: num_map = {} for index, num in enumerate(nums): diff = target - num if diff in num_map: return [num_map[diff], index] num_map[num] = index Sorting + Two Pointers...
Danny Ki
A data engineer's journey in coding, analytics, and building real-world systems.
Articles
117
Tags
37
Categories
13
Follow Me
Announcement
This is my Blog
Recent Posts
DATABRICKS-Certified-Developer-6
2025-12-18
DATABRICKS-Certified-Developer-5
2025-12-18
DATABRICKS-Certified-Developer-4
2025-12-18
DATABRICKS-Certified-Developer-3
2025-12-18
DATABRICKS-Certified-Developer-2
2025-12-18