The Structured Query Language (SQL) by Coursera
This course is part of Databases for Data Scientists Specialization
Course Highlights
- The origins and historical basis for SQL.
- Standard SQL use and syntax.
- How to code SQL queries in order to analyze data stored in relational databases.
Skills you will learn!
Curriculum
12 Topics
Overview of Course Intro to Instructor
The Origins of SQL
The Relational Algebra
The SQL Standard
What Happens When I Execute a Query?
Earn Academic Credit for your Work!
Course Support
Old but Widely Used
Understanding Relational Algebra Terms
SQL Query Execution Terms
Introduce Yourself!
Module 1
18 Topics
Our Coursera Lab Environment
The Basic SELECT Clause
The WHERE Clause and Conditions
The ORDER BY and DISTINCT
How Does SQL Handle DATES and NULLS
Lab 1: Coding Your First SELECT Statements
Lab 1: Solutions
Lab 2: Adding Conditions Using the WHERE Clause
Lab 2: Solutions
Lab 3: Date Functions and Nulls
Lab 3: Solutions
Adjusting Your Output
Unlock Lab 1 Solutions
Unlock Lab 2 Solutions
Unlock Lab 3 Solutions
The Basic SELECT Statement
Module 2
pgAdmin Lab Environment
13 Topics
The Five GROUP Functions
Creating Totals and Subtotals
SubQueries - Three Different Forms
Lab 4: Using the GROUP BY
Lab 4: Solutions
Lab 5: Practice Using Subqueries
Lab 5: Solutions
Using the Group Functions
Understanding the RULES
Differentiating Types of Subqueries
Unlock Lab 4 Solutions
Unlock Lab 5 Solutions
Group Functions and SubQueries
14 Topics
JOIN Syntax
Three-Way JOIN
The Cartesian Product - an Easy Error
When an OUTER JOIN is Needed
Lab 6: Inner JOINS
Lab 6: Solutions
Lab 7: Outer JOINS
Lab 7: Solutions
Understanding JOINs
JOIN Conditions
Unlock Lab 6 Solutions
Unlock Lab 7 Solutions
Joins
Module 4
15 Topics
CREATE Statement - Data Types
Database Constraints
Making Changes with the ALTER
Adding Changing Deleting Data
Lab 8: Creating Tables
Lab 8: Solutions
Lab 9: Modifying Tables and Columns with ALTER
Lab 9: Solutions
Lab 10: Practicing DML
Lab 10: Solutions
Understanding Data Types
Unlock Lab 8 Solutions
Unlock Lab 9 Solutions
Unlock Lab 10 Solutions
DDL and DML
18 Topics
Creating and Using VIEWs
The CASE Statement
Joining Answer Sets with the UNION
Creating Unique Keys with IDENTITY
Wrap-Up
Lab 11: Using a VIEW
Lab 11: Solutions
Lab 12: Conditionals with the CASE Operator
Lab 12: Solutions
Final Lab
Final Lab: Solutions
Links from Wrap-Up Video
Unlock Lab 11 Solutions
Unlock Lab 12 Solutions
Some Advanced SQL
Unlock Final Lab Solutions
Final Comprehensive SQL Reflection
Module 6
The Structured Query Language (SQL)
Related SQL Courses
Thank You!
Your review has been submitted successfully.