COURSE DESCRIPTION

A lot of data in the world today is stored in databases. Knowledge of databases and SQL language is essential to become a data scientist. The course provides knowledge of relational database concepts and practice of queries using SQL and Python. Students work with Pandas and Numpy to explore various types of data, clean up, and process missing data. You will learn how to represent data to gain a deeper understanding of the data and help make effective decisions.

LEARNING OUTCOMES

• Write basic SQL statements
• Know how to apply advanced query commands
• Use Python to access the database
• Know how to import and export data
• Understand how to do data preprocessing, handle missing data, standardize data – Performing and find correlation in the data
• Know how to represent data using the Matplotlib libraries
• Learn how to represent advanced data using the Seaborn and Folium libraries