Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 38 Minute(s)
Language
English
Taught by
Adnan Haroon
Rating
Course Overview
Learn the four key pillars of Data Analysis: Databases , Data Modeling , SQL and Data Visualization.
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.
In my 20 years of consulting experience nearly all IT project have elements of data analysis that is needed where basic SQL and data visualization skills are needed to produce key insights. This course will give you the necessary foundations needed to perform data analysis in your project.
I will try my best to keep this course up to date by adding more relevant lectures and lab exercises.
Course Content
- 12 section(s)
- 70 lecture(s)
- Section 1 Introduction
- Section 2 Getting Started - Overview and Installation
- Section 3 Data Modeling
- Section 4 Structured Query Language (SQL)
- Section 5 Table Joins
- Section 6 SET Operators
- Section 7 Summary & Grouping of Data
- Section 8 SubQueries
- Section 9 Functions
- Section 10 Conditional Logic
- Section 11 Analytical Window Functions
- Section 12 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
Skills covered in this course
Reviews
-
CClaudia Maria Munaico-Clarke
I am in the Section 2, and the most importnt part, which is explaning what a DB is and how it is structured it is really poor. I will wait and continue and see if there is more information in the following sections.
-
BBabatunde Olorunfemi John
Yes, it serve as my foundation in SQL and data visualization
-
DDarrell Graves
Often there is background noises that cause distractions or even confusion to the participant. The course seems to have ben modified enough that it felt like it missed or did not cover something prior to what is was currently covering.
-
BBhanu Guntupalli
It was a good learning experience but the subtitles could be a bit more accurate
