Free download » Free download video courses » Bussiness and Marketing » Data Analysis & Business Intelligence with MySQL/Python/SQL
  |   view 👀:21   |   🙍   |   redaktor: Baturi   |   Rating👍:

Data Analysis & Business Intelligence with MySQL/Python/SQL

Data Analysis & Business Intelligence with MySQL/Python/SQL
Published 12/2022
Created by Digital Learning Academy
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 60 Lectures ( 5h 41m ) | Size: 1.64 GB


Hands-on Data Analysis & Visualization with SQL and Python
What you'll learn
Write SQL queries to explore and analyse databases with MySQL Workbench
Learn how to use SQL to extract, sort, filter, and group data quickly and efficiently
Analyse data across multiple tables with MySQL JOIN statements
Analyse data and perform calculations using aggregate function
Analyse data using subqueries
Analyse data using various functions
Analyse data using various Operators
Analyse and manipulate data using Python & Pandas
Perform data cleaning with Python
Visualize data with Python
Requirements
MySQL Database Server is required( I'll walk you through the installation)
MySQL Workbench is required( I'll walk you through the installation)
Basic knowledge of database concepts advised
Description
SQL stands for Structured Query Language. SQL lets you access and manipulate databases.SQL can execute queries against a database. SQL can retrieve data from a database.Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!MySQL is an open-source relational database management system. MySQL is currently owned by Oracle and MySQL is free and open-sourced under the terms of the GNU General Public License and available under a variety of proprietary licenses.MySQL is  used by many database-driven web applications such as Drupal, Joomla, and WordPress.You will learn how to write queries in SQL (specifically MySQL) that will allow us to access the data inside a database. What is Python? Python is a computer programming language often used to build websites and software, automate tasks, and conduct data analysis.Pandas is a fast, powerful, flexible and easy to use open source data analysis and manipulation tool,built on top of the Python programming language.In this course we will query, analyse and retrieve data from a MySQL Database using SQL and also analyse and manipulate pandas data frame with  Python and also visualize data. We will also be performing some data cleaning using Python.
Who this course is for
Data Analysts
Business Intelligence Analyst
Data Scientist
Homepage
https://www.udemy.com/course/data-analysis-business-intelligence-with-mysqlpythonsql/




Please Help Me Click Connect Icon Below Here and Share News to Social Network | Thanks you !

In today's era of digital learning, access to high-quality educational resources has become more accessible than ever, with a plethora of platforms offering free download video courses in various disciplines. One of the most sought-after categories among learners is the skillshar free video editing course, which provides aspiring creators with the tools and techniques needed to master the art of video production. These courses cover everything from basic editing principles to advanced techniques, empowering individuals to unleash their creativity and produce professional-quality content.

Comments (0)

Information
Users of Guests are not allowed to comment this publication.