Final-year students
Placement season is close and your resume still has no project on it.
Finish with three pieces of work you can demo in an interview.
Data
Data Analytics with SQL & Excel
Take a messy spreadsheet or database export, clean it, answer a business question with a query, and present the answer — in eight weeks.
- 8 weeksEstimated time
- 5Modules
- 15Lessons
- 3Projects
- YesCertificate
- FreePrice
No credit card. No sign-up required to preview. See the full syllabus
Who this course is for
Three people take this course. The work is the same; the reason is different.
Fresh graduates
You have the degree, but the job ads ask for proof of skill.
Build a portfolio before the next hiring round, not after it.
Career switchers
You are experienced elsewhere, new to this field, and starting from zero.
Learn the vocabulary and ship one published project that proves the switch.
Proof, not notes
What you will build
Every module ends in something finished. These are the pieces you leave with.
What changes
What you will be able to do
Not definitions to recite — tasks you can open a laptop and complete.
Roles this supports Data analyst / business analyst (fresher) · MIS executive and reporting roles · Operations roles with a data component
- Clean a real dataset in Excel: duplicates, blanks, inconsistent formats and text-vs-number traps
- Build pivot tables and lookups that answer a question without rewriting the sheet every month
- Write SELECT, WHERE, GROUP BY, ORDER BY and JOIN queries from memory, not by copying
- Turn a vague request — "why did sales drop?" — into a precise query you can actually run
- Design one dashboard that a manager reads in thirty seconds
- Explain your numbers out loud: definitions, exclusions and the reason the number moved
The syllabus
Course curriculum
5 modules · 15 lessons. Open a module to see its outcome and lesson titles.
Module 1 Excel that does not fall apart The tool you will be judged on in your first job, used properly rather than by hand.
- 01 Structure before formulas Free preview
- 02 Lookup and conditionals
- 03 Pivot tables and charts
Deliverable 3 practice tasks, one per lesson
Module 2 SQL — asking the database directly The skill in every analytics job description, and the one that separates a candidate from the spreadsheet crowd.
Deliverable 3 practice tasks, one per lesson
Module 3 From question to insight The part that separates an analyst from someone who can type a query. A manager asks for a number; you hand back the answer and the reason.
- 07 Turning a vague request into a runnable question
- 08 Sanity-checking your own numbers
- 09 One dashboard, thirty seconds
Deliverable 3 practice tasks, one per lesson
Module 4 Dates, windows and time The date handling and window functions that separate a spreadsheet export from real analysis.
- 10 Dates and time in SQL
- 11 Window functions: rank without collapsing rows
- 12 Pivot a table in SQL with CASE
Deliverable 3 practice tasks, one per lesson
Module 5 From query to a defensible answer Read the schema, check the data, and end every analysis with a sentence a manager can repeat.
- 13 Reading a schema before you write a query
- 14 Data quality checks you run every time
- 15 Answering with a recommendation, not a chart
Deliverable 3 practice tasks, one per lesson
Lesson explanations, worked examples and practice tasks are in the learning player, not on this page — so you can read the syllabus without scrolling through the whole course.
How the course works
Every lesson follows the same four steps. No passive video playlists.
- 1
Learn the concept
A short explanation in plain English, with the one idea the lesson depends on.
- 2
See a worked example
The same task done end to end, with the reasoning behind each step.
- 3
Complete the practice task
You write it yourself. The task is the lesson; the reading is only the setup.
- 4
Build and publish a project
Each module ends in work you can open, explain and attach to an application.
Way2Fresher Academy
Courses written for the fresher hiring market — not translated from a bootcamp built for another country.
- Plain English Every explanation is written to be read once, slowly, by someone new to the field.
- Project-first A practice task in every lesson and a project at the end of every module.
- No paywall The full syllabus, all lessons and the certificate are free. Nothing is held back for a paid tier.
4.7Average rating
5,300Learners
3Portfolio projects
15Lessons
The work is the proof
A fresher interview cannot assess a certificate. It can assess a project you can open, explain and change on the spot — which is why every course here ends in one.
- A finished project brief with an evaluation checklist
- A shareable repository, dashboard or case study
- A certificate that records the work, once every lesson is done
Frequently asked questions
The answers that decide whether this is the right six weeks.
Is the course really free?
Yes. Every lesson, practice task and project brief on this page is free to read, and no card is required. A free account only saves your progress and unlocks the certificate.
Do I need coding experience?
No. This course is written for beginner learners and every lesson starts from the tool itself. If you can use a browser and a file, you can start lesson one today.
How long will it take?
About 8 weeks. The course holds 15 lessons, each built around one practice task, so the calendar depends on how many sessions you can keep each week.
Will I get a certificate?
Yes. Finish every lesson while signed in and a certificate with your name, the course, the date and the skills covered unlocks on this site. It is a record of work completed here, not an accredited qualification.
What should I learn next?
The next course in this route is Interview DSA Crash Course. Finish its first module before applying, so your portfolio shows a direction rather than a list of starts.
Start this course free.
No credit card. No sign-up required to preview. Lesson one is open now.
Data Analytics with SQL & Excel
Start Course Free