What will we cover?
This will be an introduction to SQL course. The course assumes no prior knowledge of SQL (or even coding), although some experience of working with data in excel or similar is advisable.
We will start from the beginning and look at why have a database in the first place. How to retrieve data from a table, how to filter and sort, to to aggregate data (sum, min, max, avg), how to join data from multiple tables and how to insert new data.
A sample database will be supplied – this will be based on football data, but it’s not a football course, so even a basic understanding of the sport is sufficient.
At the end of the course you should have a solid understanding of the importance and advantages of a database over file based systems like excel. You will be able to query, filter and retrieve data.
Who should attend?
If you have an interest in learning a new skill. Work with data but currently manage everything in excel and want to understand more about what best practice looks like. Although SQL is a coding language it is one of the simpler one’s to learn. So even if you have no prior coding experience you shouldn’t be put off by learning SQL.
When is it on?
The course will run for 4 weeks, starting on Thursday 7th and each Thursday for 4 weeks in total. Class will run from 8pm – 9pm (CET). The classes will not be recorded so attendance is required at the specified times. For those interested I ask that you are available for at least 3 out of the 4 sessions.
What will it cost?
€19.99 – You will also get free access to the online course when it is launched. All other software you need is free and sample data will be provided.