데이터 공부를 기록하는 공간

■ 코드카데미(codecademy) SQL 연습해보기 https://www.codecademy.com/courses/learn-sql/lessons/multiple-tables/exercises/generalizations-multiple-tables ■ Cheating Sheets https://www.codecademy.com/learn/learn-sql/modules/learn-sql-multiple-tables/cheatsheet LESSON 4 : MULTIPLE TABLES JOIN (= Inner Join, 교집합) SELECT * FROM books JOIN authors ON books.author_id = authors.id; LEFT JOIN (= Outer Join) SELECT c..

■ 코드카데미(codecademy) SQL 연습해보기 https://www.codecademy.com/courses/learn-sql/lessons/aggregate-functions/exercises/review ■ Cheating Sheets https://www.codecademy.com/learn/learn-sql/modules/learn-sql-aggregate-functions/cheatsheet LESSON 3 : Aggregate Function COUNT() SELECT COUNT(*) FROM employees WHERE experience 5;

■ 코드카데미(codecademy) SQL 연습해보기 https://www.codecademy.com/courses/learn-sql/ ■ Cheating Sheets https://www.codecademy.com/learn/learn-sql/modules/learn-sql-queries/cheatsheet LESSON 2 : QUERIES SELECT SELECT name, genre, year FROM movies; AS SELECT imdb_rating AS "IMDb" FROM movies; DISTINCT SELECT DISTINCT year FROM movies; WHERE SELECT * FROM movies WHERE year > 2014; LIKE BETWEEN SELECT * FROM..

https://pixabay.com/ko/ 원하는 사진이나 일러스트를 무료로 사용할 수 있으며, 제공자에게 기부도 가능하다. 아래는 대문사진으로 활용