Data Literacy and SQL
This course can be delivered to your organisation as part of our bespoke Corporate Training Solutions, at your own time and your own convenience. Contact us on kla@kpmg.com.mt or call us on +356 2563 6363 or on +356 9963 6363 for more information on how we can take care of your organisation’s training needs.
Course Description:
Our comprehensive Data Literacy and SQL training program welcomes participants to delve into the world of data-driven decision-making and gain the necessary skills to leverage the power of SQL effectively. In today’s data-driven business landscape, a strong foundation in data literacy is essential for making informed decisions, while practical expertise in SQL allows individuals to query data sources for self-service analytics and the automation of reporting processes.
Through hands-on exercises and projects, participants will acquire the technical proficiency needed to understand and create their own SQL queries with a view to analyse data and generate reports effectively. Participants will gain the ability to navigate datasets with confidence, clean and prepare data for analysis, and present data-driven insights in a compelling manner.
SQL is also presented within the context of the full analytics workflow, with consideration to BI integrations and an introduction to corporate data management fundamentals.
Target Audience:
The session is aimed for all professionals seeking to improve their data skills and/or seeking to automate any manually-intensive reporting process.
Learning Outcomes:
The course outline has been crafted to strike a balance between theoretical data literacy concepts and hands-on Power BI application, as follows:
Data Literacy:
- Understand data principles, analysis techniques, and effective data communication.
- Appreciate opportunties for data analytics to shape organisational success
SQL:
- Connect to Data Sources
- Transforming Data
- Analysing Data
- SQL Dialects
- Variable Declaration
- Partition/Window Functions
- Common Table Expressions (CTEs)
Venue: Kindly contact us on kla@kpmg.com.mt to indicate your preferred training method; online or in-person.
CPE Hours: This course qualifies for 8 hours of Structured CPE which can be classified as Professional Competency. A certificate of attendance will be provided at the end of the session.
Trainer:
Michele La Ferla, Senior Data Engineer, KPMG Digital Solutions
Michele is a data engineering manager at KPMG Malta. He joined the firm in 2021, bringing a diverse experience to the Data and Analytics team. Michele graduated from Middlesex University in 2016 and furthered his studies by following a Masters in Artificial Intelligence with the University of Malta, which he completed in 2023. Michele has worked on several engagements with previous companies ranging from working as a consultant in the Banking and Insurance sectors to experiencing hands-on development projects in .NET, Java and Android technologies. However, Michele’s preference has always been in the data engineering field, by gathering data from different sources; and extracting metrics which are relevant to the business from it.
Discover more courses from our KPMG Learning Suites.
Is your employer paying for your CPE seminars? Contact us on kla@kpmg.com.mt to discuss how the employer can benefit from our offers.
Course Features
- Guided Learning 8 hours
- Language English
- Assessments