Buy Now AED 344.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

The Structured Query Language (SQL)
  • Level Foundation
  • المدة 55 ساعات hours
  • الطبع بواسطة University of Colorado Boulder
  • Offered by

عن

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.

الوحدات

Welcome to The Structured Query Language (SQL)

    • 1 Videos
    • 2 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Introduce Yourself!

1 Videos

  • Overview of Course, Intro to Instructor

2 Readings

  • Earn Academic Credit for your Work!
  • Course Support

The Origins of SQL

    • 1 Videos
    • 1 Discussion
    • 1 Quiz
Show info about module content

1 Discussions

  • Module 1

1 Videos

  • The Origins of SQL

1 Quiz

  • Old, but Widely Used

The Relational Algebra

    • 1 Videos
    • 1 Quiz
Show info about module content

1 Videos

  • The Relational Algebra

1 Quiz

  • Understanding Relational Algebra Terms

ANSI Standard SQL

    • 1 Videos
Show info about module content

1 Videos

  • The SQL Standard

Preparing SQL for Execution

    • 1 Videos
    • 1 Quiz
Show info about module content

1 Videos

  • What Happens When I Execute a Query?

1 Quiz

  • SQL Query Execution Terms

Our Lab Environment

    • 1 Videos
    • 1 Lab
Show info about module content

1 Labs

  • pgAdmin Lab Environment

1 Videos

  • Our Coursera Lab Environment

The Basic SELECT Statement

    • 1 Videos
    • 2 Readings
    • 1 Quiz
Show info about module content

1 Videos

  • The Basic SELECT Clause

2 Readings

  • Lab 1: Coding Your First SELECT Statements
  • Lab 1: Solutions

1 Quiz

  • Unlock Lab 1 Solutions

The WHERE Clause - Selecting a Subset of Rows

    • 1 Videos
    • 2 Readings
    • 1 Quiz
Show info about module content

1 Videos

  • The WHERE Clause and Conditions

2 Readings

  • Lab 2: Adding Conditions Using the WHERE Clause
  • Lab 2: Solutions

1 Quiz

  • Unlock Lab 2 Solutions

Managing your answer set

    • 1 Videos
    • 1 Quiz
Show info about module content

1 Videos

  • The ORDER BY and DISTINCT

1 Quiz

  • Adjusting Your Output

DATES and NULLS

    • 1 Videos
    • 2 Readings
    • 1 Discussion
    • 1 Quiz
Show info about module content

1 Discussions

  • Module 2

1 Videos

  • How Does SQL Handle DATES and NULLS

2 Readings

  • Lab 3: Date Functions and Nulls
  • Lab 3: Solutions

1 Quiz

  • Unlock Lab 3 Solutions

Assessments

    • 1 Quiz
Show info about module content

1 Quiz

  • The Basic SELECT Statement

The Five GROUP Functions

    • 1 Videos
    • 1 Quiz
Show info about module content

1 Videos

  • The Five GROUP Functions

1 Quiz

  • Using the Group Functions

Creating Totals and Subtotals with the GROUP BY

    • 1 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

1 Videos

  • Creating Totals and Subtotals

2 Readings

  • Lab 4: Using the GROUP BY
  • Lab 4: Solutions

2 Quiz

  • Understanding the RULES
  • Unlock Lab 4 Solutions

Using Sub Queries

    • 1 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

1 Videos

  • SubQueries - Three Different Forms

2 Readings

  • Lab 5: Practice Using Subqueries
  • Lab 5: Solutions

2 Quiz

  • Differentiating Types of Subqueries
  • Unlock Lab 5 Solutions

Assessments

    • 1 Quiz
Show info about module content

1 Quiz

  • Group Functions and SubQueries

The INNER JOIN

    • 1 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

1 Videos

  • JOIN Syntax

2 Readings

  • Lab 6: Inner JOINS
  • Lab 6: Solutions

2 Quiz

  • Understanding JOINs
  • Unlock Lab 6 Solutions

Joining More than Two Tables

    • 1 Videos
Show info about module content

1 Videos

  • Three-Way JOIN

The Cartesian Product

    • 1 Videos
    • 1 Quiz
Show info about module content

1 Videos

  • The Cartesian Product - an Easy Error

1 Quiz

  • JOIN Conditions

The OUTER JOIN

    • 1 Videos
    • 2 Readings
    • 1 Discussion
    • 1 Quiz
Show info about module content

1 Discussions

  • Module 4

1 Videos

  • When an OUTER JOIN is Needed

2 Readings

  • Lab 7: Outer JOINS
  • Lab 7: Solutions

1 Quiz

  • Unlock Lab 7 Solutions

Assessments

    • 1 Quiz
Show info about module content

1 Quiz

  • Joins

Creating Tables with the CREATE Statement

    • 1 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

1 Videos

  • CREATE Statement - Data Types

2 Readings

  • Lab 8: Creating Tables
  • Lab 8: Solutions

2 Quiz

  • Understanding Data Types
  • Unlock Lab 8 Solutions

Understanding CONSTRAINTS

    • 1 Videos
Show info about module content

1 Videos

  • Database Constraints

Modifying Database Objects with the ALTER Statement

    • 1 Videos
    • 2 Readings
    • 1 Quiz
Show info about module content

1 Videos

  • Making Changes with the ALTER

2 Readings

  • Lab 9: Modifying Tables and Columns with ALTER
  • Lab 9: Solutions

1 Quiz

  • Unlock Lab 9 Solutions

INSERT, UPDATE, DELETE, DROP

    • 1 Videos
    • 2 Readings
    • 1 Quiz
Show info about module content

1 Videos

  • Adding, Changing, Deleting Data

2 Readings

  • Lab 10: Practicing DML
  • Lab 10: Solutions

1 Quiz

  • Unlock Lab 10 Solutions

Assessments

    • 1 Quiz
Show info about module content

1 Quiz

  • DDL and DML

VIEWs

    • 1 Videos
    • 2 Readings
    • 1 Quiz
Show info about module content

1 Videos

  • Creating and Using VIEWs

2 Readings

  • Lab 11: Using a VIEW
  • Lab 11: Solutions

1 Quiz

  • Unlock Lab 11 Solutions

CASE

    • 1 Videos
    • 2 Readings
    • 1 Quiz
Show info about module content

1 Videos

  • The CASE Statement

2 Readings

  • Lab 12: Conditionals with the CASE Operator
  • Lab 12: Solutions

1 Quiz

  • Unlock Lab 12 Solutions

UNION

    • 1 Videos
Show info about module content

1 Videos

  • Joining Answer Sets with the UNION

Identity

    • 1 Videos
Show info about module content

1 Videos

  • Creating Unique Keys with IDENTITY

Final Assessment

    • 2 Readings
    • 2 Quiz
    • 1 PeerReview
Show info about module content

1 Peer Review

  • Final Comprehensive SQL Reflection

2 Readings

  • Final Lab
  • Final Lab: Solutions

2 Quiz

  • Some Advanced SQL
  • Unlock Final Lab Solutions

Summary and Wrap-Up

    • 1 Videos
    • 1 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Module 6

1 Videos

  • Wrap-Up

1 Readings

  • Links from Wrap-Up Video

Auto Summary

Discover the foundations of SQL in this engaging Data Science & AI course. Led by expert instructors, you'll learn the origins, standard commands, syntax, and data analysis techniques essential for relational databases. Ideal for beginners and part of CU Boulder's MS-DS degree on Coursera, this comprehensive 3300-minute course offers flexible subscription options: Starter, Professional, and Paid. Perfect for aspiring data scientists and professionals in computer science, information science, mathematics, and statistics. Enroll today to master SQL!

Alan Paradise
Instructor

Alan Paradise