17 OCT 2024 - Welcome Back to TorrentFunk!
Get your pirate hat back out. Streaming is dying and torrents are the new trend.
Account Registration works again and so do Torrent Uploads.
We invite you all to start uploading torrents again!

TORRENT DETAILS

[FreeCoursesOnline.Me] SkillShare - Business And Data Analysis With SQL

TORRENT SUMMARY

	Status:	All the torrents in this section have been verified by our verification system
Category:	Other
Infohash	46b8ae29af655f6d2c71c8c95d8bc3cb66cdd62c
Size:	2.2 GB in 39 files
Release Date(s):	Torrent Release: 13-02-2020 by user
Swarm:	0 Seeds & 0 Peers
Vote:	No votes yet.

DESCRIPTION

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.

VISITOR COMMENTS (0

)

FILE LIST

Filename		Size
	0-Business and Data Analysis with SQL.mp4	72.9 MB
	0. Websites you may like/How you can help our Group!.txt	208 B
	1-Introduction to Databases A History.mp4	28.6 MB
	10-MySQL Server Setup.mp4	17.8 MB
	11-MySQL Server Start and Stop Service.mp4	22.8 MB
	12-Connect to database.mp4	34.8 MB
	13-Comments in SQL.mp4	14.4 MB
	14-Selecting data from a table.mp4	84.7 MB
	15-Table indexes.mp4	22.7 MB
	16-Table and column aliases.mp4	14.4 MB
	17-Inner Join Tables.mp4	22.9 MB
	18-Left and Right Outer Join Tables.mp4	14.1 MB
	19-Union all Results.mp4	10.3 MB
	2-SQL Statement Categories.mp4	21 MB
	20-Project Management Agile Methodology.mp4	37.6 MB
	21-Kanban boards.mp4	59.5 MB
	22-Prioritise Requirements using MoSCoW.mp4	21.4 MB
	23-Sales Project Introduction.mp4	97.1 MB
	24-Create database.mp4	43.6 MB
	25-Query Workflow.mp4	28 MB
	26-Sales Project Part 1 Data Capture.mp4	157.1 MB
	27-Sales Project Part 2 Data Analysis.mp4	49.9 MB
	28-Sales Project Part 3 Data Summary.mp4	100.5 MB
	29-Sales Project Part 4 Send to production.mp4	133 MB
	3-Capture Data Requirements.mp4	45.7 MB
	30-MySQL Query Explain Plan.mp4	38.4 MB
	31-Common Table Expressions WITH.mp4	69.8 MB
	32-User Administration.mp4	120.1 MB
	33-MySQL Set Environment Variable.mp4	80.7 MB
	34-MySQL Command Line.mp4	188.5 MB
	35-Export results to Excel.mp4	130.5 MB
	36-Setup MySQL ODBC Connector.mp4	86.9 MB
	37-Create a report in Micorsoft Excel.mp4	252.4 MB
	4-Physical vs logical data representations.mp4	21.2 MB
	5-Normalise Data.mp4	38.4 MB
	6-Fact Tables.mp4	21.8 MB
	7-Aggregrate data.mp4	27.3 MB
	8-Entity Relationship Diagrams ERD.mp4	25 MB
	9-Extract Transform and Load Data ETL.mp4	42.6 MB

RELATED DOWNLOADS

Torrent Name

Added

Size

Seeds

Peers

Uploader

Health