Practical MySQL for Data Analysis
- Description
- Curriculum
- FAQ
- Reviews
The human race is now generating more data than all of our history combined. Now more than ever, being able to analyze data quickly is a must-have skill.
And with all the different ways of analyzing data, it’s not easy to know where to get started.
How do you start analyzing data without having to invest years in mastering a programming language?
Welcome to the Practical MySQL for Data Analysis.
Here, you’ll be not only grasp the ins and outs of MySQL, but also truly understand all the queries that will solve the 80% of all your data analysis problems.
You’ll learn not only the logic behind SQL languages and MySQL, but also the most common queries you’ll find in any data analysis job.
What’s more, each video is broken down into tasks to help reinforce your learning and after the videos there are additional lectures into which you can dive!
So, you’ll go through all the fundamentals of what’s known as one of the easiest data science programming languages you can learn and exit the course being able to hold your own in the data analysis field.
Are you ready to jump into the data analysis field and hit the ground running?
See you in the classroom!
-
6Why use SQL for Data AnalysisVideo lesson
-
7Why MySQL for Data AnalysisVideo lesson
-
8How easy it is to use MySQLVideo lesson
-
9Our projects for this courseVideo lesson
-
10SQL LogicVideo lesson
-
11Relational vs. Non-relational DatabasesVideo lesson
-
12Learn more about RDBS vs NRDBSText lesson
-
13Database Management SystemsVideo lesson
-
14Installing MySQL on WindowsVideo lesson
-
15Installing MySQL on macOSVideo lesson
-
16Getting started with MySQLVideo lesson
-
17Importing a DatabaseVideo lesson
-
18Creating TablesVideo lesson
-
19Read more about creating tables!Text lesson
-
20Inserting data into tablesVideo lesson
-
21Data types in MySQLVideo lesson
-
22Read more about Data Types!Text lesson
-
23Breaking down the SELECT statementVideo lesson
-
24Get to know the Select statement wellText lesson
-
25Altering tablesVideo lesson
-
26Primary and Foreign KeysVideo lesson
-
27Connecting tablesVideo lesson
-
28Breaking down the WHERE clauseVideo lesson
-
29Read more about the WHERE clause!Text lesson
-
30Using the ORDER commandVideo lesson
-
31Logical operatorsVideo lesson
-
32Read more about logical operators!Text lesson
-
33Subqueries!Video lesson
-
34Using BETWEENVideo lesson
-
35Learn your LIMITVideo lesson
-
36JOIN the partyVideo lesson
External Links May Contain Affiliate Links read more