VOOZH about

URL: https://www.coursera.org/learn/sql-practical-introduction-for-querying-databases

⇱ SQL: A Practical Introduction for Querying Databases | Coursera

SQL: A Practical Introduction for Querying Databases

Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.

SQL: A Practical Introduction for Querying Databases

This course is part of multiple programs.

80,002 already enrolled

Included with

Gain insight into a topic and learn the fundamentals.
4.7

711 reviews

Beginner level

Recommended experience

Flexible schedule
2 weeks at 10 hours a week
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
4.7

711 reviews

Beginner level

Recommended experience

Flexible schedule
2 weeks at 10 hours a week
Learn at your own pace

What you'll learn

  • Analyze data within a database using SQL.

  • Create a relational database on Cloud and work with tables.

  • Write SQL statements including SELECT, INSERT, UPDATE, and DELETE.

  • Build more powerful queries with advanced SQL techniques like views, transactions, stored procedures and joins.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

15 assignments¹

AI Graded see disclaimer
Taught in English
95%
Most learners liked this course

Build your subject-matter expertise

This course is available as part of
When you enroll in this course, you'll also be asked to select a specific program.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate from IBM

There are 5 modules in this course

Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and manipulating data in databases. A working knowledge of databases and SQL is a must for anyone who wants to start a career in Data Engineering, Data Warehousing, Data Analytics, Data Science or Business Intelligence. The purpose of this course is to help you learn and apply foundational and intermediate knowledge of the SQL language, and become familiar with many relational database (RDBMS) concepts along the way.

You will start with performing basic Create, Read, Update and Delete (CRUD) operations using CREATE, SELECT, INSERT, UPDATE and DELETE statements. You will then learn to filter, order, sort, and aggregate data. You will work with functions, perform sub-selects and nested queries, as well as JOIN data in multiple tables. You will also work with VIEWS, transactions and create stored procedures. The emphasis in this course is on hands-on, practical learning. As such, you will work with real database systems, use real tools, and real-world datasets. You will create a database instance in the cloud. Through a series of hands-on labs, you will practice building and running SQL queries. At the end of the course you will apply and demonstrate your skills with a final project. The SQL skills you learn in this course will be applicable to a variety of RDBMSes such as MySQL, PostgreSQL, IBM Db2, Oracle, SQL Server and others. No prior knowledge of databases, SQL or programming is required, however some basic data literacy is beneficial.

In this module, you will be introduced to databases. You will create a database instance on the cloud. You will learn some of the basic SQL statements. You will also write and practice basic SQL hands-on on a live database.

What's included

6 videos2 readings2 assignments3 app items1 plugin

6 videos•Total 19 minutes
  • Course Introduction•3 minutes
  • Introduction to Databases•4 minutes
  • SELECT Statement•4 minutes
  • COUNT, DISTINCT, LIMIT•3 minutes
  • INSERT Statement•3 minutes
  • UPDATE and DELETE Statements•3 minutes
2 readings•Total 10 minutes
  • Course Overview•5 minutes
  • Summary & Highlights•5 minutes
2 assignments•Total 24 minutes
  • Graded Quiz: Basic SQL•9 minutes
  • Practice Quiz: Basic SQL•15 minutes
3 app items•Total 75 minutes
  • Hands-on Lab: Simple SELECT Statements•20 minutes
  • Hands-on Lab: COUNT, DISTINCT, LIMIT•35 minutes
  • Hands-on Lab: INSERT, UPDATE, and DELETE•20 minutes
1 plugin•Total 5 minutes
  • SELECT statement examples•5 minutes

In this module, you will explore the fundamental concepts behind databases, tables, and the relationships between them. You will then create an instance of a database, discover SQL statements that allow you to create and manipulate tables, and then practice them on your own live database.

What's included

5 videos2 readings2 assignments3 app items5 plugins

5 videos•Total 22 minutes
  • Relational Database Concepts•6 minutes
  • Types of SQL statements (DDL vs. DML)•2 minutes
  • CREATE TABLE Statement•4 minutes
  • ALTER, DROP, and Truncate tables•4 minutes
  • How to create a Database instance on Cloud•6 minutes
2 readings•Total 6 minutes
  • Optional Db2 Labs•1 minute
  • Summary & Highlights•5 minutes
2 assignments•Total 24 minutes
  • Graded Quiz: Relational DB Concepts and Tables•9 minutes
  • Practice Quiz: Relational DB Concepts and Tables•15 minutes
3 app items•Total 50 minutes
  • Hands-on Lab : CREATE, ALTER, TRUNCATE, DROP•20 minutes
  • Hands-on Lab: Create and Load Tables using SQL Scripts•20 minutes
  • Obtain IBM Cloud Feature Code and Activate Trial Account•10 minutes
5 plugins•Total 90 minutes
  • Examples to ALTER and TRUNCATE tables using MySQL•15 minutes
  • Examples to CREATE and DROP tables•15 minutes
  • (Optional) Db2 Lab: Create Db2 service instance and Get started with the Db2 console•15 minutes
  • (Optional) Db2 Lab: CREATE, ALTER, TRUNCATE, DROP•15 minutes
  • (Optional) Db2 Lab: Create and Load Tables using SQL Scripts•30 minutes

In this module, you will learn how to use string patterns and ranges to search data and how to sort and group data in result sets. You will also practice composing nested queries and execute select statements to access data from multiple tables.

What's included

7 videos2 readings4 assignments4 app items4 plugins

7 videos•Total 32 minutes
  • Using String Patterns and Ranges•4 minutes
  • Sorting Result Sets•3 minutes
  • Grouping Result Sets•4 minutes
  • Built-in Database Functions•6 minutes
  • Date and Time Built-in Functions•3 minutes
  • Sub-Queries and Nested Selects•5 minutes
  • Working with Multiple Tables•7 minutes
2 readings•Total 10 minutes
  • Summary & Highlights•5 minutes
  • Summary & Highlights•5 minutes
4 assignments•Total 48 minutes
  • Graded Quiz: Refining Your Results•9 minutes
  • Graded Quiz: Functions, Sub-Queries, Multiple Tables•9 minutes
  • Practice Quiz: Refining Your Results•15 minutes
  • Practice Quiz: Functions, Sub-Queries, Multiple Tables•15 minutes
4 app items•Total 80 minutes
  • Hands-on Lab: String Patterns, Sorting and Grouping•20 minutes
  • Hands-on Lab: Built-in functions•20 minutes
  • Hands-on Lab : Sub-queries and Nested SELECTS•20 minutes
  • Hands-on Lab: Working with Multiple Tables•20 minutes
4 plugins•Total 100 minutes
  • (Optional) Db2 Lab : String Patterns, Sorting & Grouping•35 minutes
  • (Optional) Db2 Lab: Built-in functions•15 minutes
  • (Optional) Db2 Lab: Sub-queries and Nested SELECTs •20 minutes
  • (Optional) Db2 Lab: Working with Multiple Tables  •30 minutes

In this assignment, you will be working with multiple real world datasets for the city of Chicago. You will be asked questions that will help you understand the data just as you would in the real wold. You will be assessed on the correctness of your SQL queries and results.

What's included

2 videos2 assignments2 app items4 plugins

2 videos•Total 10 minutes
  • Working with Real World Datasets•6 minutes
  • Getting Table and Column Details•5 minutes
2 assignments•Total 90 minutes
  • Project Evaluation (Quiz)•30 minutes
  • Final Exam•60 minutes
2 app items•Total 40 minutes
  • Hands-on Lab: Working with a real world data-set•20 minutes
  • Hands-on Lab: Final Project•20 minutes
4 plugins•Total 77 minutes
  • (Optional) LOADing Data•15 minutes
  • (Optional) Db2 Lab: Working with a Real World Dataset using SQL and IBM Cloud Db2 •45 minutes
  • Final Project Overview•2 minutes
  • (Optional) Db2 Lab: Exploratory Data Analysis with SQL•15 minutes

This module covers some advanced SQL techniques that will be useful for Data Engineers. If you are following the Data Engineering track, you must complete this module. In this module, you will learn how to build more powerful queries with advanced SQL techniques like views, transactions, stored procedures and joins.

What's included

6 videos5 readings5 assignments6 app items6 plugins

6 videos•Total 23 minutes
  • Views•4 minutes
  • Stored Procedures•3 minutes
  • ACID Transactions•4 minutes
  • Join Overview•4 minutes
  • Inner Join•3 minutes
  • Outer Joins•6 minutes
5 readings•Total 15 minutes
  • About this Module•2 minutes
  • Summary & Highlights•5 minutes
  • Summary & Highlights•5 minutes
  • Congratulations & Next Steps•2 minutes
  • Course Team•1 minute
5 assignments•Total 90 minutes
  • Graded Quiz: Views, Stored Procedures and Transactions •15 minutes
  • Graded Quiz: JOIN operations •15 minutes
  • Graded Quiz: Advanced SQL for Data Engineers•30 minutes
  • Practice Quiz: Views,Stored Procedures and Transactions•15 minutes
  • Practice Quiz: JOIN operations•15 minutes
6 app items•Total 160 minutes
  • Hands-on Lab: Using Views•20 minutes
  • Hands-on Lab: Stored Procedures•20 minutes
  • Hands-on Lab: Committing and Rolling back a Transaction•20 minutes
  • Hands-on Lab: Joins•20 minutes
  • Practice Lab: Joins•20 minutes
  • Hands-on Lab:Final Project: Advanced SQL Techniques•60 minutes
6 plugins•Total 145 minutes
  • (Optional) Db2 Lab: Using Views•10 minutes
  • (Optional) Db2 Lab: Stored Procedures•10 minutes
  • (Optional) Db2 Lab: Committing and rolling back a transaction•10 minutes
  • (Optional) Db2 Lab: Joins•25 minutes
  • (Optional) Db2 Lab: Joins•30 minutes
  • (Optional) Db2 Final Project: Advanced SQL for Data Engineers•60 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings
4.6 (172 ratings)
IBM
55 Courses•5,141,442 learners

Offered by

Explore more from Data Analysis

Why people choose Coursera for their career

👁 Image

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
👁 Image

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
👁 Image

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
👁 Image

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

  • 5 stars

    77.38%

  • 4 stars

    16.57%

  • 3 stars

    2.94%

  • 2 stars

    0.98%

  • 1 star

    2.10%

Showing 3 of 711

BB
·

Reviewed on May 24, 2025

i have completed the whole course but then also i am noy getting any certificate downloading option

AI
·

Reviewed on Feb 13, 2025

THE COURSE WAS GREAT I LEARNED ALOT BUT IT CAN BE IMPROVED THROUGH GOING DEEPER TO EACH AND EVERY BASIC CONCEPT

FF
·

Reviewed on Dec 27, 2022

This course is very useful and straightforward. Unfortunately, I couldn't download my Honor Certificate although I completed and passed all the courses including the extra to get the Honor

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. 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.

When you enroll in the course, you get access to all of the courses in the Certificate, 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.

Financial aid available,

¹ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.