Imagine that you have a spreadsheet containing every data point about your customers — their preferences, their web browsing behavior, the products they’ve bought. What would you do with all that information? When you know SQL fundamentals, you can slice and dice that data any way you want, providing critical insights that drive business strategy.
SQL provides powerful-yet-simple tools for data analysis and handling. This SQL bootcamp will take absolute beginners through the basics to an ability to write queries with confidence. Get hands-on experience navigating a SQL server and distilling insights from real-world data. You’ll leave able to use this tool on your own data immediately.
Describe a relational database.
Illustrate the structure of a database using an entity relationship diagram.
Explore the anatomy of a SQL server.
Write queries to retrieve data from a SQL database (e.g., Microsoft SQL Server, etc.).
Sort and segment SQL query results to generate insights.
Combine data from multiple tables in complex queries.
This class is taken completely online via Zoom.
Class set up information will be emailed on the day of the class.
You will need access to a laptop or computer with a working webcam and microphone as well as a strong internet connection.
All communication will be sent to the email used to purchase a ticket. If you have signed up on behalf of a friend or colleague, please forward along this information.
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.