Data Analysis with Python and SQL

📍 Instructor: Emmanuel Nwambuonwo
📅 Duration: 12 weeks of learning + 4 weeks of hands-on projects
💰 Price: ₦250,000

Course Breakdown

📌 Weeks 1-4: Data Analytics and Machine Learning

Tools: Python, Excel, Power BI, ChatGPT/Gemini

  • Introduction to Python programming
  • Fundamentals of data mining
  • Data collection, cleaning, and transformation using Excel & Python
  • Exploratory Data Analysis (EDA) & visualization
  • Regression analysis (Linear & Multiple)
  • Classification models (Logistic Regression, Decision Trees, etc.)
  • Clustering techniques (K-Means, DBSCAN, etc.)
  • Neural Networks & Deep Learning basics
  • Time series forecasting
  • Data interpretation & communication using Python, Power BI, and Excel
  • Natural Language Processing (NLP) fundamentals
  • Data Governance principles
  • AI applications in data analytics with ChatGPT & Gemini

📌 Weeks 5-8: Applied Statistics and Data Visualization

Tools: R, Python, Power BI

  • Descriptive statistics (Measures of central tendency, variance, etc.)
  • Probability rules & statistical distributions
  • Hypothesis testing (T-tests, ANOVA, Chi-square, etc.)
  • Advanced time series analysis
  • Introduction to data visualization principles
  • Effective Power BI dashboard design
  • Data storytelling techniques for impactful presentations

📌 Weeks 9-12: Databases & SQL for Data Analytics

Tools: SQL Server Management Studio (SSMS), SQL

  • Introduction to relational databases
  • Writing SQL queries for data retrieval
  • SQL functions and operations
  • Joins and subqueries for complex queries
  • Creating and managing databases
  • Database design and normalization techniques
  • Database recovery and security best practices

📌 Weeks 13-16: Hands-on Capstone Project

  • Working with a real-world dataset
  • Applying Python, SQL, Power BI, and statistical methods to analyze data
  • Designing an interactive dashboard for insights
  • Presenting findings using data storytelling techniques

Certification

  • Participants receive a Data Analysis & SQL Certificate issued by CTA Academy & Data Science Experts.
  • Includes a unique serial number for online verification.

Start mastering new tech skills today with expert guidance available.

enroll today