SQL Query and Capstone Project

Create compelling data visualization using SQL and Pandas.

Python, SQL
Pre-Requisite:
- Data Wrangling and Visualization
Difficulty: Beginner
Associated Specializations:
- Data Analytics Specialization
Duration: 5 Days

Ad-Hoc Course Registration:

ON-SITE CLASS

Date: 23 – 27 November 2020
Time: 18.30 – 21.30
Venue: Menara Kadin Lantai 4, Jl. H. Rasuna Said, Jakarta Selatan
Investment: Rp. 6.500.000

ONLINE CLASS

Date: 23 – 27 November 2020
Time: 18.30 – 21.30
Investment: Rp. 3.250.000

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

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.

Ad-Hoc Course Registration:

ON-SITE CLASS

Date: 23 – 27 November 2020
Time: 18.30 – 21.30
Venue: Menara Kadin Lantai 4, Jl. H. Rasuna Said, Jakarta Selatan
Investment: Rp. 6.500.000

ONLINE CLASS

Date: 23 – 27 November 2020
Time: 18.30 – 21.30
Investment: Rp. 3.250.000

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.

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.

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.

ENROLL NOW

Get In Touch

PT. Algoritma Data Indonesia.
RDTX Square, 9th Floor. Setiabudi, DKI Jakarta 12930.
Office: 0816-692-471
Email: community@algorit.ma

Data Science School

For Corporates
For Individuals
Alumni
Testimonials

Company

About us
Contact us
Join Us
Blog
Press

SQL Query and Capstone Project

Ad-Hoc Course Registration:

Course details

Please bring along:

Schedule

Course Producer

Samuel Chan

5-Day Workshop Modules

Module 1: Working with SQL Database

Module 2: Graded Assignment

Module 3: Capstone Project

Ad-Hoc Course Registration:

Program Receivables:

Cutting Edge Curriculum

Project-Oriented Learning

Certification of Completion

Quality Learning Environment

Engaging Community

A STRUCTURED APPROACH TO LEARNING DATA ANALYSIS

Learn data analysis by building:

Hands-on Coding

Working through real-life examples

Demo and Presentation

Learn-by-building philosophy

Part of Data Analytics Specialization

Get In Touch

Data Science School

Company