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