Learn the fundamentals of SQL through interactive Jupyter Notebooks, discover basic and complex SQL functionalities, data manipulation, and overall data management tools & techniques.
If you’re looking to learn the foundations of SQL, this course is the ideal place to start. An individual subscription gives you 3 months’ online access to:
As Well As
Our Data Science Resource Library which features Actuartech and Industry specific curated additional content to assist you on your data science journey.
You can also request to do the online assignment for an additional fee; and if successful a course completion certificate could be issued.
“Foundations in SQL for Actuaries” introduces students to the data science pipeline whilst teaching them the fundamentals of the open-source querying language, SQL.
Throughout this course, students are exposed to data science topics such as data storage, data processing, and data manipulation, as well as ethical and wider business considerations when using data science in practice.
In this course, we consider various types of queries to build up from scratch. Each chapter has been formulated to deepen your knowledge as you progress and contains exercises to develop the practical know-how which will allow you to apply this course in practice.
Chapter 1 introduces Problem Specification, beginning with an overview of SQL. It highlights what SQL is and the different platforms on which you can use SQL. It also introduces students to the basic query clauses such as SELECT, FROM, and WHERE.
Chapter 2 covers Data Querying which addresses the different clauses and functionalities that can be placed within the query (e.g. GROUP BY and HAVING) to manipulate your search on your database, allowing you to retrieve the data you desire.
Chapter 3 on Database Management showcases how to write purpose-built queries to manage data, and how to transform and manipulate a dataset within your database by discussing queries such as UPDATE, INSERT, and DELETE.
In Chapter 4, Database Creation, we focus on creating our database from scratch. By building our tables and using the techniques discussed in Chapter 3, we show how to modify data within the newly created tables. Here, we show how to use the CREATE TABLE function and more.
Chapter 5 covers Advanced SQL in which we look at more complex operations that can take place within the SQL language and we present complex examples.
The Appendix contains additional reading and references to some of the basic concepts discussed, as well as an additional guide for SQLite and MySQL.
We have tailored packages available to ensure that corporate teams have the option to attend structured live lessons by our tutors, and the option to request a practical assignment and bespoke feedback. Invoicing option available.
