Tags
Language
Tags
<<
June 2025
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz
    1. Home
    2. eBooks & eLearning
    3. Data Analysis & Business Intelligence with MySQL/Python/SQL

    Data Analysis & Business Intelligence with MySQL/Python/SQL

    Posted By: lucky_aut
    Date: 30 Dec 2022 12:28:10
    Data Analysis & Business Intelligence with MySQL/Python/SQL

    Data Analysis & Business Intelligence with MySQL/Python/SQL
    Published 12/2022
    Duration: 05:41:08 | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 1.64 GB
    Genre: eLearning | Language: English

    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

    More Info
    UPWARDS