Database/Fundamentals3 Databases and SQL for Data Science with Python (2/2) (from Coursera) * 저번 Database & SQl posting에 이어서..! 내용 계속 진행🎉 Databases and SQL for Data Science with Python (1/2) (from Coursera) 1) Getting Started with SQL Q1) What is SQL? (Structured English Query Language) = a language used for relational databases to query or get data out of a database - 더 자세한 설명은 하단 포스팅 참.. sh-avid-learner.tistory.com 4) Accessing Databases using Python SQL API consists of library funct.. Database/Fundamentals 2022. 4. 19. Databases and SQL for Data Science with Python (1/2) (from Coursera) 1) Getting Started with SQL Q1) What is SQL? (Structured English Query Language) = a language used for relational databases to query or get data out of a database - 더 자세한 설명은 하단 포스팅 참조 - why SQL? & Relational Databases 🧡 Structured Query Language 🧡 🦄 1970년대에 등장했으면 다소 '올드하다'는 이미지를 가져다 줄 수 있겠지만, 전 세계 기업들 - 페이스북, 인스타, 에어비앤비, 우버 등등 -이 보유한 대용량의 data는 sh-avid-learner.tistory.com Q2) What is a Database.. Database/Fundamentals 2022. 4. 18. Tabular Data 🗄️ Tabular Data is... 1. Data organized into a table2. Table is a grid of data3. Column must be same type (homogenous data)4. (but) Row can contain many types (heterogenous data)(ofc each elements of the tabular data has different types) - Tabular Data example - Tabular Data is composed of... 1) observations - a row2) variables - a column3) relationships - relationship between the tables (connecte.. Database/Fundamentals 2022. 3. 26. 이전 1 다음
