Intermediate SQL Bootcamp
29

Friday, 29 March

10 am – 5 pm GMT

GA London, The Relay Building

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

Questions? Read our FAQs

Intermediate SQL Bootcamp

Joana Wang Photo


Data Engineer

29

Friday, 29 March

10 am – 5 pm GMT

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

If you’ve got a base knowledge of SQL and are looking to expand your skills, this workshop will provide you with the opportunity to build upon what you already know. You’ll dive into more advanced SQL and focus on the creation of new structures, design principles, and developing skills that can be transferred into areas requiring SQL skills on a day to day basis. By the end of the workshop, you’ll be able to create data structures based on a brief and query the data using various techniques. Students will immediately be able to apply their skills at work.

Takeaways

  • Learn how to build on your SQL skills and gain a much firmer understanding of SQL
  • Go through hands-on exercises to reinforce topics and key concepts
  • Learn the different types of joins and unions
  • Build subqueries
  • Script window functions
  • Focus on best practices
  • Understand database design (STAR schema)
  • Build your own database, tables, inserting, updating and deleting data

Preparation

  • This is an intermediate level workshop, so a basic knowledge of SQL is assumed.
  • Students should already be comfortable with building queries that include SELECT, FROM, WHERE, GROUP BY, ORDER BY.
  • Please bring a laptop with postgreSQL pre-installed. You can download the required software (latest version) for free at https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

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.