MySQL and Database Management: From beginner to Expert

MySQL and Database Management: From beginner to Expert

  My hope is that through this class, I can share my love for data analytics with you guys, and also teach you things you would normally have to go to a 4 year college for. Almost every job in the world now relies on Data Analytics. Not only that, but companies will pay huge amounts of money for people with these skills, since it is still such a new market. While this course focuses on MySQL, I will be going over topics that extend into other realms of data analytics, going in depth into what it takes to properly manage a database, and how to analyze a database into meaningful results for a company. 

The course follows the following format:

• The first section is an introduction into what MySQL, with an installation of the software as well as the two free data models we will be working with extensively in this course.
• The next section is a high level overview of data, and database management. I make sure to touch on how data applies to all forms of software and uses, not just within MySQL. At the end will be a review covering the topics we learned, in a way that also tests your ability to apply the new concepts to conceptive questions.
• The following section will be going over all the basics of SQL, introducing all the topics right away so we can reuse and reapply the functionality over and over in the following sections in more complex queries. The questions at the end will give you a chance to reapply the section's materials in a meaningful way.
• The next section will be an introduction of relational databases, specifically the 1:m relationship. With this introduction, we will start going over more difficult concepts, slowly building on materials learned in previous sections. Again, this will feature a review quiz at the end, further solidifying all the material you have learned so far. 
• In the many to many section, we will be covering a more advanced relational database, and introduce more MySQL topics scattered throughout the section. As always, we will have a review lecture, and I will make sure to explain the process of data modeling and querying as we go along. 
•  In this section we will discuss the final relational modeling concepts, 1:1 relationships and recursive relationships. This will push your understanding of data analytics from beginner to intermediate stages. Recursive relationships are the most difficult to master, so I will be spend a considerable amount of time going over the intricacies in the formulation of each data model. At the end, there will be another review section, which will provide you with another opportunity to go over the material.
• This section will be a wrap up of data modeling, and we will be going over some more complicated examples of model creation, as well as the rules and standards associated with this field. This review section is set up to test all the data modeling practices we have learned so far in a meaningful and challenging way.
• In this section, we will talk about Temporal and Spatial Databases, one of the newest and challenging concepts related to Data Analytics. We will go over how these topics are being used to reshape the database world, and go over some of the querying and data modeling techniques associated with them. We will have a review section, touching on the topics learned, as well as showing some conceptual questions related to these young database techniques. 
• The final exam will be featured in this section, which will wrap up everything we have learned into final queries and data modeling examples that will test your knowledge, and give you a chance to see what areas you still need improvement in. 
• This is the first of two bonus sections, introducing two real world database models you would design for clients in MySQL. The data model in this section is an NBA statistics App, called NBA Today,  that we will use to model questions and queries faced by a similar mobile application that is available in the App Store. This will give us a chance to see how data analytics and data modeling is used to solve real world problems.
• The second bonus section is a business database model, in this instance, a prison system that we have been tasked with answering queries about that will introduce new querying topics and show what a business model will look like when we apply the lessons we have learned. We will build everything from scratch, and I will even show you how I created the dummy data using excel. 

I hope you guys are excited as I am to get into the world of Data Analytics and Database Management. Whether you are a student, trying to learn a new skill, or an entrepreneur, MySQL , and more importantly, data analytics is an extremely important skill to have in today's world. Please, don't be afraid to ask any questions, I will be more than happy to answer them as best as I can.

Learn how to properly manage and analyze complex databases using SQL! No previous knowledge required.

Url: View Details

What you will learn

• Students will be able to properly model a database, and how to analyze and work with the data presented to produce meaningful and concise answers to problems. This is supposed to introduce students to many of the problems professionals in the field of data analytics and data modeling face on a daily basis. I will also introduce data management in relation to app development, where you will learn how to properly design a SQL database in xcode.

Rating: 3.55

Level: All Levels

Duration: 15.5 hours

Instructor: William Starr