• 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
大模型入门到精通,正在更新中~等不急的可以直接找我,我们一起交流!
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
Customer Service
Top
赛事库 课堂 2021拜年纪