Beginners Data Analysis Bootcamp with SQL 2020

Beginners Data Analysis Bootcamp with SQL 2020

Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 703 MB

Genre: eLearning Video | Duration: 70 lectures (3 hour, 38 mins) | Language: English

Learn the four key pillars of Data Analysis: Databases , Data Modeling , SQL and Data Visualization

What you'll learn

Understand the foundation of data analysis and explain the key areas of database, modeling, visualization and insight.
Be able to understand and create data models in relational database environment
Be able to write simple to complex SQL queries in a production environment
Create compelling data visualizations for professional projects
Be able to use MYSQL database to interact with data and gain insight

Requirements

No previous programming language experience is required.
You will need a working computer with any operating system installed on it (Windows, Mac or Linux).
You don't need to buy any additional software we will install MYSQL and Tableau software which will be free of cost.

Description

This course will teach you the four building blocks of data analysis in a very structured way

* We will first learn about databases and database management systems with the focus of data accessibility. Our preferred DBMS will be MYSQL.

* We will then learn the foundation of Data modeling for relational DBMS and gain knowledge about how data is related and how the design of data models help in capturing business use cases.

* We will take a deep dive in learning SQL; from writing simple scripts to advance analytical functions to gain insight.

* The last section will focus on data visualization and we will use Tableau software as our data visualization tool with many examples to showcase our story telling skills.

By taking this course you will gain experience in designing data solutions which will make you more marketable and competitive in the job market.

I will try my best to keep this course up to date by adding more relevant lectures and lab exercises.

Who this course is for:

Anyone interested in learning data analysis from ground up using the four keys areas that is database , data modeling , data insight and data visualization for their current or future job needs.
Anyone looking to switch careers to focus more on data related jobs
Developers who want to learn SQL and Data modeling for their current projects
Business analysts who want to better understand their data requirements for key applications
Students who want to learn new skills for academic purposes
Anyone curious to learn about data and be able to tell a story and gain insight

Download:

http://longfiles.com/ovrlruqqjspi/Beginners_Data_Analysis_Bootcamp_with_SQL_2020.rar.html

[Fast Download] Beginners Data Analysis Bootcamp with SQL 2020


Related eBooks:
Big Data Analysis Using Machine Learning for Social Scientists and Criminologists
Database and Expert Systems Applications
SQLScript for SAP HANA
Hierarchical & Recursive SQL
Algorithms and Architectures for Parallel Processing
Algorithms and Architectures for Parallel Processing
Beginning Entity Framework Core 2.0: Database Access from .NET
Ethical Data and Information Management: Concepts, Tools and Methods
MySQL in a Nutshell
MySQL Administrator's Guide and Language Reference (2nd Edition) by MySQL AB
Hadoop 2 Quick-Start Guide: Learn the Essentials of Big Data Computing in the Apache Hadoop 2 Ecosys
Excel ADVANCED
Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.