Data Analysis (Python & SQL) Diploma

About Course

This intensive diploma equips you with the essential skills and knowledge to excel as a data analyst using Python and SQL. Through hands-on exercises, real-world projects, and a dedicated internship month, you’ll learn to collect, clean, analyse, and visualise data to extract meaningful insights and drive informed decision-making.

SQL for Data Analysis: Master the essentials of SQL, including database fundamentals, querying, data manipulation, and advanced concepts like joins, subqueries, and stored procedures.
Python for Data Analysis: Learn to use Python for data analysis, covering data manipulation with Pandas, numerical analysis with NumPy, and data visualisation with Matplotlib and Seaborn.
Statistics Fundamentals: Gain a solid understanding of statistical concepts, including mean, median, mode, data distributions, visualisation techniques, and correlation and regression.
Web Scraping: Learn techniques to extract data from websites using BeautifulSoup and Selenium for web scraping.
Internship Experience: Apply your skills in a real-world setting during a dedicated internship month, working on project-based tasks and gaining valuable practical experience.

Course Curriculum

SQL for Data Analysis

module 1 MySQL Training Key Concepts
module 2 Advanced MySQL Integration and Data Visualization
module 3 Real-world Data Analysis Projects

Python for Data Analysis

Getting Started with Python
Variables , Strings , Arithmetic Operations , Comparison Operations , Identity Operations , Assignment Operations , Membership operations , List
• If statement • Data structure • TUPLE • SET • DICTIONARY • loop
Seaborn
Advanced Seaborn Techniques
Matplotlib
Advanced Matplotlib Techniques
NumPy
Introduction to Data Visualization
INTRODUCTION TO PLOTLY
Pandas

Web Scraping

Workshop

A course by

LIA Team

Total Diploma Duration: 80 Hours

This outline provides a general framework. The specific content and arrangement may be adjusted based on the chosen curriculum and learning objectives.

Enroll in the Data Analysis (Python & SQL) Diploma and unlock the power of data!

Contact us today to learn more and secure your place.

All Levels

Data Analytics Diploma

Intermediate