Golang Series - Introduction to SQL | CHAPTER 2

Details

Do you want to learn how to use Go? Are you trying to get more into the back end world of web development?

SAVE YOUR SPOT HERE FOR FREE: https://www.eventbrite.com/e/91310860241

Find the previous documentation of the series here: https://github.com/myles-mcdonnell/intro-golang-microservices

💥About this Event
These series have been designed to give you an introduction to Go, as well as some of the most important topics to have in mind when working with Web APIs.

Go is an open-source project developed by a team at Google and many contributors from the open-source community.

During these 5 workshops, you will learn how to work with Golang, with an introduction to SQL, an introduction to docker and container orchestration as well as a workshop in Asynchronous Messaging and Event Streaming. For the final workshop, we will review everything and work altogether in a Web API.

- In this second event of the series we will:

Get a better understanding of how to work with SQL.

Agenda

18:15h - Doors Opening

18:30h - Workshop Starts

Theory:

What is relational data?
What is SQL?
What is ACID?
What is Referential integrity?
What is Domain integrity?
Normalisation and De-normalisation
The power and pain of indexes
SQL Vendors; Oracle, MS SQL, MySQL, Postgres...
19:00h Demos:

Creating a schema on a Postgres server
Atomic Upserts
Transactions
Applying locks; a look at dead-locks and live-locks
20:30h - QAs & networking

For more info about these series:

How this series work?
*These events have been organised as a series and therefore, we highly recommend attending to each of the workshops. However, if not possible, you can attend to any of the events separately, keeping in mind that previous knowledge have been taught and therefore, given as understood.*

To everyone that comes to the entire series, a certificate will be given at the final workshop regarding the knowledge and skills of these series.

What are the dates and times of the events?

Monday 17th of February (6:30PM - 8:30PM) Introduction to SQL
Monday 2nd of March (6:30PM - 8:30PM) Introduction to Docker and Container Orchestration
Monday 9th of March (6:30PM - 8:30PM) Asynchronous Messaging and Event Streaming.
Monday 18th of March (6:30PM - 8:30PM) Final Chapter Workshop - A Golang WEB API

Who are these events for?
If you have some experience in web development but have never worked or you have worked briefly with Go, these workshops will help you to get a better understanding of it. No specific prior knowledge is required but those with some prior experience coding in any language will be beneficial.

Although is highly recommendable, you do not need to bring your computer to attend these series.

The Speaker: Myles McDonnell

Experienced technologist and hands-on development team leader with over 20 years experience building large scale systems across investment banking, sports betting, retail and maritime shipping domains.

Ironhack Barcelona

Ironhack is one of the top-ranked Tech School offering 9-weeks intensive & immersive courses in Web Development, UX/UI Design and Data Analytics and with campuses located in Madrid, Barcelona, Miami, Paris, Mexico, Berlin, Amsterdam, Sao Paulo and Lisbon. Since 2013, Ironhack has graduated over +3000 students who are building their careers in companies like Google, Twitter and ProductHunt.

In 2019, we ranked 2nd in the SwithUp category for best coding bootcamp in Barcelona.