SQL for Data Analysis: Students & Professionals
Published 8/2024
Created by Taesun Yoo
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 88 Lectures ( 11h 1m ) | 5 GB
What you'll 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.
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!