Skip to content
Ucanlyfor Education
Back to courses
IntermediateData Science8 weeks
Certificate IncludedCertificate EligibleUcanly certificate

Data Science: Intermediate

Go from analyst to data scientist: advanced SQL, experimentation, machine learning engineering, and Generative AI over your own business data.

Duration
8 weeks
Level
Intermediate
Content
47 lessons
8 modules · 15 h 11 min
Certificate
Included
On completion
Access
Fee by email
Or take the free aptitude test

What you'll learn

Handle advanced Pandas operations, time series data, and large datasets in reproducible pipelines
Write advanced analytical SQL using window functions, CTEs, and query optimization
Design and analyze rigorous experiments using confidence intervals, A/B testing, and causal inference
Engineer features and tune ensemble models like XGBoost and LightGBM for real world business data
Choose the right evaluation metric, prevent data leakage, and explain models with SHAP
Build time series forecasting, clustering, and recommendation systems
Build embeddings, vector search, and RAG systems over your own business data
Build text to SQL and AI agents that query, chart, and summarize data automatically
Ship an end to end data science product with an engineered pipeline, a tuned model, a live API, and an AI insight layer

Who this course is for

  • Beginner level graduates ready to move into professional data science roles
  • Data analysts who want structured, production level data science skills
  • Junior data scientists preparing for mid level interviews and case studies
  • Anyone who wants hands on experience building AI powered data products

Skills you'll gain

Data ScientistAdvanced SQLMachine LearningXGBoostLightGBMFeature EngineeringAB TestingCausal InferenceTime Series ForecastingClusteringSHAPMLflowFastAPIRAGText to SQLAI AgentsApplied Data Science

This course includes

Live mentor led Ucanly sessions plus self paced recorded content
Production style projects in every module
Ucanly portfolio review, mock technical and case study interviews, and a personalized roadmap to Advanced
Lifetime access to course materials and future updates
Certificate of Completion from Ucanly

Course content

8 modules · 47 lessons · 15 h 11 min

Advanced data wrangling and engineering, advanced SQL and analytical databases, statistical inference and experimentation, machine learning engineering, model evaluation and interpretation, specialized modelling in time series and unsupervised learning, Generative AI for data science, and a capstone end to end data science product.

Requirements

  • Completion of the Beginner level, or working knowledge of Python, Pandas, SQL, and basic statistics
  • A computer capable of running Python and common data science libraries
  • Comfort cleaning data and running a simple analysis or model

About this course

Level up from analyst to data scientist. This intermediate program from Ucanly takes practitioners with working knowledge of Python, Pandas, SQL, and basic statistics into professional data science: advanced Pandas and reproducible pipelines, analytical SQL with window functions and CTEs, rigorous A/B testing and causal inference, and machine learning engineering with XGBoost, LightGBM, and SHAP based interpretability. On the Generative AI side, you will build embeddings and vector search over business data, Retrieval Augmented Generation on your own reports, text to SQL natural language analytics, and AI agents that query and explain data automatically. You will graduate having shipped an end to end data science product with an engineered pipeline, a tuned model, a live API, and an AI powered insight layer.

Earn a Ucanly certificate

Complete this course to earn a Ucanly certificate with its own page and QR code. Save it as a PDF, share its link, or add it to the certifications on your LinkedIn profile.

Certificate IncludedCertificate EligibleUcanly certificate

Frequently asked questions

It is recommended, but working knowledge of Python, Pandas, SQL, and basic statistics is sufficient to start.

Yes, you will design and analyze a complete A/B test, covering sample size, power, confidence intervals, and causal inference fundamentals.

You will build embeddings and vector search over business data, RAG systems on your own reports, text to SQL natural language analytics, and AI agents that analyze and explain data.

An end to end data science product with an engineered pipeline, a tuned model, a live API, and an AI powered insight layer, mentored by Ucanly.