• Upload

【Highly Recommended】This is definitely Bilibili's 2025 【MySQL Database Basics + Advanced】Video Tutorial from Beginner to Mastery sql-mysql tutorial_mysql video_mysql beginner

94.1K
55
2025-03-31 14:43:54
631
268
2941
265
Friends who need courseware code, click here: https://www.bilibili.com/read/cv28393191/?spm_id_from=333.999.0.0&jump_opus=1 【Highly Recommended】This is definitely Bilibili's 2025 【MySQL Database Basics + Advanced】From Beginner to Master Video Tutorial sql-mysql tutorial_mysql video_mysql beginner
Knowledge
Study
Otaku Engineer
Technology
Computer Science
Programmer
SQL
Database
Computer Technology
python
MySQL
Linux
AI大模型- Send message
大模型入门到精通，正在更新中～等不急的可以直接找我，我们一起交流！
Video playlist
（1/98）
01+2-MySQL Database
14:25
03 - Comparison of Common DBMSs
18:48
04-Comparison between RDBMS and non-RDBMS
20:05
05-ER Model and 4 Types of Table Relationships
20:33
06-Uninstalling MySQL 8.0
20:41
07-Download, Installation, and Configuration of MySQL 8.0 and 5.7 Versions
35:30
08-Common Issues in MySQL Installation_Service Startup and User Login
19:19
09-Demonstration of MySQL Usage_Setting Character Sets for MySQL 5.7
27:53
10-Using Tools Like Navicat, SQLyog, and DBeaver
29:00
11-MySQL directory structure and post-class exercises for the first 2 chapters
33:56
12-SQL Overview and SQL Classification
34:30
13-SQL Usage Standards and Data Import
32:02
14 - The Most Basic SELECT...FROM Structure
09:02
15 - Column Aliases_Distinct_NULL_DESC Operations
33:19
16 - Filtering Data Using WHERE
10:07
17-Chapter 3 Basic SELECT Query Post-Class Exercises
09:35
18 - Usage of Arithmetic Operators
17:05
19 - Usage of Comparison Operators
58:02
20-Using Logical and Bitwise Operators
22:58
21-Chapter 4 Operator Practice After Class
17:27
22-ORDER BY for Sorting Operations
21:33
23-LIMIT Implementing Pagination
30:54
24-Chapter 5 Post-Class Practice on Sorting and Paging
10:49
26 - Errors in Cartesian Product and Correct Multi-table Queries
35:43
27-Equi Join vs Non-Equi Join, Self Join vs Non-Self Join
16:34
28-How to Implement Inner Join and Outer Join with SQL92 and 99 Syntax
35:55
29-Implementing 7 Types of JOIN Operations Using SQL99
21:40
30-Usage of NATURAL JOIN and USING
10:55
31 - Chapter 6 Multi-table Query Post-class Exercises
34:32
32-Classification of Functions
12:46
33 - Explanation of Numeric Type Functions
36:11
34 - Explanation of String Type Functions
30:59
35 - Explanation of Date and Time Functions
52:37
36 - Explanation of Flow Control Functions
21:43
37-Encryption and Decryption_MySQL Information Functions and More Explained
25:06
38 - Chapter 7 Single Row Function Post-Class Exercises
29:03
39-5 Major Common Aggregate Functions
43:08
40-Usage of GROUP BY
31:30
41-Usage of HAVING and SQL Statement Execution Process
44:01
42 - Chapter 8 Aggregate Functions Post-Class Exercises
19:04
43 - Examples of Subqueries and Classification of Subqueries
27:25
44-Single-row Subquery Case Analysis
29:19
45-Multi-row Subquery Case Analysis
25:15
46-Correlated Subquery Case Analysis
45:58
47-Chapter 9 Subquery Post-Class Exercise 1
40:17
48-Chapter 9 Subquery Post-Class Practice 2
48:29
49-Creating, Modifying, and Deleting Databases
37:55
50-Common Data Types_Two Ways to Create Tables
30:19
51-Modify Table_Rename Table_Delete Table_Empty Table
22:53
52-DCL Usage of COMMIT and ROLLBACK
21:59
53-Ali MySQL Naming Conventions and Atomicization of MySQL8 DDL
20:29
54-Chapter 10 Post-Class Practice on Creating and Managing Tables
38:37
55-DML for Adding Data
26:29
56-DML Update and Delete Operations - MySQL 8 New Features of Computed Columns
20:41
57-Comprehensive Case of DDL and DML
36:50
58-Chapter 11 Post-Class Practice on Insert, Delete, and Update
37:20
59-Overview of MySQL Data Types_Character Set Settings
23:20
60-Integer Data Type Explanation
25:23
61 - Explanation of Floating Point, Fixed Point, and Bit Types
36:30
62 - Explanation of Date and Time Types
37:53
63 - Text String Types (including ENUM, SET) Explanation
35:19
64-Binary Types and JSON Types Explanation
24:13
65-Summary and Type Usage Recommendations
06:13
66-Classification of Data Integrity and Constraints
17:27
67-Using NOT NULL Constraints
15:31
68-Using UNIQUE Constraints
35:46
69 - Use of Primary Key Constraints
21:47
70-AUTO_INCREMENT
21:17
71 - Use of Foreign Key Constraints
42:02
72-Check Constraint and Default Value Constraint
20:23
73-Chapter 13 Constraints Post-Class Exercises
33:25
74-Understanding Database Objects and Views
25:55
75-Creation and Viewing of Views
26:13
76-Update View Data and View Deletion
25:02
77-Chapter 14 View Post-Class Exercises
17:09
78-Stored Procedure Usage Instructions
19:21
79-Creation and Invocation of Stored Procedures
33:02
80-Creation and Invocation of Stored Functions
23:31
81-Demonstration of SQL Execution Process in MySQL 8.0 and 5.7
16:17
82-SQL Execution Process in Oracle_Using Buffer Pool
22:29
83-Setting the Storage Engine of a Table, Comparison between InnoDB and MyISAM
32:44
84 - Usage of Archive, CSV, Memory and other storage engines
15:44
85 - Why use indexes and the advantages and disadvantages of indexes
24:17
86 - A Simple Index Design Plan
22:23
87 - Iterative Design Plan for Indexes
18:52
88 - Concepts of Clustered Indexes, Secondary Indexes, and Composite Indexes
23:24
89-Precautions for B+ Trees in InnoDB_Indexing Scheme of MyISAM
25:23
90-Comparison of Hash Index, AVL Tree, B-Tree, and B+ Tree
41:20
91-Overview of InnoDB Data Storage Structure
20:24
92-Page Structure: File Header and Footer
17:52
93-Page Structure: Minimum and Maximum Records_Record Header Information in Row Format
24:11
94 - Page Structure of Page Directory and Page Header
17:50
95-Setting Row Format and IBD File Analysis Compact Row Format
30:47
96-Row Overflow and Dynamic, Compressed, Redundant Row Formats
17:17
97 - Area, Segment, Fragment Area and Table Space Structure
36:29
98-Classification of indexes
11:33
99-Three ways to add indexes in tables
38:53
100 - Delete Index and New Index Features: Descending Index, Hidden Index
32:14

The Latest Step-by-step Navicat Tutorial: Master Basic Operations from Beginner to Pro
Aruora是真的想教会你
137.2K 226

Final exam database SQL query statements
云雾雾无
160K 246

[All 568 Episodes] Tsinghua expert finally made MySQL tutorials into anime, easy to understand, 2025 latest edition. Finish it and get hired! Take it for free, no more detours. If I fail to learn, I quit IT.
Python学习指导媛
15K 2

Basic usage of Navicat
平静052164
70.3K 63

SQL Explained: Learn in 15 Minutes, Data "CRUD" (Create, Read, Update, Delete), Database Operations
停止重构
45.6K 116

Half an Hour SQL Crash Course
故地纸鸢起
45.2K 44

Must Watch Before Self-Learning SQL! Save as Many as Possible
SQLynx
61.7K 28

[All 30 episodes] Crash course in a week! 2026 latest MySQL practical tutorial! Even zero basics can go from beginner to hands-on practice!
老鱼讲攻防
883 93

How to use Excel, SQL, and databases together?
王小二数据分析
32K 2

Computer Course Rankings
克莱加德
100.4K 26

Oracle Database Tutorial from Beginner to Master (52 Episodes Complete)
Java基础
244.6K 1734

MySQL Database Login and Basic Operations
ClothoLee
63.8K 43

Basic SQL Operations: Creating Student Tables, Course Tables, and Query Experiments
风流倜傥的Selina
191K 110

[2025 Latest Edition MySQL] Must-Watch for Absolute Beginners! MySQL Database Basics Tutorial_SQL Database Quick Start!
凛冬将至大白菜
291.3K 538

Crash Course on Database: Relational Algebra Operations
言齐齐齐
328K 1021

[2025 Edition] The only best MySQL database tutorial on Bilibili, covering MySQL performance optimization, index tuning, SQL tuning, advanced MySQL optimization, and MySQL interview questions - explaining everything clearly to avoid 99% of pitfalls!
图灵学院徐庶
29K 142

1. Step 1: Create a database (MySQL)
老蒋编程大课堂
118K 49

[600 Episodes] This might be the most comprehensive and detailed zero-based data analysis tutorial series on Bilibili in 2025—force yourself to finish it in one month and effortlessly become a data analyst! Pure干货 with zero fluff!
Python-学习圈
30.6K 29

MySQL Beginner, Advanced, Stored Procedures, MySQL Interview Questions, MySQL Video Tutorial
动力节点
183.8K 3504

[Highly Recommended] Bilibili 2025 [Complete Beginner-Level Course on Computer Basics + Operating Systems] (CPU/Hard Drive/Memory/Motherboard/Graphics Card/Operating System/Computer Networks/IP/VIsm)
AI大模型-
8694 4
Expand
B站AI创造公开赛S2启动！
Customer Service
Top
赛事库 课堂 2021拜年纪