SQL Server REGEX Complete Tutorial with Practice Exercises

SQL Server REGEX Complete Tutorial with Practice Exercises, available at $19.99, has an average rating of 4.5, with 9 lectures, 1 quizzes, based on 11 reviews, and has 1460 subscribers.

You will learn about Learn SQL REGEX operations in SQL Server (match on single/multiple , alpha/numeric characters) , position specific matches Understand different kinds of wildcards for Regular Expression. Write SQL Queries for Pattern Matching. Master Regex expressions with lots of Practice Exercises. This course is ideal for individuals who are Beginner / Intermediate SQL Learners It is particularly useful for Beginner / Intermediate SQL Learners.

Enroll now: SQL Server REGEX Complete Tutorial with Practice Exercises

Summary

Title: SQL Server REGEX Complete Tutorial with Practice Exercises

Price: $19.99

Average Rating: 4.5

Number of Lectures: 9

Number of Quizzes: 1

Number of Published Lectures: 9

Number of Published Quizzes: 1

Number of Curriculum Items: 10

Number of Published Curriculum Objects: 10

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Learn SQL REGEX operations in SQL Server (match on single/multiple , alpha/numeric characters) , position specific matches

Understand different kinds of wildcards for Regular Expression.

Write SQL Queries for Pattern Matching.

Master Regex expressions with lots of Practice Exercises.

Who Should Attend

Beginner / Intermediate SQL Learners

Target Audiences

Beginner / Intermediate SQL Learners

In this course, we will learn about SQL REGEX operations in SQL Server database.

We will learn about pattern matching and how to use the wildcards.

We will learn how to use the following wildcards –

% – Any string of zero or more characters.

_ (underscore) Any single character.

[ ] Any single character within the specified range

[^] Any single character not within the specified range

All examples are base don the AdventureWorksLT database from Microsoft.

The table is SalesLt.Product.

You can download it from the Microsoft Website.

Select * from SalesLT.Product

Examples –

% – Any string of zero or more characters.

Example 1 –    Name with ‘Bike’

_ (underscore) Any single character.

Example 2 –  Second character is ‘R’

   Third character is ‘-‘ and 4th character is ‘U’

  Check for Product Number pattern

Example 3 –   Any 2 characters followed by ‘-‘ followed

Example 4 –   by any 4 characters followed by ‘-‘ followed

Example 5 –   by any single character  – HL-U509-R

[ ] Any single character within the specified range

Example 6 –    Above pattern with last char L or M

Example 7 –   Above pattern with last char between L and S

Example 8 –    Above pattern with last char between L and R

[^] Any single character not within the specified range

Example 9 –    Above pattern with last char not between L and R

Example 10 –     Product number not starting with F

Example 11 –    Product number not starting with F or H

Example 12 –     Product NUmber not starting between A to H.

Example 13 – Data(Size) is Only One Character and Value is from A to Z

Example 14 – Data(Size) is Two Characters and Values are from A to Z

Example 15 – Text(rowguid) Rows Starting with a Number

Example 16 – Find a Number Pattern –

Product Number with 4th and 5th chars as numbers

Example 17 – Number(List Price) with two decimal places ending in 2

Using the Not Character for Regex with T-SQL

Example 18 Product Number – after 1st hyphen has either numbers or special characters

Example 19 – Name has Only alphabetic characters

Example 20 – Name has No special characters

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: SQL Regex Complete Tutorial with Practice Exercises

Lecture 3: SQL Queries Learned so far.

Lecture 4: More Practice SQL Queries

Lecture 5: This Quiz will trick you!

Lecture 6: Test – Can you answer this Question now?

Lecture 7: More SQL Functions for Pattern Matching

Lecture 8: Difference Between PATINDEX and CHARINDEX

Lecture 9: SQL – Pattern Matching with CHARINDEX – Case Scenario- Emails

Instructors

Kriti Chauhan
Data Analytics Instructor at Udemy

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 3 votes

4 stars: 2 votes

5 stars: 6 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!