MySQL的学习之旅：课件篇（mysql 课件）

As a Freelancer, data manipulation is often part of your job. For this reason, knowing how to handle mysql databases and how to create or edit queries is essential.

I started my journey with MySQL by studying the foundational tutorials that are widely available online . As I had no prior experience with SQL, the tutorials were very helpful in setting the foundation. After that, I studied the different SQL commands and became comfortable in selecting, updating and deleting entries from my databases. Building up my confidence in SQL quicker than expected, I decided to work on larger projects and get more creative with my coding abilities.

The next step was to join a course on SQL learning. The teacher was really helpful, guiding me through the different topics needed to create databases and write complex queries. He taught me about the different types of data that can be stored in the database, storage engines and how to design a good database. Additionally, I used the book he recommended, which had many exercises that helped me to better understand the topics and to apply my knowledge.

To further increase my knowledge and experience with MySQL, I joined freelancing projects. My first project consisted of creating complex queries based on different criteria, which was very challenging. I overcame those challenges by applying my learnings and seeking help when needed. Working on these different projects allowed me to gain experience in communication, setting expectations and delivering on time.

Finally, after being comfortable with MySQL I decided to download a server and hosted one at home to do more independent practice. When developing my queries, I drew a visual of my data structure in order to have a clearer idea of the type of results I was expecting. This was very helpful in

solving problems and writing more accurate queries.

Now I feel confident in my ability to handle the databases, query and make decisions about the best approaches for solving complex problems. Moreover, I can see the importance of having a well thought-out data structure and how this makes it easier to create and manage the databases.

MySQL is an incredibly helpful and powerful tool, and I’m thankful for this learning journey.