This course is part of the Databases for Data Scientists Specialization

4.7
stars
341 ratings

Alan Paradise

22,493 already enrolled

Offered By

Want to earn credit towards a degree? Find out how

You can earn credits from the University of Colorado Boulder that count towards a Master of Science in Data Science

Databases for Data Scientists SpecializationUniversity of Colorado Boulder

About this Course

246,626 recent views

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 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. Learn more about the MS-DS program at https://www.coursera.org/degrees/master-of-science-data-science-boulder.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 2 of 3 in the

Databases for Data Scientists Specialization

Beginner Level

Successful completion of Relational Database Design (Databases for Data Scientists, Course 1) recommended.

Approx. 25 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

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

Skills you will gain

Data Science
Database (DBMS)
Database Application
SQL (Structured Query Language)
database administration

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 2 of 3 in the

Databases for Data Scientists Specialization

Beginner Level

Successful completion of Relational Database Design (Databases for Data Scientists, Course 1) recommended.

Approx. 25 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

4.83/5 (154 Ratings)

Alan Paradise

Offered by

University of Colorado Boulder

Start working towards your Master's degree

This course is part of the 100% online Master of Science in Data Science from University of Colorado Boulder. If you are admitted to the full program, your courses count towards your degree learning.

Learn More

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Content Rating96%(1,744 ratings)

Week

Week 1

2 hours to complete

Introduction to SQL - Structured Query Language

2 hours to complete

5 videos (Total 64 min), 1 reading, 3 quizzes

Week

Week 2

6 hours to complete

The Basic SELECT Statement

6 hours to complete

5 videos (Total 78 min), 7 readings, 5 quizzes

5 videos

Our "bit.io" Lab Environment9m

The Basic SELECT Clause16m

The WHERE Clause and Conditions17m

The ORDER BY and DISTINCT10m

How Does SQL Handle DATES and NULLS24m

7 readings

Changes to Our Lab Environment10m

Lab 1: Coding Your First SELECT Statements1h

Lab 1: Solutions 10m

Lab 2: Adding Conditions Using the WHERE Clause1h

Lab 2: Solutions10m

Lab 3: Date Functions and Nulls1h

Lab 3: Solutions 10m

5 practice exercises

Unlock Lab 1 Solutions 1m

Unlock Lab 2 Solutions 1m

Adjusting Your Output10m

Unlock Lab 3 Solutions 1m

The Basic SELECT Statement20m

Week

Week 3

4 hours to complete

Group Functions, SubTotals, and Subqueries

4 hours to complete

3 videos (Total 49 min), 4 readings, 6 quizzes

3 videos

The Five GROUP Functions 19m

Creating Totals and Subtotals14m

SubQueries - Three Different Forms14m

4 readings

Lab 4: Using the GROUP BY1h

Lab 4: Solutions10m

Lab 5: Practice Using Subqueries1h

Lab 5: Solutions 10m

6 practice exercises

Using the Group Functions10m

Understanding the RULES10m

Unlock Lab 4 Solutions 1m

Differentiating Types of Subqueries10m

Unlock Lab 5 Solutions 1m

Group Functions and SubQueries20m

Week

Week 4

4 hours to complete

Getting Data from Multiple Tables

4 hours to complete

4 videos (Total 44 min), 4 readings, 5 quizzes

Reviews

4.7

100 reviews

5 stars
80.93%
4 stars
14.95%
3 stars
1.75%
2 stars
0.58%
1 star
1.75%

TOP REVIEWS FROM THE STRUCTURED QUERY LANGUAGE (SQL)

by OGJul 13, 2022

Good course to start with basics od databases and structured query lenguage.

Thanks

by PPNov 6, 2022

This was the great time to learn about SQL and i am Very happy from the course contain.

by DLJan 16, 2023

Good refresher for the basic stuff, explained it in new and helpful ways, and great introduction to some more advanced SQL

by NBMay 15, 2022

A very good course going through all the basics for writing SQL commands. A great refresher for me as I have not done any SQL in about 2 years.

View all reviews

About the Databases for Data Scientists Specialization

Whether you are a beginning programmer with an interest in Data Science, a data scientist working closely with content experts, or a software developer seeking to learn about the database layer of the stack this specialization is for you! We focus on the relational database which is the most widely used type of database. Relational databases have dominated the database software marketplace for nearly four decades and form a core, foundational part of software development. In this specialization you will learn about database design, database software fundamentals, and how to use the Structured Query Language (SQL) to work with databases. The specialization, will conclude with an overview of future trends in databases, including non-relational databases (NoSQL) and Big Data. Upon completion of this specialization you will be well prepared to design and create efficient and effective relational databases, fill them with data, and work with them using SQL.

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

The Structured Query Language (SQL)

About this Course

What you will learn

Skills you will gain