Looking to learn some basic SQL skills to filter, aggregate or produce reports from a database? Exporting data and using Excel instead of taking advantage of functionality your database already gives you? This class will give you the skills required to perform both basic and complex data manipulations with ease.
This class will introduce participants to SQL queries for data gathering and data analysis. We will cover enough query syntax and examples and hands on practice to get participants started on querying a database and performing common data analysis tasks that are transferable to their own needs.
This workshop is highly interactive with group activities and discussions throughout. To participate you will need to:
Have your camera turned on for the entire session
Have an accessible microphone
Be in a quiet, well-lit space with minimal distractions
Strong internet connection
Learn to write basic SQL queries to filter, aggregate and summarise data.
Know how to apply your new knowledge to many real life situations requiring SQL.
Understand underlying concepts through examples and hands on practice.
Have access to cloud based learning databases to support their learning after the workshop.
This is a beginner class assuming no previous SQL experience. This session is taken completely online using Zoom You will need access to a laptop or computer with a working webcam and microphone as well as a strong internet connection. . Download Zoom. Zoom is the video conferencing tool we will use. It works a lot like Google Hangouts or Skype. You will need to create an account in order to join the call. We will provide a link to the session via email 24 hours in advance - keep an eye on your inbox This session will not be recorded, however, slides will be shared following the class.
Wayne is a data analyst with Google’s Admob team, applying data science to drive developer acquisition at scale globally. Wayne is passionate about solving business problems using data and analytics techniques. He was previously with Unilever, where he was a pioneering member of the data science team there, developing analytics products for sales and finance teams across Southeast Asia. Wayne graduated from the National University of Singapore, majoring in Finance.
Out of office, you can find him in the gym, or tinkering with cryptocurrency-related side projects.
Your registration for or attendance at any General Assembly offering indicates your agreement to abide by this Community Code of Conduct policy and its terms.