What to do in database maintenance and optimization-数据库设计那些事-php.cn

Community

Learn

Tools Library

AI Tools

Leisure

English

Next Section： How the database maintains the data dictionary (2456 plays)

Watch Again

Chapter

Note

Ask

Feedback

数据库设计那些事

Chapter1 demand analysis
1-1 Introduction to Database Design
1-2 Database design steps
1-3 Introduction to the importance of needs analysis
1-4 Needs analysis example
Chapter2 logical design
2-1 ER图
2-2 Summary of design paradigms
2-3 first normal form
2-4 second normal form
2-5 third normal form
2-6 BC paradigm
Chapter3 physical design
3-1 What to do in database physical design
3-2 Which database to choose
3-3 MYSQL commonly used storage engines
3-4 Naming rules for database tables and fields
3-5 Database field type selection principles
3-6 How to specifically select the field type in the database
3-7 Other considerations for database design
3-8 Denormalized table design
Chapter4 Maintenance optimization
4-1 What to do in database maintenance and optimization
4-2 How the database maintains the data dictionary
4-3 How databases maintain indexes
4-4 Suitable operations in the database
4-5 Vertical and horizontal splitting of database tables

Previous section Next Section

Course Recommendations
Courseware download

Students who have watched this course are also learning