How to Learn SQL Online and Get Hired as a Data Analyst

SQL is the single most requested skill in data analyst job postings. You can learn Tableau on the job and pick up Python later, but you cannot get hired as a data analyst without proving you can write queries competently.

Before mapping out your learning path, here is what you are working toward:

Data Analyst Salary Breakdown by Experience

Data analyst salaries in the United States vary based on experience and career stage. At the entry level, typically between 0 and 2 years of experience, data analysts earn an average salary ranging from $58,000 to $75,000 per year. As professionals gain more experience and move into mid-level roles (around 2 to 5 years), their earnings increase to approximately $80,000 to $105,000 annually.

With over 5 years of experience, senior data analysts can expect to earn between $110,000 and $140,000 per year, reflecting their deeper expertise and greater responsibility. Those who advance into leadership positions, such as analytics managers or team leads, often command even higher salaries, typically ranging from $130,000 to $165,000 or more annually.

The path from SQL beginner to employed data analyst is straightforward if you follow a structured approach and build proof of skill that employers can verify. Here is exactly how to do it.

Stage 1: Start Writing SQL From Day One

Skip the Passive Video Learning

Most beginners default to watching long YouTube playlists about SQL. That is passive learning, and it does not build the skill employers test for. You need to write queries from day one.

The following free platforms put you inside an interactive SQL environment immediately, with no setup required:

Mode Analytics SQL Tutorial 

Price: Free

Mode's tutorial is browser-based, meaning you write and run real queries against actual data without installing anything locally. It covers SELECT, WHERE, GROUP BY, JOIN, aggregate functions, subqueries, and window functions in a logical progression.

What it does well: You are querying real data from the first lesson. The interface is clean, the explanations are clear, and the difficulty ramps up naturally. This is the closest free resource to the actual experience of writing SQL in a professional environment.

The later sections on window functions move quickly. Slow down there and practice each function separately before moving on.

SQLZoo — Interactive SQL Practice 

Price: Free

SQLZoo offers structured exercises that increase in complexity progressively. It covers SELECT basics, joins, aggregation, subqueries, and window functions through hands-on problems rather than lectures.

What it does well: Immediate feedback on every query. The problem sets are well-designed for building SQL muscle memory, which matters more at this stage than theory.

The interface feels dated, but the content is solid. Use it alongside Mode rather than as a standalone resource.

W3Schools SQL Tutorial 

Price: Free

W3Schools covers SQL syntax clearly with a built-in editor for testing queries. It is less structured than Mode or SQLZoo as a learning path, but it is the fastest reference resource when you encounter a command you have not used before.

What it does well: Clear syntax examples, easy to search, and reliable for quick reference throughout your learning journey.

Stage 2: Take a Structured SQL Course

Build a Foundation Employers Recognize

Free interactive platforms teach you to write queries. A structured course gives you the organized foundation and verifiable credential that signals commitment to hiring managers. The following options are the most practical for aspiring data analysts:

SQL for Data Science — UC Davis (Coursera) 

Price: Free to audit; $49 for the certificate 

Time commitment: Approximately 13 hours across 4 weeks

This course covers SELECT statements, filtering, joining tables, aggregating data, and working with text and date functions — all within the context of data analysis work rather than database administration. It is taught by University of California Davis faculty and is consistently rated among the clearest SQL introductions available on Coursera.

What it does well: Patient pacing, real-world framing, and a certificate from a recognized university that carries weight on a resume.

The course does not cover window functions or CTEs at meaningful depth. Treat it as your foundation, then supplement with Mode's tutorial for those topics.

SQL Fundamentals Track — DataCamp 

Price: $14–$25/month depending on plan (approximately $300/year billed annually); limited free tier available 

Time commitment: Approximately 24 hours across the track

DataCamp's SQL Fundamentals track covers introductory SQL through intermediate topics including joins, subqueries, and window functions across four sequential courses. The format is short, focused modules with in-browser coding exercises rather than long lectures.

What it does well: Hands-on exercises after every concept, skill assessments that identify your actual gaps, and a clear progression from beginner to intermediate. The data analyst-specific framing keeps examples relevant to the work you will actually do.

Monthly pricing adds up if you do not pace yourself. Set a target completion date before subscribing. The guided exercises are helpful but can feel too structured — supplement with independent practice on real datasets.

The Complete SQL Bootcamp — Udemy (Jose Portilla) 

Price: $15–$20 on sale (Udemy discounts frequently) 

Time commitment: Approximately 9 hours

This is one of the highest-rated SQL courses on Udemy and covers PostgreSQL specifically, which is widely used in data analyst roles. It moves from basic SELECT statements through joins, aggregations, subqueries, and creating tables.

What it does well: Clear instruction, practical exercises, and a one-time payment rather than a monthly subscription. PostgreSQL is the right database to learn for data analyst work.

The course covers core SQL well but does not go deep on window functions or CTEs. Use the Advanced SQL sections of Mode or DataCamp to fill those gaps after completing this course.

Stage 3: Master the SQL Concepts Employers Actually Test

What Appears in Entry-Level Data Analyst Interviews

Entry-level data analyst interviews focus on a specific subset of SQL. Mastering these gets you through the majority of technical screens:

SELECT, WHERE, ORDER BY — filtering and sorting data

JOIN — inner, left, right, and full outer joins

GROUP BY and HAVING — aggregating data and filtering grouped results

Aggregate functions — COUNT, SUM, AVG, MAX, MIN

Subqueries — nesting queries inside other queries

Window functions — ROW_NUMBER, RANK, LAG, LEAD, running totals

Understanding Joins Specifically

Joins trip up more SQL beginners than any other concept. Here is the distinction that matters:

INNER JOIN returns only rows where there is a match in both tables

LEFT JOIN returns all rows from the left table, plus matched rows from the right

RIGHT JOIN returns all rows from the right table, plus matched rows from the left

FULL OUTER JOIN returns everything from both tables

Employers will ask you to explain joins in interviews. They can tell immediately whether you memorized a definition or actually understand how result sets change depending on the join type. Practice writing each type and comparing the output side by side until the difference is intuitive.

Window Functions — The Skill That Separates Candidates

Window functions perform calculations across a set of rows related to the current row without collapsing the result like GROUP BY does. ROW_NUMBER, RANK, LAG, and LEAD appear regularly in intermediate and senior-level SQL interviews, but knowing them at the entry level immediately sets you apart.

Mode Analytics SQL Tutorial covers window functions clearly in its advanced section. DataCamp also has a dedicated window functions course within the SQL track.

Stage 4: Practice on Real Datasets and Interview Platforms

Solve Problems That Mirror Real Interviews

LeetCode — SQL Problem Set 

Price: Free for most problems; LeetCode Premium is $35/month or $159/year for full access 

Recommended target: 50 problems before applying

LeetCode's SQL section contains problems ranked by difficulty from easy through hard. Easy problems cover basic SELECT and JOIN queries. Medium problems involve window functions, subqueries, and multi-step logic. Many companies pull interview questions directly from this platform.

What it does well: The most accurate representation of what live SQL assessments look like. Solving problems here directly translates to interview performance.

Start with easy problems and only move to medium once you can solve easy problems consistently without hints. Rushing to harder problems before the basics are solid builds bad habits.

HackerRank — SQL Challenges 

Price: Free

HackerRank's SQL section covers basic through advanced challenges and provides a certificate upon completion of each difficulty tier. Some employers use HackerRank as their technical screening platform directly, so practicing here familiarizes you with the exact interface you may encounter in applications.

What it does well: The tiered certificate structure gives you something to link to on LinkedIn while you build toward a full portfolio.

Kaggle — Real Dataset Practice 

Price: Free

Kaggle hosts hundreds of free datasets covering sales, customer records, e-commerce transactions, and more. Download a dataset, load it into a local PostgreSQL instance, and write queries to answer real business questions: total revenue by month, customer churn rate, top-performing product categories.

This practice is different from LeetCode in an important way. LeetCode teaches you to solve structured problems. Kaggle teaches you to ask your own questions and find answers, which is what data analyst work actually looks like.

Stage 5: Set Up a Local Database Environment

PostgreSQL Is the Right Choice

Setting up a local database environment moves you from querying pre-built tables to managing real data yourself. PostgreSQL is the most widely used open-source database in data analyst roles and is free to download and run locally.

What to do:

1. Install PostgreSQL from postgresql.org
2. Install pgAdmin (free GUI for managing PostgreSQL) from pgadmin.org
3. Download a Kaggle dataset in CSV format
4. Import it into a new database using pgAdmin
5. Write queries to explore and analyze the data

This workflow directly mirrors how data analysts work with databases in real roles. The ability to describe this setup in an interview — and show the results in your portfolio — signals genuine hands-on experience.

Stage 6: Build a SQL Portfolio

Your Resume Says You Know SQL. Your Portfolio Proves It.

Most data analyst candidates list SQL on their resume. Far fewer have documented, public evidence of what they can actually do with it. A portfolio immediately differentiates you.

Three projects to build:

1. Exploratory Data Analysis in SQL

Pick a sales or e-commerce dataset from Kaggle. Write queries that answer business questions: Which product categories generate the most revenue? What is the month-over-month growth rate? Which customer segments have the highest average order value? Document your queries and findings in a clean GitHub README.

2. Window Function Analysis

Take any dataset with a time dimension and use window functions to calculate running totals, rank items within categories, or compare current values to prior period values using LAG. This demonstrates intermediate SQL competency in a concrete, visible way.

3. Multi-Table Join Analysis

Find or create a dataset with multiple related tables and write queries that join them to answer a question that requires combining information across tables. Document the schema, your queries, and the business insight you extracted.

Host everything on GitHub with clear README files explaining what you built, what questions you asked, and what you found. This is what employers look at before inviting you to interview.

Stage 7: Learn Basic Data Visualization to Complement SQL

SQL Gets You the Data. Visualization Communicates the Insight.

You do not need to master Tableau or Power BI before applying for entry-level roles, but you should be able to create clean, readable charts that bring your SQL findings to life.

Google Looker Studio (formerly Data Studio) 

Price: Free

Looker Studio connects directly to databases and spreadsheets and lets you build dashboards without any paid software. It is widely used in smaller companies and startups, and knowing it adds a practical tool to your resume at zero cost.

Tableau Public

Price: Free (Tableau Desktop licenses start at $75/month)

Tableau Public lets you build and publish interactive dashboards at no cost. It is the most widely used visualization tool in enterprise data analyst roles.

Building one or two dashboards that visualize your SQL analysis results and hosting them on Tableau Public adds significant credibility to your portfolio.

Stage 8: Apply Strategically

Search for the Right Titles

Searching for "Data Analyst" generically returns roles requiring three to five years of experience. Filter specifically for:

Junior Data Analyst

Associate Data Analyst

Entry-Level Data Analyst

Reporting Analyst

Business Intelligence Analyst (entry-level)

These roles expect SQL competency but are far more forgiving about gaps in Python, machine learning, or advanced statistics.

Prepare for Live SQL Assessments

Most data analyst interviews include a timed SQL assessment. You will be given a schema and 30 to 45 minutes to write a query answering a business question. Practice this exact scenario using a timer.

Pramp offers free peer-to-peer mock technical interviews where you practice SQL problems live with another candidate. This is the closest simulation of real interview pressure available for free.

Interviewing.io offers free anonymous mock interviews with engineers from major tech companies, including data-focused roles.