Learning #MySQL at SoyData.Net

Posted by in Databases, MariaDB, MySQL



This entrance is dedicated to a new website for learning #BigData in spanish: SoyData.net.

What is SoyData.net

It is a collaborative online training platform on all matters relating to data in spanish. It now has 15 fully uploaded and available courses to which they have registered more than five hundred people in just two weeks. These courses address specific high demand technologies like Hadoop, MongoDB, R and cover key areas such as visualization, cloud computing or Structured Query Language (SQL). It also provides an introduction to #BigData concept for those who want to understand this phenomenon in depth. The aim is to make a two-way platform, where you can both learn how to teach if you have specific knowledge and want to share, free or making money as an instructor.




The people behind this site are Big Data 4Success, a website related to Big Data in spanish. Big Data 4Success (BD4S) want to increase the courses trying to cover all aspect related to data. All those interested in entering this sector or data scientists who want to expand their training in SoyData.Net have a resource that will be very useful. Soon they will be raising more courses on business intelligence, data journalism, (very important and almost no training in this), programming, statistics, machine learning and legal issues, and more.

BD4S is aiming to be the main reference related to TI professional and businesss in Spain and Latin America, who want to be informed about everything that happens on the data and its application to the business world.

Also, I will review one of the course offeret: Learning MySQL.

Learning MySQL

I did the course Learning MySQL, a course divided into 6 units, in total, 28 videos about 6-7 minutes each.

The first module is an introduction and the story of MySQL since its creating until tody: the most used database for Internet. In addition, general database concepts are defined, so the level of prerequisites is none. Don’t forget that the goal is to learn MySQL, and what a better way to engage those who want to start, so it’s good to have this knowledge. you can also learn the evolution of databases, from the ’70 to the Cloud and NoSQL databases (which I have also spoken at #manejandodatos.es).

A description of what a relational database is, what features it has, and what are the MySQL features are described. Before concluding this module, you can learn the different types of data you have MySQL and its characteristics, since each type has to be accommodated to their needs (for performance, of course!). The last video is dedicated to the tables, attributes and indexes.

Second module is dedicated to general databases concepts, but deeper. There is a video about  relationships between entities, a key concept for understanding relational databases. Standardization is one of the fundamental aspects of the theory of databases, which should meet for the good organization of tables in preparing a database on a system. The last of the videos is that downloads and installs MySQL to start on.

Third module is dedicated to practice about all explained in module 2. You can view a entra en materia de lo explicado en el anterior módulo. The Entity-Relationship model that you work with on the rest of the course is displayed and explained. The administrator is using MySQL WorkBench, which was discussed here on several occasions (the WorkBench modeling tool is pretty good), and detailing exactly how to work with it to develop models databases.

Next module is focused on DDL, that is, the SQL sentences for working with database definition model: create, alter, drop, truncate, … It is fairly complete, and it ends up with select and a wide variety of queries using between, in, …. so you can try everything.

Fifth module is dedicated to JOIN, the keyword that allow databases to use info from severtal tables. Different types of joints with good detail explained. In addition, you will learn sentences with aggregation such as COUNT, SUM, AVG, MAX, MIN, … in order to get the best performance. Stored procedures and functions can also be programmed in the database, which may or may not return value, written in MySQL commands are explained. Last part of this module is for subqueries.

And finally, the last module is for views, data structures that are defined without data, because they come from other tables. Triggers are events associated with tables, and transactions, another important feature of databases.

The last video is dedicated to best practices for working with databases, since there is no strict set of rules that should be followed for the proper functioning and performance of databases. This includes how the tables, fields, views are named, … not a rigid standard, but doing things in order.

The course ends up with a comparison between relational databases and MongoDB databases, which are a different concept of databases. Only as a little of coulture it is also named Hadoop, a platform for Big Data.

The course has a good development for the newcomer, the videos are of good duration (they are neither too short nor too long), so with a little dedication students con progress a lot. Also, the example used touches all concepts … just say it’s worth if you want to learn MySQL, a database from which there is much talk in this blog. It also makes use of WorkBench as an administrator, so you learn a lot, including how to ERD schemes

SoyData.net for learning Big Data

Although this is a newcomer to the mass and collaborative training courses, the platform is good, and we expect its consolidation. Now, there more than 1.100 students, so … why aren’t you a student too?

And that’s all. I encaurage you to join to this funny course and of course, I want to say Thanks to Jorge Ubero for allowing me to dive into SoyData.Net.

Happy coding!

Google+ Comments - Comentarios Google+