Complete set of MySQL basic introduction, basic + advanced-Free online video tutorial-php.cn

Community Learn Tools Library Leisure

English

Complete set of MySQL basic introduction, basic + advanced

MySQL Database Service is a fully managed database service for deploying cloud-native applications using the world's most popular open source database. It is 100% developed, managed and supported by MySQL.

Elementary

mysql

getting Started

Base

Advanced

70837 person learning

64class hour

16 hours 24 minutes 39 secondsTotal course duration

2021-09-03update

王林

Gold lecturer

A total of 180 courses Student180310 Lecturer rating5.3

有朋自远方来，虽远必诛！More>>

Course Introduction Course Outline Other Courses

You will learn：

MySQL Database Service is a fully managed database service for deploying cloud-native applications using the world's most popular open source database. It is 100% developed, managed and supported by MySQL.

Complete set of MySQL basic introduction, basic + advanced

Chapter1 Complete collection of MySQL basics (1)
expand retract

Section1 Get to know the MySQL database
duration： 28 minutes 16 seconds

Section2 MySQL basic operation commands
duration： 32 minutes 47 seconds

Section3 Data types in MySQL
duration： 21 minutes 02 seconds

Section4 Type constraints and operations in MySQL
duration： 18 minutes 01 seconds

Section5 Detailed explanation of MySQL data table operations
duration： 31 minutes 01 seconds

Section6 Table engine in MySQL database
duration： 23 minutes 34 seconds

Section7 Character set utf8 in MySQL
duration： 11 minutes 29 seconds

Section8 MySQL DML operation-data addition, deletion and modification
duration： 08 minutes 16 seconds

Section9 MySQL query statement-retrieve data select
duration： 11 minutes 46 seconds

Section10 MySQL data query-OrderBy sorting
duration： 04 minutes 31 seconds
Chapter2 Complete collection of MySQL basics (2)
expand retract

Section1 Where condition for MySQL data query
duration： 15 minutes 54 seconds

Section2 MySQL query statement-Like and wildcards
duration： 09 minutes 47 seconds

Section3 Calculation of fields in MySQL query
duration： 02 minutes 33 seconds

Section4 Introduction to common functions of MySQL query
duration： 14 minutes 36 seconds

Section5 Aggregation function and GroupBy grouping of MySQL query statements
duration： 27 minutes 43 seconds

Section6 Import and export of MySQL database data
duration： 09 minutes 28 seconds

Section7 MySQL database permission management
duration： 10 minutes 45 seconds

Section8 Python operates mysql
duration： 20 minutes 21 seconds

Section9 Code optimization and other manipulation of data
duration： 12 minutes 52 seconds

Section10 Basic implementation of Flask framework
duration： 12 minutes 29 seconds
Chapter3 Complete collection of MySQL basics (3)
expand retract

Section1 Design and creation of message board database
duration： 10 minutes 26 seconds

Section2 Web message board list display
duration： 18 minutes 42 seconds

Section3 Add form for web message board
duration： 15 minutes 32 seconds

Section4 Messages from the web message board are stored in the database
duration： 10 minutes 40 seconds

Section5 Deletion of messages on web message boards
duration： 06 minutes 51 seconds

Section6 Subquery and table join-use of subquery
duration： 23 minutes 55 seconds

Section7 Subquery with table join - using subquery as calculated field
duration： 11 minutes 19 seconds

Section8 Table relationship - what is a relationship table
duration： 08 minutes 51 seconds

Section9 Table relationship-one-to-one relationship and foreign key
duration： 16 minutes 37 seconds

Section10 Table relationship-one-to-many relationship
duration： 08 minutes 11 seconds
Chapter4 Complete collection of MySQL basics (4)
expand retract

Section1 Table relationship-many-to-many relationship
duration： 12 minutes 11 seconds

Section2 Table join - usage of table join where and join
duration： 25 minutes 01 seconds

Section3 Table join - self join in join query
duration： 19 minutes 49 seconds

Section4 Table join-outer join-left join and right join
duration： 21 minutes 24 seconds

Section5 UNION joint query
duration： 13 minutes 35 seconds

Section6 SQL advanced exercises-01.SQL exercises
duration： 20 minutes 48 seconds

Section7 SQL advanced exercises-02.SQL exercises
duration： 03 minutes 24 seconds

Section8 SQL advanced exercises-03.SQL exercises
duration： 02 minutes 06 seconds

Section9 SQL advanced exercises-04.SQL exercises
duration： 03 minutes 34 seconds

Section10 SQL advanced exercises-05.SQL exercises
duration： 05 minutes 32 seconds

Section11 SQL advanced exercises-06-07.SQL exercises
duration： 05 minutes 07 seconds
Chapter5 Complete collection of MySQL basics (5)
expand retract

Section1 SQL advanced exercises-08-11.SQL exercises
duration： 08 minutes 27 seconds

Section2 SQL advanced exercises-12.SQL exercises
duration： 09 minutes 32 seconds

Section3 SQL advanced exercises-detailed explanation of sql_mode
duration： 17 minutes 23 seconds

Section4 SQL advanced exercises-13-16sql exercises
duration： 09 minutes 58 seconds

Section5 SQL advanced exercises-16.sql exercises-scores of all students
duration： 11 minutes 57 seconds

Section6 SQL advanced exercises-17.sql exercises-CASE WHEN usage
duration： 18 minutes 57 seconds

Section7 SQL advanced exercises-18-19.sql exercises-subject ranking
duration： 27 minutes 41 seconds

Section8 SQL advanced exercises-remaining sql exercises
duration： 09 minutes 01 seconds

Section9 SQL advanced interview questions-1. Students with a score greater than 80
duration： 11 minutes 30 seconds

Section10 SQL advanced interview questions-2. ID with a higher temperature than yesterday
duration： 09 minutes 58 seconds
Chapter6 Complete collection of MySQL basics (6)
expand retract

Section1 SQL advanced interview questions-3. The maximum level of the anchor
duration： 08 minutes 27 seconds

Section2 SQL advanced interview questions-4. Course data row to column conversion
duration： 09 minutes 15 seconds

Section3 SQL advanced interview questions-SQL query in 5.update
duration： 16 minutes 16 seconds

Section4 MySQL Transaction-1. Basic overview and operations of transactions
duration： 28 minutes 47 seconds

Section5 MySQL Transaction-2. Different isolation levels of transactions
duration： 34 minutes 24 seconds

Section6 MySQL advanced extension-stored procedure
duration： 20 minutes 34 seconds

Section7 MySQL advanced extension-trigger
duration： 12 minutes 47 seconds

Section8 MySQL advanced extension-view
duration： 14 minutes 45 seconds

Section9 MySQL Index and SQL Optimization-Overview and Classification of Indexes
duration： 18 minutes 05 seconds

Section10 MySQL index principle-index and B+Tree
duration： 37 minutes 39 seconds

Section11 MySQL slow query and SQL optimization
duration： 32 minutes 51 seconds

Section12 Software tool installation-Mac system
duration： 10 minutes 51 seconds

Section13 Software tool installation-win10 system
duration： 14 minutes 48 seconds

王林 Lecturer Other Courses

ElementaryComplete collection of interview questions in front-end disciplines (Season 1)

23865
Collection
ElementaryFlexible box + responsive page layout practice

9106
Collection
ElementaryMake a responsive website from scratch—Grid layout

18073
Collection
ElementaryThe most easy-to-understand HTML+CSS course in 9 days

45386
Collection
ElementaryBasic tutorial for getting started with Web front-end

245343
Collection
ElementaryWeb front-end development-Zero Basic Programming Admission Guide

68190
Collection
ElementaryFront-end basic HTML5+CSS3 from entry to proficiency (full version)

302651
Collection
ElementaryThe latest CSS3 tutorial is quick and easy to understand

22887
Collection
ElementaryCSS3 Flex flexible box model makes layout fly

28910
Collection
ElementaryLearn DIV+CSS layout in one day (five practical exercises)

11204
Collection
ElementaryHTML5+CSS practice project [Hand Knock Onmyoji official website]

11153
Collection
ElementaryMobile layout: HTML5+CSS3 advanced and enhanced version

125963
Collection

Start Learning

This course includes：

16 hours 24 minutes 39 seconds Watch videos anytime

0 Download Resources

Popular courses Latest courses

More>