最近开始初步学习SQL,在Coursera上找到了UCD的SQL for Data Science,个人感觉挺细致的,适合入门学习。这节课的视频里概念题很多,所以在这里把关键概念知识点和做过的Quiz和Coding题分享出来,希望同行者一起进步~
Week 1: Selecting & Retrieving Data with SQL
接 Week2: Coursera SQL for Data Science | Quiz答案, Week2_Spectre23c的博客-CSDN博客
接 Week3: Coursera SQL for Data Science | Quiz答案, Week3_Spectre23c的博客-CSDN博客
接 Week4: Coursera SQL for Data Science | Quiz答案, Week4_Spectre23c的博客-CSDN博客
目录
Keypoints
Data Models, Part 1: Thinking About Your Data
Databases: A container (usually a file or set of files) to store organized data; a set of related information
Tables: A structured list of data or a specific type
Column: A single field in a table - all tables are made up of one or more columns
Row: A record in a table
Data Models, Part 2: The Evolution of Data Models