Getting Started and Selecting & Retrieving Data with SQL-Getting Started
Course Introduction
()
Getting Started and Selecting & Retrieving Data with SQL-Selecting and Retrieving Data with SQL
Module Introduction
()
What is SQL Anyway?
()
Data Models, Part 1: Thinking About Your Data
()
Data Models, Part 2: The Evolution of Data Models
()
Data Models, Part 3: Relational vs. Transactional Models
()
Retrieving Data with a SELECT Statement
()
Creating Tables
()
Creating Temporary Tables
()
Adding Comments to SQL
()
Summary
()
SQL Overview
Data Modeling and ER Diagrams
Filtering, Sorting, and Calculating Data with SQL-Filtering, Sorting, and Calculating Data with SQL
Module Introduction
()
Basics of Filtering with SQL
()
Advanced Filtering: IN, OR, and NOT
()
Using Wildcards in SQL
()
Sorting with ORDER BY
()
Math Operations
()
Aggregate Functions
()
Grouping Data with SQL
()
Putting it All Together
()
SQL for Various Data Science Languages
Subqueries and Joins in SQL-Subqueries and Joins in SQL
Module Introduction
()
Using Subqueries
()
Subquery Best Practices and Considerations
()
Joining Tables: An Introduction
()
Cartesian (Cross) Joins
()
Inner Joins
()
Aliases and Self Joins
()
Advanced Joins: Left, Right, and Full Outer Joins
()
Unions
()
Summary
()
SQL and Python
Union and Union All
Modifying and Analyzing Data with SQL-Modifying and Analyzing Data with SQL
Module Introduction
()
Working with Text Strings
()
Working with Date and Time Strings
()
Date and Time Strings Examples
()
Case Statements
()
Views
()
Data Governance and Profiling
()
Using SQL for Data Science, Part 1
()
Using SQL for Data Science, Part 2
()
Additional SQL Resources to Explore
Modifying and Analyzing Data with SQL-Peer Review Assignment
Welcome to Peer Review Assignments!
Yelp Dataset SQL Lookup
Modifying and Analyzing Data with SQL-Course Summary
Course Summary
()