Statistical Analysis and Modeling Using SQL and Python
Number of lessons:
SQL is a dominant data analysis language since data are usually available in a structured, database format. Most analyses involve a lot of filtering, grouping, sorting, and aggregation, for which SQL is quite handy to use. Python, on the other hand, has well-known libraries, specially designed for data analysis and statistical modeling. This course teaches how to perform descriptive, diagnostic, and predictive analytics using functions, procedures, and best practices in both SQL and Python. Combining the use of SQL to retrieve and process the essential data for analysis, together with the use of specialized Python libraries for more complex data manipulation, analysis, and modeling is also discussed.