Course

Introduction to Regular Expressions in SQL

Coursera Project Network

Welcome to this project-based course, Introduction to Regular Expressions in SQL. In this 2-and-a-half-hour-long project, you will learn how to use SQL regular expressions extensively for pattern matching to query tables in a database.

By the end of this project, you will be able to:

Perform extensive pattern matching using POSIX regular expressions
Use POSIX regular expressions functions to perform pattern matching

This project covers topics such as:

Revision of the use of the LIKE and NOT LIKE operators in the WHERE clause
Using different regular expression metacharacters together with POSIX operators in the WHERE clause

Additionally, you will work on exercises to reinforce your knowledge of the concepts. Prior experience with PostgreSQL and a good foundation for writing SQL queries is vital to complete this intermediate level project.

Certificate Available ✔

Get Started / More Info

Introduction to Regular Expressions in SQL

More Data Management Courses

BI Foundations with SQL, ETL and Data Warehousing

IBM

BI Foundations with SQL, ETL, and Data Warehousing is a comprehensive specialization designed to equip learners with the skills and knowledge needed for success...

Advanced MySQL Topics

Data Cleaning in SQL: Prepare Data for Analysis

Coursera Project Network

This course teaches data cleaning in SQL, focusing on detecting and removing duplicates, using CASE transformations, and handling Null values.

Use the Apache Spark Structured Streaming API with MongoDB

Coursera Project Network

Use the Apache Spark Structured Streaming API with MongoDB to stream and store data, and perform dataset joins with Python.