Data Analysis & Business Intelligence : MySQL for Beginners

[LeeAndro]

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 25 lectures (2h 52m) | Size: 880.7 MB

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.

Learn to write SQL queries, with Workbench, for first- coders

Write SQL queries in a simple way

Analyzing the data - Single table and multiple tables with JOIN

Problem solving by hands-on practicing with a real world data case

Learn how to extract, sort, filter and group the data efficiently

Get life access with resources and certificate upon completion

MySQL Workbench and community server ( We'll install it together )

No prior coding knowledge is required

In this Crash Course you will play a role of business analyst who works in a DVD rental shop

You 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 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)

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 structure

Data Analysis - Single Tables - Part 1:

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 MYSQL PROJECT]

This Crash course is Targeted for Students :

Students looking for hands -on practicing MySQL data analysis

Analysts and business intelligence professionals looking to analyze data stored in database system

Anyone looking to pursue a career in data analysis or business intelligence

Excel users looking to enhance their level into business intelligence and database

You will get a life access and a certificate upon completion

30-day money back guarantee

I am sure you gonna love the course, so let's dig in

This course gives you a deep, 100% comprehensive understanding of database fundamental ( Database administration will not covered in this course) ,and writing SQL code while analyzing the data. including sorting, filtering, and grouping, and connecting tables together and guide you through interactive, hands-on project every step of the way.

Students looking for hands -on practicing MySQL data analysis

Excel users looking to enhance their level into business intelligence and database

Analysts and business intelligence professionals looking to analyze data stored in database system

Anyone looking to pursue a career in data analysis or business intelligence




DOWNLOAD
uploadgig.com

https://uploadgig.com/file/download/5c0abf0491326429/Wto0CNex__DataAnalys.part1.rar
https://uploadgig.com/file/download/bA4Ba92F80f0cf5a/Wto0CNex__DataAnalys.part2.rar

rapidgator.net

https://rapidgator.net/file/63975406409ddbeff2950c79c8425d70/Wto0CNex__DataAnalys.part1.rar.html
https://rapidgator.net/file/9e046ab72c0b2aba189ac42d5252ece8/Wto0CNex__DataAnalys.part2.rar.html

nitro.download

https://nitro.download/view/179CA3BB03098DA/Wto0CNex__DataAnalys.part1.rar
https://nitro.download/view/576E91DD5FA2B6B/Wto0CNex__DataAnalys.part2.rar