If you are working in online business, SQL is a must.
If you want to:

  • extract better information from your or your company’s raw data by yourself, or
  • take your analytics skills from Google Analytics or Excel to the next level, or
  • start to steer your career path towards Data Science or Analytics, or
  • understand what data professionals are doing at your company…

…knowing SQL and being able to use it in practice is definitely an important step. This SQL for Data Analysis Workshop gives you practical and immediately applicable SQL knowledge in one day.

Who is this for?

The SQL for Data Analysis Workshop is designed for:

  • online business professionals
  • digital marketers (SEM, SEO, PPC, Social, etc.)
  • digital analysts (working in Google Analytics and/or in Excel)
  • UX professionals
  • anyone who wants to invest in her career by learning about coding, analytics and data science

If you’ve never touched a coding task, don’t worry: we will start from scratch.

Who has participated so far? Mostly professionals at smaller e-commerce and startup companies – but attendees from bigger companies like Booking.com, Audi, Butlers, Telenor, T-Mobile, iProspect, Heineken and Lego have also benefited.

sql_for_data_analysis_online_workshop

10% theory, 90% practice

This is a workshop that contains only the necessary amount of theory; all the rest is practice. Take your computer and prepare to get your hands dirty with actual data coding from the first moment on. We will tackle every topic together, and you’ll also get small, exciting assignments – with real data sets – to continuously test your freshly gained coding skills. The best way to learn is by practicing, right?

Details

Date: 12 September 2018, Wednesday, 10:00-16:00 (CEST timezone)

Location:  ONLINE (yes, you can join in from anywhere!)

Ticket: €120 + VAT / attendee

The max. number of attendees is 10.

Register now…

If you have any questions, send an e-mail to workshop@data36.com!

SQL for Data Analysis Workshop moments 2

Agenda of the SQL for Data Analysis Workshop

SQL for Data Analysis Workshop postgres logo1.) Introduction – Why is coding important? How does it work? Introducing the data coding environment of SQL – and comparing it to other languages (Python, R, bash etc…).

2.) SQL in practice.

  • Learning the basic SQL queries and clauses. (SELECT, FROM, LIMIT)
  • How to filter in SQL (WHERE, AND, OR, <, >, etc…)
  • SQL functions, aggregations, averages (SUM, MIN, MAX, AVG, etc…)
  • Segmentation using SQL
  • JOIN-ing tables

3.) WORKSHOP and practicing on a true-to-life startup’s true-to-life dataset.

Register now…

At the end of the course you will:

  • understand the basics of data + coding
  • have hands-on experience and solid base knowledge in SQL
  • gain enough knowledge to continue learning by yourself after the course
  • get free access to the “How to Set up your Own Data Server with Python, R, SQL and Bash” video course

Live Online Workshop? How does it work?

This is an online workshop. You can join in from anywhere: your company’s office in Iceland, your bedroom in Germany or the beach in Spain. Either way, make sure you have:

  • your computer with you
  • a strong internet connection
  • a peaceful environment around you (so the beach of Spain might not be the most ideal choice after all)
  • optionally, I’d also recommend an extra screen for the workshop (one screen for the video-stream, and another one where you can type in and try out the SQL queries you learn).

This a live workshop. I will present the learning materials and the tasks in real time. This is not a pre-recorded course, so you’ll have to actively participate during the whole day in order to get the most out of this one-day SQL Workshop. (Note: Unfortunately, I cannot create recordings of this event.)

This is an interactive workshop. Even though we will sit in different rooms in different cities, countries and maybe even continents, we will still keep this interactive! You can ask questions, you can get help from me if you get stuck, and you can get all the support you need throughout the whole day!

Register now…

Presenter

Tomi Mester is a data analyst and researcher. He worked for Prezi, iZettle and several smaller companies as an analyst/consultant. He’s the author of the Data36 blog where he writes posts and tutorials on a weekly basis about data science, AB-testing, online research and data coding. He’s an O’Reilly author and presenter at TEDxYouth, Barcelona E-commerce Summit and Data Conf. More info about Tomi: here (linkedin).

Register now!

Your Name:

Your Email:

Your Phone Number (optional):

I agree to Data36.com's Privacy Policy.
Short version: the information you provide here will be emailed to me (Tomi Mester) and I'll use it only to contact you regarding the workshop. No marketing emails, no newsletters, no ads, etc.

If you have any questions, send an e-mail to workshop@data36.com!