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

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

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

60547 person learning

64 class hour

16 hours 24 minutes 39 seconds Total course duration

2021-09-03update

王林

Gold lecturer

A total of 180 coursesStudent180290 Lecturer rating5.8

有朋自远方来，虽远必诛！ 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

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

19888
Collection
Elementary Flexible box + responsive page layout practice

7947
Collection
Elementary Make a responsive website from scratch—Grid layout

15182
Collection
Elementary The most easy-to-understand HTML+CSS course in 9 days

38425
Collection
Elementary Basic tutorial for getting started with Web front-end

203333
Collection
Elementary Web front-end development-Zero Basic Programming Admission Guide

57378
Collection
Elementary Front-end basic HTML5+CSS3 from entry to proficiency (full version)

272764
Collection
Elementary The latest CSS3 tutorial is quick and easy to understand

19014
Collection
Elementary CSS3 Flex flexible box model makes layout fly

23605
Collection
Elementary Learn DIV+CSS layout in one day (five practical exercises)

9436
Collection
Elementary HTML5+CSS practice project [Hand Knock Onmyoji official website]

8900
Collection
Elementary Getting started with HTML5+CSS3 for front-end newbies

207345
Collection

Start Learning

This course includes：

16 hours 24 minutes 39 seconds Watch videos anytime

0 Download Resources

Popular courses Latest courses

More>

About us Disclaimer Sitemap: php.cn：Public welfare online PHP training，Help PHP learners grow quickly！