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
Picture of Jaber
Menu
Menu

Bundle Course

Menu
Picture of Jaber
Menu
Menu
Course Content
Demo Class: এখন থেকে দেখে নিন কোর্সের ডেমো ক্লাসগুলোকে
0/4
Demo class 1: What is SQL and why it matters
05:01
Demo Class 2: Creating Table in SQL
10:01
Demo class 3: SQL Filtering Technique: Pattern Matching
06:05
Demo Class 4: Lag Function in SQL
03:17
MODULE 1: Introduction to SQL & Databases
0/7
Lecture 1: Introduction
01:52
Lecture 2: What is a database
04:13
Lecture 3: Types of databases Relational vs NoSQL
03:55
Lecture 4: What is SQL and why it matters
05:01
Lecture 5: Real world use cases in data analytics
04:26
For Instructor Support, Join here..
All Resources (Data & Codes)
MODULE 2: Database Setup & Table Creation
0/8
Lecture 1: Introduction
01:03
Lecture 2: Understanding data types
04:29
Lecture 3: Constraints
09:11
Lecture 4: Installing and Setting Up SQL Environment
09:58
Lecture 5: Creating databases
07:37
Lecture 6: Creating tables
10:01
Lecture 7: Alter Table
04:59
Lecture 8: Drop Table
01:52
MODULE 3: Data Insertion & Management
0/6
Lecture 1: Introduction
00:51
Lecture 2: Insert Data into Table
14:27
Lecture 3: Update Records
06:27
Lecture 4: Deleting Record
04:32
Lecture 5: TRUNCATE vs DELETE
05:56
Lecture 6: Understanding and handling NULL values
08:57
MODULE 4: Basic Data Retrieval
0/7
Lecture 1: Introduction
01:04
Lecture 2: SELECT Statement
05:55
Lecture 3: Selecting Specific Columns
03:51
Lecture 4: Removing Duplicates with DISTINCT
02:33
Lecture 5: Filtering Data using WHERE
03:38
Lecture 6: Comparison Operators
05:18
Lecture 7: Logical Operators
05:23
MODULE 5: Sorting & Limiting Data
0/5
Lecture 1: Introduction
00:54
Lecture 2: ORDER BY Clause
02:33
Lecture 3: Sorting by Multiple Columns
02:47
Lecture 4: Retrieving Highest Records
03:14
Lecture 5: Skipping Rows
07:50
MODULE 6: SQL Filtering Techniques
0/5
Lecture 1: Introduction
00:32
Lecture 2: BETWEEN Operator
04:40
Lecture 3: IN operator
03:08
Lecture 4: Pattern Matching
06:27
Lecture 5: IS NULL and IS NOT NULL
02:33
MODULE 7: Aggregating Data for Analysis
0/7
Lecture 1: Introduction
01:01
Lecture 2: Aggregate functions Count
05:11
Lecture 3: Aggregate functions Summation
01:44
Lecture 4: Aggregate functions Average
02:44
Lecture 5: Aggregate functions Minimum & Maximum
02:20
Lecture 6: Grouping Data
03:08
Lecture 7: Condition Applying in Aggregate Functions
01:56
MODULE 8: Working with Multiple Tables
0/14
Lecture 1: Introduction
01:30
Lecture 2: Case Conversion (Part 1)
03:18
Lecture 2: Case Conversion (Part 2)
01:50
Lecture 3: Understanding Table Relationships
07:06
Lecture 4: Length of String
02:03
Lecture 5: Primary Keys vs Foreign Keys
03:40
Lecture 6: INNER JOIN
06:49
Lecture 7: Removing Extra Space
04:32
Lecture 8: Left Right Characters
05:46
Lecture 9: LEFT JOIN
04:10
Lecture 10: Joining Texts
02:08
Lecture 11: RIGHT JOIN
03:40
Lecture 12: FULL JOIN
03:35
Lecture 13: Replacing Text
01:45
MODULE 9: Data Cleaning & Transformation
0/7
Lecture 1: Introduction
00:59
Lecture 2: Subqueries
04:24
Lecture 3: Correlated subqueries
05:37
Lecture 4: Common Table Expressions CTEs
08:05
Lecture 5: Derived tables
05:52
Lecture 6: UNION vs UNION ALL
04:10
Lecture 7: CASE Statement
04:54
MODULE 10: Advanced SQL Techniques
0/6
Lecture 1: Introduction
01:31
Lecture 2: Row Number Function
02:41
Lecture 3: Rank and Dense Rank Function
03:15
Lecture 4: PARTITION BY clause
03:27
Lecture 5: LAG Function
03:17
Lecture 6: Lead Function
02:21
MODULE 11: Window Functions for Analytics
0/7
Lecture 1: Introduction
00:55
Lecture 2: Subqueries
04:38
Lecture 3: Correlated subqueries
05:46
Lecture 4: Common Table Expressions CTEs
08:13
Lecture 5: Derived tables
06:27
Lecture 6: UNION vs UNION ALL
04:48
Lecture 7: CASE Statement
04:38
MODULE 12: Views & Reusable Queries
0/5
Lecture 1: Introduction
00:42
Lecture 2: Row Number Function
02:54
Lecture 3: Rank and Dense Rank Function
03:20
Lecture 4: PARTITION BY clause
04:03
Lecture 5: LAG Function
03:27
MODULE 13: Transactions & Data Integrity
0/4
Lecture 1: Introduction
01:22
Lecture 2: Restoring Database
07:56
Lecture 3: Importing Dataset
07:11
Lecture 4: Handling missing values
05:51
MODULE 14: Query Optimization & Indexing
SQL Mastery: Data Analytics & Business Intelligence
Previous
Next
0% Complete