Community
Articles
Topics
Q&A
Learn
Course
Programming Dictionary
Tools Library
Development tools
Website Source Code
PHP Libraries
JS special effects
Website Materials
Extension plug-ins
Leisure
Game Download
Game Tutorials
English
简体中文
English
繁体中文
日本語
한국어
Melayu
Français
Deutsch
Login
singup
Next Section: Aggregation function and GroupBy grouping of MySQL query statements
(1212 plays)
Next Section
Watch Again
ဆ
Chapter
Note
Ask
Courseware
Feedback
Complete set of MySQL basic introduction, basic + advanced
Chapter1 Complete collection of MySQL basics (1)
1-1 Get to know the MySQL database
1-2 MySQL basic operation commands
1-3 Data types in MySQL
1-4 Type constraints and operations in MySQL
1-5 Detailed explanation of MySQL data table operations
1-6 Table engine in MySQL database
1-7 Character set utf8 in MySQL
1-8 MySQL DML operation-data addition, deletion and modification
1-9 MySQL query statement-retrieve data select
1-10 MySQL data query-OrderBy sorting
Chapter2 Complete collection of MySQL basics (2)
2-1 Where condition for MySQL data query
2-2 MySQL query statement-Like and wildcards
2-3 Calculation of fields in MySQL query
2-4 Introduction to common functions of MySQL query
2-5 Aggregation function and GroupBy grouping of MySQL query statements
2-6 Import and export of MySQL database data
2-7 MySQL database permission management
2-8 Python operates mysql
2-9 Code optimization and other manipulation of data
2-10 Basic implementation of Flask framework
Chapter3 Complete collection of MySQL basics (3)
3-1 Design and creation of message board database
3-2 Web message board list display
3-3 Add form for web message board
3-4 Messages from the web message board are stored in the database
3-5 Deletion of messages on web message boards
3-6 Subquery and table join-use of subquery
3-7 Subquery with table join - using subquery as calculated field
3-8 Table relationship - what is a relationship table
3-9 Table relationship-one-to-one relationship and foreign key
3-10 Table relationship-one-to-many relationship
Chapter4 Complete collection of MySQL basics (4)
4-1 Table relationship-many-to-many relationship
4-2 Table join - usage of table join where and join
4-3 Table join - self join in join query
4-4 Table join-outer join-left join and right join
4-5 UNION joint query
4-6 SQL advanced exercises-01.SQL exercises
4-7 SQL advanced exercises-02.SQL exercises
4-8 SQL advanced exercises-03.SQL exercises
4-9 SQL advanced exercises-04.SQL exercises
4-10 SQL advanced exercises-05.SQL exercises
4-11 SQL advanced exercises-06-07.SQL exercises
Chapter5 Complete collection of MySQL basics (5)
5-1 SQL advanced exercises-08-11.SQL exercises
5-2 SQL advanced exercises-12.SQL exercises
5-3 SQL advanced exercises-detailed explanation of sql_mode
5-4 SQL advanced exercises-13-16sql exercises
5-5 SQL advanced exercises-16.sql exercises-scores of all students
5-6 SQL advanced exercises-17.sql exercises-CASE WHEN usage
5-7 SQL advanced exercises-18-19.sql exercises-subject ranking
5-8 SQL advanced exercises-remaining sql exercises
5-9 SQL advanced interview questions-1. Students with a score greater than 80
5-10 SQL advanced interview questions-2. ID with a higher temperature than yesterday
Chapter6 Complete collection of MySQL basics (6)
6-1 SQL advanced interview questions-3. The maximum level of the anchor
6-2 SQL advanced interview questions-4. Course data row to column conversion
6-3 SQL advanced interview questions-SQL query in 5.update
6-4 MySQL Transaction-1. Basic overview and operations of transactions
6-5 MySQL Transaction-2. Different isolation levels of transactions
6-6 MySQL advanced extension-stored procedure
6-7 MySQL advanced extension-trigger
6-8 MySQL advanced extension-view
6-9 MySQL Index and SQL Optimization-Overview and Classification of Indexes
6-10 MySQL index principle-index and B+Tree
6-11 MySQL slow query and SQL optimization
6-12 Software tool installation-Mac system
6-13 Software tool installation-win10 system
Previous section
Next Section
Tutorial List
get help
Course Recommendations
Courseware download
Elementary
Imperial CMS enterprise imitation website tutorial
3048 people are watching
Elementary
Newbies with zero foundation in WordPress build personal blogs and corporate websites
6743 people are watching
Elementary
Ultimate CMS zero-based website building instruction video
2724 people are watching
Elementary
Front-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]
3117 people are watching
Intermediate
Vue3.0 from 0 to build a universal backend management system project practice
5351 people are watching
Elementary
Zero-based front-end course [Vue advanced learning and practical application]
2821 people are watching
Elementary
WEB front-end tutorial [HTML5+CSS3+JS]
3506 people are watching
Elementary
Quick introduction to apipost
2161 people are watching
Intermediate
Vue3+TypeScript practical tutorial-enterprise-level project practice
3208 people are watching
Elementary
Let's briefly talk about starting a business in PHP
17423 people are watching
Intermediate
VUE e-commerce project (front-end & back-end dual project actual combat)
3828 people are watching
Elementary
Apipost practical application [api, interface, automated testing, mock]
2265 people are watching
Students who have watched this course are also learning
492424 plays
Let's briefly talk about starting a business in PHP
Quick introduction to web front-end development
Large-scale practical Tianlongbabu development of Mini version MVC framework imitating the encyclopedia website of embarrassing things
Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]
Login verification and classic message board
Computer network knowledge collection
Quick Start Node.JS Full Version
The front-end course that understands you best: HTML5/CSS3/ES6/NPM/Vue/...[Original]
Write your own PHP MVC framework (40 chapters in depth/big details/must read for newbies to advance)
notes
X