R Programming for Data Analysis: Ultimate Guide

Complete SQL Programming: MySQL, Database Management, Data Analysis, Business Intelligence and Database Design

Created by: Taesun Yoo
Senior Data Analyst | Online Course Instructor

What Will I Learn?

• Installing MySQL Server and Workbench for a seamless database environment setup.
• Create and manage databases, including creating and dropping databases, managing tables, and verifying data integrity.
• Utilize SQL for loading and writing data frames, extracting data, and crafting complex scripts to address business questions
• Understand various SQL business use cases and apply best practices to tackle real company data problems
• Master SQL joins, including INNER, LEFT, RIGHT, FULL OUTER, and CROSS joins, to combine data from multiple tables.
• Implement set operations like UNION, INTERSECT, and EXCEPT to combine results from different queries.
• Perform advanced data manipulation with SQL functions and aggregations, such as SUM, AVG, COUNT, GROUP BY, and HAVING.
• Develop complex subqueries and utilize Common Table Expressions (CTEs) for improved query readability and performance.
• Modify data with SQL commands for inserting, updating, and deleting records.
• Handle errors in transactions, implement error handling and ensure data integrity.

Requirements

• Operating Systems: 64-bit versions of Microsoft Windows 7, 8.1 and 10 or Mac
• MySQL Server and Workbench.
• Some fundamental knowledge of data structure concepts will be beneficial.
• No prior experience in other tools like R or Python.

Target audience

• Individuals with no prior experience in data analysis tools.
• New graduates considering a data analytics career.
• Career switchers aiming to become data analysts or upgrade their skills in SQL and database management.