MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.
The Structured Query Language (SQL) can be taken for academic credit as part of CU Boulder’s Master of Science in Data Science (MS-DS) degree offered on the Coursera platform. The MS-DS is an interdisciplinary degree that brings together faculty from CU Boulder’s departments of Applied Mathematics, Computer Science, Information Science, and others. With performance-based admissions and no application process, the MS-DS is ideal for individuals with a broad range of undergraduate education and/or professional experience in computer science, information science, mathematics, and statistics.
What You Will Learn
- 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
Syllabus
WEEK 1
Introduction to SQL - Structured Query Language
The origins of SQL, what it is and how it works.
WEEK 2
The Basic SELECT Statement
The SELECT statement - retrieving data from your database.
WEEK 3
Group Functions, SubTotals, and Subqueries
The five GROUP functions.
WEEK 4
Getting Data from Multiple Tables
Using the JOIN.
WEEK 5
DDL and DML
SQL Statements: beyond the SELECT.
WEEK 6
Advanced SQL Commands
Some more advanced SQL capabilities.
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.