Choose the Right Tool for Your Data: Python, R, or SQL
1h 8mBeginner2022-09-20
Authors
Megan Lieu
Data Scientist
Course details
Data professionals should choose the most effective and efficient tool for the task at hand. In some cases Python may be the right fit while R would be terrible in getting the job done, and in other cases the opposite may be true. Additionally, these coding languages are the most in-demand and essential, not only in data professions but also in several other tech fields. In this course Megan Lieu covers the use cases, pros and cons, and similarities and differences between using Python, R, and SQL in data projects. Megan covers the fundamentals you need to know for each language, shares real-world applications and examples for each, and shows you some case studies to show how you can use Python, R, and SQL to build your own projects.
Skills covered
RStatisticsSQLDatabase AdministrationDatabase DevelopmentPythonDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Choosing the right tool for your data
- 02 - What you should know
1. SQL
- 03 - What is SQL
- 04 - Types of SQL commands
- 05 - SQL data types
- 06 - Queries - The basic building blocks of SQL
- 07 - How to use functions to perform calculations
- 08 - Joins using table relationships
2. Python
- 09 - What is Python
- 10 - Python variables and data types
- 11 - Calculations in Python
- 12 - Analyses using functions and methods
- 13 - Analyses using libraries
- 14 - Visualizing data using Python
3. R
- 15 - What is R
- 16 - R objects, variables, and data types
- 17 - Calculations in R
- 18 - Analyses using functions and packages
- 19 - Visualizing data in R
4. Comparing SQL, Python, and R
- 20 - SQL, Python, and R in the data analysis toolkit
- 21 - Picking the right tool for the job
- 22 - Industry applications
- 23 - Case study - Tying all three tools together in the real world
Conclusion
- 24 - Next steps - Witnessing SQL, Python, and R in action