SQL Query and Capstone Project

Create compelling data visualization using SQL and Pandas.

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


  • Querying from SQL Databases

    Day 1

  • Database Joins and Conditional Statement

    Day 2

  • Learn-by-Building

    Day 3

  • Capstone Project: End to end data analysis (Day 1)

    Day 4

  • Capstone Project: End to end data analysis (Day 2)

    Day 5

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:

  • Cutting Edge Curriculum

    A hands-on coding bootcamp with the opportunity to work on real datasets donated by businesses and the public sector. Coursebooks (PDF/HTML files), data set for practice, reference notes, and working files (R Notebook or Jupyter Notebook) are accessible through our Learning Management System account.

  • Project-Oriented Learning

    Work with real-life cases and learn under the assistance of our qualified instructors throughout the 1-month course.

  • Certification of Completion

    Show current and prospective employers that you’ve completed the course with a signed certificate of completion.

  • Quality Learning Environment

    We pay meticulous attention to the logistical details of our workshops: quality audio and visual setups, comfortable sitting arrangements, small group size. Dinners are included for evening workshops.

  • Engaging Community

    Be a part of our data-passionate community with 5000+ members and 300+ alumni.


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.

Learn data analysis by building:

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.