Business Intelligence & Data Analysis: MySQL for Beginners

About this course

In this Crash Course you will play a role of business analyst who works in a DVD rental shopYou will use only MySQL database and MySQL Workbench to achieve the objectives the are required by the manager who needs you to analyze the data Don't worry I will be there for you, guiding you to from start to finish and assist you in your homework and project to explore MySQL database ( Community Server and MySQL Workbench)          What you will learn:Write SQL queries in a simple way!Analyzing the data - Single table and multiple tables with JOINProblem solving by hands-on practicing with a real-world data case.Learn how to extract, sort, filter and group the data efficiently.Course Outline:Into to SQL :I will start a quick intro to database and data analysis and how we can use SQL in database analysis MySQL (Community and Server ) :we will install MySQL the community and connect MySQL Workbench to the Server and then how to connect our source database to the server and an introduction to database structureData Analysis - Single Tables - Part 1:In this section we'll start exploring and extracting information from individual tables in our MySQL database, and practice writing SQL queries to select, filter, sort and group our data.Data Analysis - Single Tables - Part 2:In this section, we'll review the most common types of SQL joins (INNER, LEFT, RIGHT, OUTER, etc), and explore some more complex MySQL queries to analyze data that bridges multiple tables in our database.Course Project :[FINAL