Demo class 3: SQL Filtering Technique: Pattern Matching - betterskill.io Skip to main content

betterskill.io

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Save More with Bundle Courses

Menu
  • All Courses
    • Bundle Course
    • Research & Data Analytics Course
    • Office & productivity
    • Programming
Picture of Jaber
Menu
  • My Classroom
    • My Course
    • Profile Setting
    • Explore Course
Menu
  • login/Registration

Bundle Course

Menu
  • All Courses
    • Bundle Course
    • Research & Data Analytics Course
    • Office & productivity
    • Programming
Picture of Jaber
Menu
  • My Classroom
    • My Course
    • Profile Setting
    • Explore Course
Menu
  • login/Registration
SQL Mastery: Data Analytics & Business Intelligence Demo class 3: SQL Filtering Technique: Pattern Matching
SQL Mastery: Data Analytics & Business Intelligence
0% Completed
Demo Class: এখন থেকে দেখে নিন কোর্সের ডেমো ক্লাসগুলোকে
Demo class 1: What is SQL and why it matters
Video - 00:5:01 mins
Demo Class 2: Creating Table in SQL
Video - 00:10:01 mins
Demo class 3: SQL Filtering Technique: Pattern Matching
Video - 00:6:27 mins
Demo Class 4: Lag Function in SQL
Video - 00:3:17 mins
MODULE 1: Introduction to SQL & Databases
Lecture 1: Introduction
Video - 00:1:52 mins
Lecture 2: What is a database
Video - 00:4:13 mins
Lecture 3: Types of databases Relational vs NoSQL
Video - 00:3:55 mins
Lecture 4: What is SQL and why it matters
Video - 00:5:01 mins
Lecture 5: Real world use cases in data analytics
Video - 00:4:26 mins
For Instructor Support, Join here..
Reading
All Resources (Data & Codes)
Reading
MODULE 2: Database Setup & Table Creation
Lecture 1: Introduction
Video - 00:1:03 mins
Lecture 2: Understanding data types
Video - 00:4:29 mins
Lecture 3: Constraints
Video - 00:9:11 mins
Lecture 4: Installing and Setting Up SQL Environment
Video - 00:9:58 mins
Lecture 5: Creating databases
Video - 00:7:38 mins
Lecture 6: Creating tables
Video - 00:10:01 mins
Lecture 7: Alter Table
Video - 00:4:59 mins
Lecture 8: Drop Table
Video - 00:1:52 mins
MODULE 3: Data Insertion & Management
Lecture 1: Introduction
Video - 00:00:51 mins
Lecture 2: Insert Data into Table
Video - 00:14:27 mins
Lecture 3: Update Records
Video - 00:6:27 mins
Lecture 4: Deleting Record
Video - 00:4:32 mins
Lecture 5: TRUNCATE vs DELETE
Video - 00:5:56 mins
Lecture 6: Understanding and handling NULL values
Video - 00:8:57 mins
MODULE 4: Basic Data Retrieval
Lecture 1: Introduction
Video - 00:1:04 mins
Lecture 2: SELECT Statement
Video - 00:5:55 mins
Lecture 3: Selecting Specific Columns
Video - 00:3:51 mins
Lecture 4: Removing Duplicates with DISTINCT
Video - 00:2:33 mins
Lecture 5: Filtering Data using WHERE
Video - 00:3:38 mins
Lecture 6: Comparison Operators
Video - 00:5:18 mins
Lecture 7: Logical Operators
Video - 00:5:23 mins
MODULE 5: Sorting & Limiting Data
Lecture 1: Introduction
Video - 00:00:54 mins
Lecture 2: ORDER BY Clause
Video - 00:2:33 mins
Lecture 3: Sorting by Multiple Columns
Video - 00:2:47 mins
Lecture 4: Retrieving Highest Records
Video - 00:3:14 mins
Lecture 5: Skipping Rows
Video - 00:7:50 mins
MODULE 6: SQL Filtering Techniques
Lecture 1: Introduction
Video - 00:00:31 mins
Lecture 2: BETWEEN Operator
Video - 00:4:40 mins
Lecture 3: IN operator
Video - 00:3:08 mins
Lecture 4: Pattern Matching
Video - 00:6:27 mins
Lecture 5: IS NULL and IS NOT NULL
Video - 00:2:33 mins
MODULE 7: Aggregating Data for Analysis
Lecture 1: Introduction
Video - 00:1:01 mins
Lecture 2: Aggregate functions Count
Video - 00:5:12 mins
Lecture 3: Aggregate functions Summation
Video - 00:1:44 mins
Lecture 4: Aggregate functions Average
Video - 00:2:44 mins
Lecture 5: Aggregate functions Minimum & Maximum
Video - 00:2:19 mins
Lecture 6: Grouping Data
Video - 00:3:08 mins
Lecture 7: Condition Applying in Aggregate Functions
Video - 00:1:56 mins
MODULE 8: Working with Multiple Tables
Lecture 1: Introduction
Video - 00:1:30 mins
Lecture 2: Case Conversion (Part 1)
Video - 00:3:18 mins
Lecture 2: Case Conversion (Part 2)
Video - 00:1:50 mins
Lecture 3: Length of String
Video - 00:2:03 mins
Lecture 4: Removing Extra Space
Video - 00:4:32 mins
Lecture 5: Left Right Characters
Video - 00:5:45 mins
Lecture 6: Joining Texts
Video - 00:2:08 mins
Lecture 7: Replacing Text
Video - 00:1:45 mins
MODULE 9: Date & Time Functions
Lecture 1 Introduction
Video - 00:1:01 mins
Lecture 2 Current Date & Time
Video - 00:6:07 mins
Lecture 3 Extract Parts of Time
Video - 00:5:39 mins
Lecture 4 Date Addition
Video - 00:3:32 mins
Lecture 5 Date Subtraction
Video - 00:1:11 mins
Lecture 6 Difference between Dates
Video - 00:3:32 mins
MODULE 10: Working with Multiple Tables
Lecture 1 Introduction
Video - 00:1:31 mins
Lecture 2: Understanding Table Relationships
Video - 00:7:06 mins
Lecture 3: Primary Keys vs Foreign Keys
Video - 00:3:40 mins
Lecture 4: INNER JOIN
Video - 00:6:49 mins
Lecture 5: LEFT JOIN
Video - 00:4:09 mins
Lecture 6: RIGHT JOIN
Video - 00:3:40 mins
Lecture 7: FULL JOIN
Video - 00:3:35 mins
MODULE 11: Advanced SQL Techniques
Lecture 1: Introduction
Video - 00:00:55 mins
Lecture 2: Subqueries
Video - 00:4:25 mins
Lecture 3: Correlated subqueries
Video - 00:5:37 mins
Lecture 4: Common Table Expressions CTEs
Video - 00:8:05 mins
Lecture 5: Derived tables
Video - 00:5:52 mins
Lecture 6: UNION vs UNION ALL
Video - 00:4:09 mins
Lecture 7: CASE Statement
Video - 00:4:54 mins
MODULE – 12 Window Functions for Analytics
Lecture 1: Introduction
Video - 00:00:42 mins
Lecture 2: Row Number Function
Video - 00:2:41 mins
Lecture 3: Rank and Dense Rank Function
Video - 00:3:14 mins
Lecture 4: PARTITION BY clause
Video - 00:3:26 mins
Lecture 5: LAG Function
Video - 00:3:17 mins
Lecture 6: Lead Function
Video - 00:2:21 mins
MODULE 13: Transactions & Data Integrity
Lecture 1: Introduction
Video - 00:1:23 mins
Lecture 2: Restoring Database
Video - 00:7:56 mins
Lecture 3: Importing Dataset (Part 1)
Video - 00:7:11 mins
Lecture 3: Importing Dataset (Part 2)
Video - 00:3:53 mins
Lecture 4: Handling missing values
Video - 00:6:32 mins
Lecture 5 Removing duplicate records
Video - 00:4:27 mins
Lecture 6 Standardizing Text Format
Video - 00:5:55 mins
Lecture 7 Replacing Incorrect Values
Video - 00:2:31 mins
Lecture 8 Combining Columns
Video - 00:2:24 mins
Lecture 9 Converting Data Types
Video - 00:5:09 mins
Lecture 10 Data Transformation
Video - 00:5:40 mins
MODULE – 14 Views & Reusable Queries
Lecture 1: Introduction
Video - 00:00:34 mins
Lecture 2: What is View
Video - 00:1:45 mins
Lecture 3: Benefits of using views
Video - 00:3:09 mins
Lecture 4: Create View
Video - 00:5:10 mins
Lecture 5: Updating and managing views
Video - 00:4:20 mins
MODULE 15: Query Optimization & Indexing
Lecture 1: Introduction
Video - 00:00:48 mins
Lecture 2: Understanding query performance
Video - 00:3:50 mins
Lecture 3: Introduction to indexes (Part 1)
Video - 00:3:54 mins
Lecture 3: Introduction to indexes (Part 2)
Video - 00:1:16 mins
Lecture 4: Creating and using indexes
Video - 00:2:36 mins
Lecture 5: When NOT to use indexes
Video - 00:3:30 mins
Lecture 6: Query optimization techniques
Video - 00:3:20 mins
Project 1: Hospital Performance Analysis
Lecture 1: Introduction
Video - 00:00:41 mins
Lecture 2: Importing & Preparing Dataset
Video - 00:14:51 mins
Lecture 3: Basic Business Questions
Video - 00:09:21 mins
Lecture 4: Intermediate Business Questions
Video - 00:12:09 mins
Lecture 5: Advanced Business Questions
Video - 00:14:00 mins
Project 2: Retail Sales & Profit Analysis
Lecture - 1 Introduction
Video - 00:00:35 mins
Lecture - 2 Understanding & Importing Dataset
Video - 00:9:52 mins
Lecture - 3 Basic Business Questions
Video - 00:6:58 mins
Lecture - 4 Intermediate Business Questions
Video - 00:12:58 mins
Lecture - 5 Advanced Business Questions
Video - 00:29:22 mins
Project 3: Employee Attrition Analysis
Lecture - 1 Introduction
Video - 00:00:39 mins
Lecture - 2 Understanding & Importing Dataset
Video - 00:04:39 mins
Lecture - 3 Basic Business Questions
Video - 00:8:28 mins
Lecture - 4 Intermediate Business Questions
Video - 00:13:33 mins
Lecture - 5 Advanced Business Questions
Video - 00:26:54 mins
Announcements Live Classes Gradebook Certificate Course Info
PreviousNext

betterskill.io is an e-learning platform designed by industry experts to equip youth with essential skills. Our goal is to build a skilled workforce that can shape the future of Bangladesh.

Support

  • About us
  • Contact us
  • FAQs
  • Refund Policy

Importantant Links

  • All courses
  • Offer & Discount
  • Verify Certificate
  • Blogs

Follow us

Facebook X-twitter Youtube Linkedin

support@betterskill.io
Phone:+8801338540261
Address: 29/2 Lake Circus, Kalabagan, 1205, Dhaka

SSLCommerz-Pay-With-logo-All-Size-01

Copyright © 2026 betterskill.io

  • Privacy Policy
  • Terms and Regulation
  • Login
  • Registration
Forgot Password?
Or
Or
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
body::-webkit-scrollbar { width: 7px; } body::-webkit-scrollbar-track { border-radius: 10px; background: #f0f0f0; } body::-webkit-scrollbar-thumb { border-radius: 50px; background: #dfdbdb }