University of Colorado Boulder - The Structured Query Language (SQL)
4.8 /5- Offered byCoursera
- Public/Government Institute
The Structured Query Language (SQL) at Coursera Overview
Duration | 25 hours |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
The Structured Query Language (SQL) at Coursera Highlights
- Reset flexible deadlines in accordance to your schedule
Earn a Certificate upon completion
The Structured Query Language (SQL) at Coursera Course details
- In this course you will learn all about the Structured Query Language ("SQL".)
- We will review the origins of the language and its conceptual foundations
- But primarily, we will focus on learning all the standard SQL commands, their syntax, and how to use these commands to conduct analysis of the data within a relational database
- Our scope includes not only the SELECT statement for retrieving data and creating analytical reports, but also includes the DDL ("Data Definition Language") and DML ("Data Manipulation Language") commands necessary to create and maintain database objects
- 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 Structured Query Language (SQL) at Coursera Curriculum
Introduction to SQL - Structured Query Language
Overview of Course, Intro to Instructor
The Origins of SQL
The Relational Algebra
The SQL Standard
What Happens When I Execute a Query?
Welcome and Where to Find Help
Old, but Widely Used
Understanding Relational Algebra Terms
SQL Query Execution Terms
The Basic SELECT Statement
Our "bit.io" 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
Unlock Lab 1 Solutions
Unlock Lab 2 Solutions
Adjusting Your Output
Unlock Lab 3 Solutions
The Basic SELECT Statement
Group Functions, SubTotals, and Subqueries
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
Unlock Lab 4 Solutions
Differentiating Types of Subqueries
Unlock Lab 5 Solutions
Group Functions and SubQueries
Getting Data from Multiple Tables
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
Unlock Lab 6 Solutions
JOIN Conditions
Unlock Lab 7 Solutions
Joins
DDL and DML
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
Advanced SQL Commands
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
Unlock Lab 11 Solutions
Unlock Lab 12 Solutions
Some Advanced SQL
Unlock Final Lab Solutions
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?