MySQL数据库实训报告 实训心得

Ha, your training report is too formal!这看起来不像是学校要交的作业吗？读完后我感到困了...你必须以不同的方式告诉我，就像我们通常做的那样！
上周有客户问我学习数据库是否只需要记住SQL语句即可。
我说你太天真了！ In practice there are many problems. Take your MySQL training as an example. It is not enough to just talk about theory.你必须开始输入代码才能知道你是否理解它。

你自己想一想：当你开始设计这七个模块时，你是不是很兴奋？产品、订单、库存……听起来很简单，但如果你真的需要设计表结构，例如：比如如何将用户表和订单表关联起来以及如何设置主键和外键，就变得很头疼。
记得2 02 3 年，一位同事在上海某商场做项目时，犯了外键约束错误，结果数据彻底乱了。
It took me a whole afternoon to fix the problem.我很生气！
Seriously, the “forgetting knowledge points” part you wrote is very true.上周调试代码的时候，我写错了JOIN语句。
I confused INNER JOIN and LEFT JOIN.这就导致了数据不匹配，搞得我头晕。
How did you solve it then? Should I read the book or ask my classmates?不管怎样，我通过网上搜索视频并单独观看每个案例终于弄清楚了。

What I find most interesting is the “performance optimization attempts” part. You said that GROUPBY stats are slow but indexing is faster.这非常重要！ Previously, when I created a small forum system, the users table was not indexed. Therefore, it took me a long time to check users' posting records every time.后来我添加了一个索引，它立即开始工作！ So you're right, no matter whether SQL is well written or not, performance is key.
Nevertheless, the “combination of theory and practice” you summarize hits the core.和协议模块一样，仅仅从书上看，我不明白为什么需要交易。
直到真正做这个项目后，我才意识到，在用户登录失败、没有交易的点更改失败等场景下，它确实行不通。
And what you said about “autonomous learning and collaboration” is so important!当你遇到难题时，你自己研究肯定会变得更好，但与他人讨论会立即扩展你的想法。

不管怎样，这次培训给你带来了很多吧？ At least go through the database design process and master SQL. But learning never ends, right? This time I laid the foundation.以后学习PostgreSQL、MongoDB等非关系型数据库或者熟悉数据库安全、备份和恢复就很自然了。

Okay, that's all I'm going to say. Don't worry about the formal written language. Either way, your education is very valuable.继续努力吧！

2020计算机毕业实习总结报告三篇

To put it bluntly: a final internship is a combination of theory and practice.目的是让您有机会将所学到的知识应用于实践并提高您的专业技能。
It's actually quite simple, but the complexity lies in the fact that many people don't realize the true meaning of an internship.
First let me talk about the most important thing.实习期间，我学习了四个月的日语，三个月的技术深入学习。
例如，我通过了日本J-Test E级考试，掌握了JAVA技术，并参与了一个物流仓库管理系统的设计和实现项目。
在此期间我使用了Struts和Hibernate框架并掌握了Java编程。
The development platform was Myeclipse and the database was MySQL.
还有一点：我发现学日语其实并不容易。
一开始我觉得日语很简单，后来发现学好日语很难，基础很重要。
我每天早上六点起床，早上读书，晚上也温习。
每周都有日语考试，一开始我很不习惯，甚至连续几次不及格。
But after I gritted my teeth and persevered, my results quickly improved.
还有一个细节非常关键。
在项目过程中，我意识到需求分析和软件测试是多么重要。
一个项目需求分析占4 0%，软件测试也占4 0%，写代码只占2 0%。
这让我意识到，写程序不应该浪费太多时间，而应该注重整体规划和文档编写。

一开始我以为实习只是理论知识的应用，后来发现实习是培养解决实际问题的能力。
等等，还有一点，就是软件数据库的操作。
I think it is crucial to the software.
最后，我想提醒大家一个简单的陷阱：不要野心太大，要好好学习。
我认为值得尝试的是在整个学习过程中不断提出问题、消除疑虑，这样才能真正提高自己的技能。

软件测试实习总结

1 、实习关键：技术知识是基础，但方法、心态和实践能力更重要。
2 、会议效率：调查显示，项目经理有2 5 %的时间浪费在无用的讨论上。
目标和纪律应该明确。
3 .尊重程序员：尊重员工，避免负面行为，例如管理者不尊重开发人员的情况。
4 .软件项目管理：注重XP Ideas等新技术的集成，并使用项目管理工具和模板。
5 .实习经历：实践训练培养兴趣，巩固C++知识，培养逻辑思维和分析能力。
6 、实习目标：提高实际操作水平、独立思考和解决问题的能力。
7 、测试的重要性：测试是揭示错误而不是确认正确性，因此需要加强研发团队的开发。
8 、性能测试：关注系统性能测试，上线前模拟问题，规避风险。
9 、实习总结：软件测试的重要性，个人发展与公司发展相结合。
1 0、产品研究：了解竞争对手和市场，提高产品网络搜索排名。
1 1 、个人感悟：认识自己的不足，寻找解决办法，积极学习。
1 2 、行动计划：系统跟进，熟悉产品和环境，提升业务能力。

mysql网上书店实训项目

Oops, let's talk about the MySQL online library training project. This is a trap I fell into then. I remember that time, around 2 000, when our school started this project. At that time I was still young and didn't understand anything, so I just followed the teacher.
When analyzing requirements, we needed to meet the needs of both users and administrators.用户端必须能够阅读书籍、搜索书籍、管理购物车、查看订单和更改密码。
The admin side needs to be able to manage book categories, book information, orders, store associate information, and change passwords. The functional modules are clearly divided and everything needs to be covered, from purchasing to management to maintenance.
When designing the database, we used a relational database and created several main tables, such as book table, catalog table, order item table, order table and user table. Each table has a primary key and a foreign key, and data consistency must be ensured, for example by using the ALTERTABLE statement to add foreign key constraints.
When implementing functions and selecting technology, we chose MySQL as the database, Java as the development language, and also used C to do some of the work.您需要实现登录验证、图书搜索、订单管理等关键功能。
性能优化期间，我们添加了索引，缓存了热门书籍的数据，并使用JMeter进行了高并发场景的测试。

Evolution and challenges of the project, there are many things. From concept in 2 000, to prototype development in 2 001 , to modularization in 2 005 , to database optimization in 2 01 0, and finally to cross-platform access support in 2 02 3 . In terms of technical decisions, we chose MySQL because it supports complex queries and has high reliability. The architecture is designed around core modules such as user management, book management and order management.
At the time of troubleshooting, we need to monitor the system for real-time alerts and analyze the fault spread path based on the timing diagram. I remember one time an order query returned empty data.我们通过序列图分析很快发现并解决了问题。

By the way, it seems like time flies so fast. The trap in that moment is pretty interesting now that I think about it.