Leo's Garage

Databases Relational databases Define relationships between tables of data inside the database Tables rows = records, columns = fields Combined Data Schema Introducing queries 아주 큰 Datasets에 적합하다. SELECT FROM SELECT name FROM patrons; patrons 테이블에서 name 필드에 해당하는 값을 가져와 SELECT card_num, name FROM patrons; patrons 테이블에서 card_num과 name 필드에 있는 값을 가져와 Writing queries Aliasing rename columns SELECT na..

Data Workflow Data Collection & Storage → Data Preparation → Exploration & Visualization → Experimentation & Prediction Data engineer는 Data Collection & Storage와 연관되어 있다. Data Engineer는 the correct data in the right form to the right people as efficiently as possible A data engineer’s responsibilities Ingest data from different sources Optimize databases for analysis Remove corrupted data Develo..