University of California, Davis
SQL for Data Science
面向数据科学的 SQL
- 专项课程Learn SQL Basics for Data Science学习数据科学的 SQL 基础知识第 1 门 · 共 3 门
Module 01Getting Started and Selecting & Retrieving Data with SQL
0 / 13 篇
- 01Course Introduction
- 02Course Navigation and Online Safety Statement
- 03What is SQL Anyway?
- 04Data Models, Part 1: Thinking About Your Data
- 05Data Models, Part 2: The Evolution of Data Models
- 06Data Models, Part 3: Relational vs. Transactional Models
- 07Retrieving Data with a SELECT Statement
- 08Creating Tables
- 09Creating Temporary Tables
- 10Adding Comments to SQL
- 11Summary
- 12SQL Overview
- 13Data Modeling and ER Diagrams
Module 02Filtering, Sorting, and Calculating Data with SQL
0 / 11 篇
- 01Module Introduction
- 02Basics of Filtering with SQL
- 03Advanced Filtering: IN, OR, and NOT
- 04Using Wildcards in SQL
- 05Sorting with ORDER BY
- 06Math Operations
- 07Aggregate Functions
- 08Grouping Data with SQL
- 09Putting it All Together
- 10SQL for Various Data Science Languages
- 11More About Aggregate Functions
Module 03Subqueries and Joins in SQL
0 / 12 篇
- 01Module Introduction
- 02Using Subqueries
- 03Subquery Best Practices and Considerations
- 04Joining Tables: An Introduction
- 05Cartesian (Cross) Joins
- 06Inner Joins
- 07Aliases and Self Joins
- 08Advanced Joins: Left, Right, and Full Outer Joins
- 09Unions
- 10Summary
- 11SQL and Python
- 12Union and Union All
Module 04Modifying and Analyzing Data with SQL
0 / 15 篇
- 01Module Introduction
- 02Working with Text Strings
- 03Working with Date and Time Strings
- 04Date and Time Strings Examples
- 05Case Statements
- 06Views
- 07Data Governance and Profiling
- 08Using SQL for Data Science, Part 1
- 09Using SQL for Data Science, Part 2
- 10Additional SQL Resources to Explore
- 11Final Project Instructions, Scripts, & Datasets
- 12Final Project Study Guide and Skills Checklist
- 13USDA Acknowledgment
- 14USDA Acknowledgment Video
- 15Course Summary