MySQL creating and managing relational databases
What you'll learn
- MySQL
- SQL
- databases
- relational databases
- CRUD
- creating databases in MySQL
- managing databases
- loading data from files
- saving data to files
- joining tables
- managing tables with multilevel relations
Requirements
- willingness to learn
Description
The course is designed for people who have not had contact with the SQL language yet, but want to learn how to work with relational databases. In the course, we discuss all the necessary issues, work with examples and exercises, starting from the basics: what is SQL and how to install and run a local MySQL server on your home computer, how to use SQL itself from both the console and MySQL Workbench. Then we discuss the topic of CRUD: Create, Read, Update, Delete where we discuss all these activities in detail. The next stage will be text and aggregate functions where you will learn to modify the results of database queries. Next, an important step will be learning how to create queries with a logic layer and calling the appropriate conditions that will make the query result dependent on their fulfillment. Finally, we discuss the topic of relations - their types, how to create and invoke, handle them or activate events with triggers. At the end of the course, we will work on the data set in several tables connected by relations. In each section you will also find additional exercises that will allow you to check your knowledge and skills as well as notes summarizing the issues discussed.
Who this course is for:
- beginner database administrators
- beginner database developers
- students
- people who need to organize their data systems
- researchers
- everyone interested
Instructor
I have a background in hydrology, and my work revolves around issues related to water resources and the dynamics of extremes such as droughts and floods. A significant part of my work involves analyzing spatial data, whether it's environmental features, the spatial distribution of work results, or data such as satellite imagery. I have been involved in teaching GIS since 2015, when, during my doctoral studies, I took on the responsibility of teaching Statistics and GIS in hydrological studies. A year later, I expanded the subject to cover the full range of GIS. This course served as the foundation for further work on materials in this field, leading to the publication of the first online course 'Introduction to GIS in QGIS3', in late 2018 and early 2019. Originally published on the Udemy platform, the course quickly gained the status of the highest-rated and bestseller.
In 2019, a modified version of the course was released in English, followed by two additional levels in the subsequent years. Since then, I have trained over 20,000 individuals, both in traditional classroom settings and online. Throughout my teaching career at a Polish university, I consistently ranked among the top ten instructors, and my online courses garnered over 2000 reviews with an average rating of 4.7 out of 5. At the end of 2021, I moved to the United States, where I currently work as Assistant Research Professor. In my daily work, I process large amounts of data using QGIS and ArcGIS programs, as well as scripts I write in Python. Large databases also require substantial computational power, but fortunately, in addition to workstations, I have access to a supercomputer (currently equipped with 70,560 cores and 350 TB of RAM, with its computational power set to double soon) for conducting necessary scientific calculations.