Part 1. CHAR in SQL: Fixed-Length Strings Explained

Part 1. CHAR in SQL: Fixed-Length Strings Explained

Bi... Courses

Get the course to see this video description

To watch the video Please Login

Report for Comment or Reply

Mastering MySQL | From Zero to Database Hero

Section 1: 📘Introduction to the Course (1)

1.1: Master SQL with MySQL From Dat...

- 3 min - Free

Section 2: 🔍Understanding Data & Data... (12)

2.1: What is Data and Data structur...

- 15 min

2.2: Understanding Data & Data ...

2.3: What is Database?

- 14 min

2.4: ምድህሳስ ብዛዕባ Databaseዛት፥ relatio...

2.5: What is really SQL?

- 9 min

2.6: መረዳእታ ብዛዕባ SQL: Language, Quer...

2.7: Entity-Relationship Diagrams: ...

- 12 min

2.8: መረዳእታ ብዛዕባ ER Diagrams & ...

2.9: SQL Data Types Explained: Choo...

- 15 min

2.10: Mastering SQL Data Types: እንታይ...

2.11: Relational Model Basics: Sets,...

- 15 min

2.12: ምርዳእ ብዛዕባ Relational Models: S...

Section 3: ⚙️Getting Started with MySQL (4)

3.1: MySQL Setup Preview: Understan...

- 4 min

3.2: Installing MySQL DBMS from My...

- 9 min

3.3: 🔍 Database vs Table – What...

- 5 min

3.4: Getting Started with MySQL Wor...

- 9 min

Section 4: ✍️Writing Basic SQL Queries (2)

4.1: Creating a Database with SQL +...

- 10 min

4.2: Dropping a Database & Unde...

- 5 min

Section 5: 🔧Data Manipulation (12)

5.1: Creating Tables & Viewing ...

- 10 min

5.2: Renaming or Dropping Tables in...

- 4 min

5.3: Modifying Tables in MySQL: Add...

- 10 min

5.4: Inserting Single & Multipl...

- 12 min

5.5: Understanding NULL & NOT N...

- 10 min

5.6: Using DEFAULT Values & NOT...

- 10 min

5.7: Primary Key & AUTO_INCREME...

- 13 min

5.8: The SELECT Statement in SQL: R...

- 8 min

5.9: Filtering Data with WHERE Clau...

- 6 min

5.10: Using Aliases in SQL: Rename C...

- 3 min

5.11: UPDATE Statement in SQL: Modif...

- 12 min

5.12: DELETE Statement in SQL: Remov...

- 5 min

Section 6: 🎯Data Handling & Query Enh... (11)

6.1: UNIQUE Constraint in SQL: Ensu...

- 12 min

6.2: CHECK Constraint in SQL: Valid...

- 6 min

6.3: Exporting a MySQL Database: Ba...

- 11 min

6.4: Importing a Database in MySQL ...

- 3 min

6.5: Logical Operators in SQL: AND,...

- 12 min

6.6: BETWEEN Operator in SQL: Filte...

- 4 min

6.7: IN Operator in SQL: Match Mult...

- 4 min

6.8: ORDER BY in SQL: Sort Your Dat...

- 8 min

6.9: LIMIT in SQL: Control the Numb...

- 5 min

6.10: LIKE Operator in SQL: Search w...

- 10 min

6.11: DISTINCT in SQL: Eliminate Dup...

- 5 min

Section 7: 🔢Data Analysis & Functions... (6)

7.1: Aggregate Functions in SQL (Pa...

- 12 min

7.2: Aggregate Functions in SQL (Pa...

- 18 min

7.3: GROUP BY in SQL(Part 1): Organ...

- 13 min

7.4: GROUP BY in SQL(Part 2): Organ...

- 13 min

7.5: String Functions in SQL (Part ...

- 12 min

7.6: String Functions in SQL (Part ...

- 15 min

Section 8: 📦Data Types in SQL (5)

8.1: Part 1. CHAR in SQL: Fixed-Len...

- 16 min

8.2: Part 2. VARCHAR in SQL: Flexib...

- 11 min

8.3: DECIMAL, FLOAT & DOUBLE in...

- 17 min

8.4: DATE, TIME, DATETIME & TIM...

- 15 min

8.5: Working with Current Date &...

- 15 min

Section 9: 🏁 Milestone Achievement (1)

9.1: 🎉 Congratulations on Completin...

- 2 min

Section 10: 🔗 Working with Multiple Tables (7)

10.1: From Single Tables to RealWorl...

- 5 min

10.2: The Problem with Single Tables...

- 10 min

10.3: What Is a Foreign Key? Underst...

- 6 min

10.4: Cleaning the Mess: Using Forei...

- 13 min

10.5: Normalization and Creating Dat...

- 16 min

10.6: Updating and Deleting a FOREIG...

- 6 min

10.7: Inserting data to RELATIONAL D...

- 10 min

Section 11: 🧱Database Design & Best Pr... (3)

11.1: SQL vs Database: What’s the Re...

- 14 min

11.2: Student Enrollment Project: De...

- 17 min

11.3: Importing Data from Excel to M...

- 27 min

Section 12: 🔗 Mastering SQL JOINs: Connect... (10)

12.1: How to Combine Tables — Joins ...

- 8 min

12.2: What Are SQL Joins?

- 5 min

12.3: When to Use SQL Joins

- 7 min

12.4: Understanding the World of SQL...

- 5 min

12.5: No JOIN: Starting from Separat...

- 9 min

12.6: INNER JOIN Explained Visually ...

- 16 min

12.7: INNER JOIN Explained Visually ...

- 10 min

12.8: LEFT JOIN for Enriching Your D...

- 14 min

12.9: Right Join — The Mirror of Lef...

- 10 min

12.10: Full Join — Merging All Worlds

- 13 min

Section 13: 🔸 Deep Dive: Advanced Joins in... (8)

13.1: Left Anti Join – Find What...

- 10 min

13.2: Right Anti Join – Reverse the ...

- 6 min

13.3: Full Anti Join – What’s Missin...

- 9 min

13.4: Cross Join – All Possible Comb...

- 9 min

13.5: Choosing the Right Join – Quic...

- 4 min

13.6: Mastering Multi-Table Joins in...

- 13 min

13.7: Challenging SQL Join Project 💪...

- 17 min

13.8: Challenging SQL Join Project 💪...

- 15 min

We value your opinion.
Help us serve you better by sharing your feedback.