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 from a database.
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.
How Long Does it Take?
The course has a series of short videos covering the key concepts of SQL. Each video contains sample questions for you to test your own knowledge.
What will it cost?
Free: The course is provided free of charge – If you find it of value you can buy me a beer.