SQL Bootcamp
29

Saturday, 29 June

10 am – 5 pm BST

GA London, The Relay Building

1st Floor, 114 Whitechapel High Street
London
£190 GBP
Regular Ticket
£190 GBP
Total

Questions? Read our FAQs

SQL Bootcamp

Joana Wang Photo


Data Engineer

29

Saturday, 29 June

10 am – 5 pm BST

GA London, The Relay Building

1st Floor, 114 Whitechapel High Street
London
£190 GBP
Regular Ticket
£190 GBP
Total

Questions? Read our FAQs

About This Workshop

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence.

Chart your own career path. Pick up where this workshop leaves off. Learn the fundamentals of data tools like Excel, SQL, and Tableau in 10 weeks in our part-time, on-campus Data Analytics workshop or online in our mentor-driven Data Analysis Circuit.

Participants must bring a laptop with http://sqlitebrowser.org/ (or their preferred DB browser) pre-installed.

Takeaways

  • Understand SQL vocabulary such as tables, schema, functions and JOINS
  • Understand the differences between different data management systems for SQL databases
  • Create basic SQL queries by applying Boolean logic, sorting functions, and commenting
  • Apply SQL aggregate functions [MIN, MAX, SUM, AVG, COUNT]
  • Use CAST to change a column’s type for a query
  • Use advanced SQL commands [OR, GROUP BY, HAVING] and conditional operators [ =,!=,>,<, IN, NOT IN, and BETWEEN] to filter data
  • Apply string, date, and math functions to manipulate how data is presented
  • Apply UNION to tables and columns for merging data
  • Use JOINS to create relationships between tables to obtain data

Preparation

Basic technical aptitude and orientation to computers, and curiosity to learn new tools. Willingness to learn about a text-based/principle driven analytic tool with little real GUI support, and determination to push through the natural frustration of confronting new concepts.

Participants must bring a laptop with http://sqlitebrowser.org/ (or their preferred DB browser) pre-installed.

About the Instructor

Joana Wang Photo

Data Engineer

Joana is a data aficionado with a passion for education. Her ambition is to help people demystify the world of data and make analytics second nature while having fun.

Having worked both in strategy consulting and industry, she's had projects across retail & wholesale, supply chain and financial services. In her last 8 years of experience, she's spent most of her time doing financial modelling, building bespoke data analytics products and wrangling data - a lot of it! This has required her to not only be able to technically develop solutions but also understand the wider business context and relate to people's needs, which she tries to embed in her teaching style.

She currently works as a Data Engineer in a fintech startup helping people lead better financial lives. When she's not knee deep in queries she is most likely on top of a mountain, on a yoga mat or flying a drone.

In recognition of her exemplary service in the classroom, Joana has been selected as a member of General Assembly's Distinguished Faculty program.

Refund Policy

We understand that, sometimes, plans change. If you can no longer make it to a class or workshop, please email us at least 7 days before the scheduled event date. No refunds will be given to cancellations made within a week of the class or workshop.

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.