SQL and Python For Data Analysis
Uploaded by
ScribdTranslationsSQL and Python For Data Analysis
Uploaded by
ScribdTranslationsObjective: This course aims to provide an overview of how a project works.
data, starting from the business needs with the specification and creation of the database
data, after the database is created and various SQL queries are performed, we will go to
the specification of business analysis needs and going through the creation of
Multidimensional Modeling, of the Data Warehouse, of Exploratory Data Analysis and of
Data Visualization. In the end, we briefly discuss SQL for large volumes.
of data, NoSQL Databases and a Clustering using Machine Learning.
SQL
• Course overview
• Behavioral characteristics
• Requirement Gathering for Database Creation
• Entity-Relationship Modeling - ERM
• Entity-Relationship Diagram–ERD
• What is a database?
• What is a Table?
• Overview of SQL Server
• Creation of the project database
• Creation of the project tables
• Populating the tables
• Consulting the tables
o Main SQL commands
• Business Intelligence - BI
o Data visualization with Power BI
o What is BI?
o Data Warehouse - explanation and assembly
▪ Data visualization with Power BI
• Exploratory Data Analysis with Power BI and Python
• Day to day of a Data Analysis professional
o NoSQL - Overview
o SPARK SQL
• Machine Learning with Python - Overview
• Extras