Data Analysis & Business Intelligence with MySQL/Python/SQL
Learn how to use SQL to extract, sort, filter, and group data efficiently. Analyze data across multiple tables with MySQL JOIN statements. Perform calculations using aggregate functions and analyze data using subqueries. Manipulate data using Python Pandas and visualize data with Python. Perfect for data analysts, business intelligence analysts, and data scientists.
Write SQL queries to explore and analyse databases with MySQL WorkbenchLearn how to use SQL to extract, sort, filter, and group data quickly and efficientlyAnalyse data across multiple tables with MySQL JOIN statementsAnalyse data and perform calculations using aggregate functionAnalyse data using subqueriesAnalyse data using various functionsAnalyse data using various OperatorsAnalyse and manipulate data using Python PandasPerform data cleaning with PythonVisualize data with PythonSQL 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 AnalystsBusiness Intelligence AnalystData Scientist
User Reviews
Be the first to review “Data Analysis & Business Intelligence with MySQL/Python/SQL”
You must be logged in to post a review.
There are no reviews yet.