MySQL and Database Management: From beginner to Expert
4.7 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
103 students enrolled
Wishlisted Wishlist

Please confirm that you want to add MySQL and Database Management: From beginner to Expert to your Wishlist.

Add to Wishlist

MySQL and Database Management: From beginner to Expert

Learn how to properly manage and analyze complex databases using SQL! No previous knowledge required.
Bestselling
4.7 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
103 students enrolled
Created by William Starr
Last updated 6/2017
English
Current price: $10 Original price: $100 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 15.5 hours on-demand video
  • 25 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
Requirements
  • There are no prerequisites to this class, other than a pc/mac, and a healthy appetite for learning new things.
Description

  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.

Who is the target audience?
  • This is for any student wanting to learn about data management and MySQL programming. A lot of the things I will be covering will be beginner level, but I will go into a lot of conceptual data management theories which will test even an expert's knowledge.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
81 Lectures
15:31:37
+
INTRODUCTION AND INSTALLATION OF MySQL
2 Lectures 06:08

This introduction is intended to showcase the many concepts we will be going over in this class. As you can see by going through the course, each lecture and section is supplemented by many, many practice problems. MySQL, along with many coding languages, requires tons of practice to get used to some of the terminology and structuring. I have constructed this course to provide you guys with as much practice as I can, so you don't have to constantly rewatch my lectures to remember how to do something. 

Preview 02:06

In this lecture you will execute the two free databases we will be using extensively in this course.

Preview 04:02
+
WHAT IS A DATABASE AND HOW DO WE MODEL IT?
5 Lectures 27:16

Database Management
04:27

Database Management Part II
04:09

Database Theory Quiz
02:46

Database Theory Answers
10:55
+
BASICS OF SQL AND SINGLE ENTITIES
15 Lectures 01:49:40

Modeling Reality
06:07

Creating a Table in MySQL
08:52

Inserting Rows
15:25

Querying a Table
05:03

Retrieval of Values
05:10

Ordering Output
03:46

Calculating
06:39

Built-In Functions
03:42

Subqueries
07:05

Regular Expression
07:56

Distinct
03:06

Modifying Existing Rows in a Database
02:58

Basics of SQL Quiz
05:04

Basics of SQL Answers
27:36
+
ONE-TO-MANY RELATIONSHIPS
11 Lectures 01:53:16

Why Create a One-to-Many Relationship?
05:27

Creating the Tables in MySQL
14:44

Joins
01:58

Group By
07:31


More Functionality of REGEXP
13:08

Correlated Subqueries
11:48

Views
09:19

One-To-Many Quiz
03:04

One-To-Many Answers
39:31
+
MANY-TO-MANY RELATIONSHIPS
8 Lectures 01:22:48

What is the purpose of Many-to-Many Relationships
05:05

Three Table Joins
06:12

Exists/Not Exists Functionality
08:30

Divide
05:56

Union
10:23

Many-to-Many Quiz
05:07

Many-to-Many Answers
35:23
+
ONE-TO-ONE AND RECURSIVE RELATIONSHIPS
10 Lectures 02:19:41

Mapping the Relationships
16:48

Querying the Relationships
10:11

How to Model a 1:1 Recursive Relationship
04:17

How to Model a 1:M Recursive Relationship
24:55

More on Querying
08:33

Modeling a M:M Recursive Relationship
09:26

Querying a M:M Recursive Relationship
10:47

1:1 and Recursive Relationships Quiz
06:11

1:1 and Recursive Relationships Answers
41:23
+
Advanced Data Modeling Techniques
8 Lectures 01:16:26

Geography
08:19

Family Matters
10:36

Bookish Matters
02:58

History
05:31

Entities
09:27

Data Modeling Review Questions
06:01

Data Modeling Review Answers
18:58
+
Spatial and Temporal Databases
6 Lectures 01:07:45

Spatial Modeling
13:38

Spatial Querying
17:03

Temporal Databases
08:34

Spatial and Temporal Databases Review Questions
03:36

Spatial and Temporal Databases Review Answers
18:57
+
MySQL Final Exam
2 Lectures 01:02:58
MySQL Final Test
10:56

MySQL Final Answers
52:02
+
NBA Today Data Model
7 Lectures 01:53:33

Data Model Part I
17:25

Data Model Part II
11:11

Mapping the Data Models
24:24

Inserting the Data
20:52

Queries Part I
20:40

Queries Part II
16:06
1 More Section
About the Instructor
William Starr
4.7 Average rating
5 Reviews
103 Students
1 Course
Freelancer Database and iOS Developer

Hi Students of Udemy!

        My name is William Starr, and I have been coding since I was 12 years old. I first started working with MySQL and other Data Analytics software about 2 years ago and I absolutely fell in love. Data Analytics is my passion, and I currently have a data analytics position at a major company, where I analyze terabytes of data every day. While in college, I won several case competitions relating to Data Analytics, and tutored several students in the art of data management and analytics.

      I love sharing my knowledge with others, and I hope you can see my passion for this very lucrative field. Whether you want to work at some of the biggest companies in the world, or start up your own, Data Analytics is a necessity.