[FreeCoursesOnline.Me] SkillShare - Business and Data Analysis with SQL

Lynda and other Courses >>> https://www.freecoursesonline.me/

For Developer Tools & Apps >>> https://ftuapps.com/

Forum for discussion >>> https://1hack.us/







Created by: Geoff Devitt

Language: English

Released: 2020

Course Source: https://www.skillshare.com/classes/Business-and-Data-Analysis-with-SQL/283891160



Description



Have you thought about working with big data but don't know where to start?  In this course, you will learn the skills of what it takes to become a data and business analyst.  



What we will cover:

1) Database and datawarehouse design

2) How to write queries in SQL (Structured Query Language)

3) How to build interactive dashboards and reports

4) Tips and techniques on how to run your own big data project from start to finish



My name is Geoffrey Devitt and I have been working with Big Data and Databases for the past 20+ years.  In this course, I will share with you an overview of the skills I have learnt over the years of working on numerous data driven projects. As a data and business analyst, I have had the privilege of working in many different industry sectors, including financial banking, online gaming, eCommerce retail, insurance and telecoms.



With the knowledge you will gain from this tailored course, you will be able to fit into any industry and be in a position to start adding value to your team from day one.



Class Projects



Throughout the course you will practice writing SQL queries using the MySQL database.



Skills in this Class



• Business

• Data Visualization

• SQL

• Product Management

• Data Analysis

• Business Intelligence

• Business Analytics



Projects & Resources



Throughout the course you will practice writing SQL queries using the MySQL database.  Once you have learnt the fundamentals of wiring SQL queries and taking data requirements, we will move onto a Video Store Sales related project.  The project will mimic many of the likely scenarios you are to be challenged with when working as a business or data analyst on a daily basis and how to address them.  I will walk you though the query building process and project management skills I've learnt over the years, to ensure your projects are delivered on time and meet your clients requirements.

By the time you finish this course, you will have a the skills you require to go out and start running your own successful data projects.