SQL Query and Capstone Project
Create compelling data visualization using SQL and Pandas.
Querying from SQL Databases
Day 1
Course details
This 15-hour course guides student in using Python’s grammar of graphic for data visualization. We will also cover important data analytics stack: SQL and how to integrate it to Python. Upon completion of this course, students will be able to gain proficiency for an end to end process for data analysis using Python.
Please bring along:
- 1x Laptop
- Purchased ticket
Schedule
Course Producer
Samuel Chan
Machine learning practitioner in the field of marketing automation, fraud detection, finance and e-commerce. Samuel is Indonesia’s top-ranked Stack Overflow user in R (top 5% worldwide), a certified professional (certificates from Microsoft, MongoDB, Stanford University, John Hopkins University), and an experienced consultant that has worked with several public-trading companies from his time staying in China, Japan and Singapore.
Between 2017 and 2018, Samuel has trained and consulted with more than 20 companies around Indonesia and a regular guest speaker/trainer in a number of universities in Singapore and Indonesia. He is also among the first recipients of Microsoft Professional Program Certificate in Data Science in Southeast Asia, having demonstrated proficiency in R, Python, Microsoft Azure, SQL / T-SQL, PowerBI and a list of other technologies.
5-Day Workshop Modules
Syllabus: SQL Query and Capstone Project
Module 1: Working with SQL Database
- Grammar of Graphics
- Creating Database Connection
- SQL Basic Queries
- SQL Joins and Conditional Statements
Module 2: Graded Assignment
Use a music store’s operations database to query all sales relating to particular artists or albums. Using the relational schema of the database, we will learn how to query invoice data from the database in order to analyze the store’s top valuable customers. We will also apply the visualization techniques we have learned to produce an accompanying chart for the analysis.
Module 3: Capstone Project
After understanding the importance of data analysis and master its processing steps, we will model an end-to-end data analysis process, from upstream to downstream. Students can choose one amongst four provided skeletons as their final data analysis product; from creating an automated generated email with fire, a simple web analytics dashboard with Flask, a simple API from Heroku Server, or web scraping with Beautiful Soup.
Program Receivables:
A STRUCTURED APPROACH TO LEARNING DATA ANALYSIS
The Data Analytics Specialization is a 4-week bundle that is curated to accelerate a student’s mastery in building data products, develop a web application, and data visualization.
Students are not assumed to have a working knowledge of Python or prior proficiency in statistics/mathematics/algebra. As such the workshop follows a gentle learning curve and emphasizes hands-on, one-to-one tutoring from our team of instructors and teaching assistants.
Students work through tons of real-life examples using sample datasets donated by our team of mentors and corporate partners. We believe in a learn-by-building approach, and we employ instructors who are uncompromisingly passionate about your growth and education.
Part of Data Analytics Specialization
This course is part of the Algoritma Data Analytics Specialization. Participants are rewarded with a certificate of completion upon passing criteria.
