Learn SQL for Beginners: Free Resources and a Plan for Jobs

To learn SQL for beginners, start with a free interactive site like SQLBolt or Khan Academy, learn about ten keywords in order (SELECT, FROM, WHERE, ORDER BY, LIMIT, COUNT and SUM, GROUP BY, HAVING, JOIN), and practice on a real dataset every day for about a month. That's enough for the SQL tests in most entry-level data analyst, QA and reporting interviews in the Philippines. You don't need to pay for a course or install anything on day one.

SQL (Structured Query Language) is how you ask a database questions. "How many orders did we get from Cebu last month?" becomes a short line of text the database can answer in a second. It's one of the most useful skills for career shifters because it shows up in data, QA, support, development and even some operations jobs.

Which IT jobs in the Philippines actually use SQL?

More than people expect. Search "SQL" on JobStreet or LinkedIn and filter by entry level, and you'll see it listed in posts for:

• Data analyst, reporting analyst, MIS associate: SQL is often the main tool, along with Excel or Google Sheets. See our data analyst guide for beginners.
• QA tester: checking that data saved correctly after a test, like "did this order actually land in the orders table?" Our QA tester guide covers that path.
• Application support and technical support (L2): looking up a customer's records to troubleshoot a ticket.
• Junior developer: almost every app stores data in a database.
• Workforce or BPO reporting teams: many already pull numbers from databases behind the dashboards.

If you're in a BPO reporting or workforce role and you already live in spreadsheets, SQL is the most natural next skill.

What SQL do employers actually test?

Entry-level SQL tests are usually short and practical. Expect to write queries like these against a simple table of orders, customers or employees:

• Show all orders above a certain amount (WHERE).
• Count orders per city or per month (GROUP BY with COUNT or SUM).
• Find the top 5 customers by total spending (GROUP BY, ORDER BY, LIMIT).
• List customers who have never ordered (LEFT JOIN with IS NULL).
• Find duplicate email addresses (GROUP BY with HAVING COUNT > 1).
• Explain the difference between WHERE and HAVING.

That's it for most entry roles. Window functions, subqueries and query optimization come later, usually after you're hired.

A sample query you should be able to read

Imagine a milk tea shop with branches in Quezon City, Makati and Cebu. It has an orders table with columns order_id, branch, amount and order_date. Here's a query that answers "Which branches made the most sales in October?":

SELECT branch, COUNT(*) AS orders, SUM(amount) AS total_sales
FROM orders
WHERE order_date >= '2026-10-01' AND order_date < '2026-11-01'
GROUP BY branch
ORDER BY total_sales DESC;

And the result looks something like this (made-up practice data):

branch        | orders | total_sales
Makati        | 412    | 61800
Quezon City   | 388    | 55200
Cebu          | 301    | 44100

Read it line by line: pick the branch, count its orders and add up the amounts, only for October, group the rows by branch, sort from highest sales. If you can explain a query like this in plain words, you're ahead of many applicants who memorized syntax without understanding it.

The best free places to learn SQL

You can learn everything an entry-level interview needs for free. Here are the resources I'd actually recommend, in the order I'd use them:

• SQLBolt: short interactive lessons right in your browser, no install. The best first step.
• Khan Academy, Intro to SQL: gentle video plus practice, good if you like being walked through.
• Kaggle Learn, Intro to SQL: free micro-course that uses Google BigQuery on real public datasets.
• freeCodeCamp: the Relational Database curriculum goes deeper, with PostgreSQL and the command line.
• W3Schools SQL tutorial: handy as a quick reference when you forget syntax.
• Google BigQuery sandbox: lets you query large public datasets free within its limits, without a credit card.
• DB Browser for SQLite: a free desktop app to make your own small database from a CSV file.

More free options are in our list of free IT courses with certificates.

How to learn SQL for beginners: a 30-day plan for jobs

About 30 to 45 minutes a day, which fits before or after a shift.

1. Days 1 to 5: SQLBolt lessons on SELECT, WHERE, ORDER BY and LIMIT. Redo any exercise you got wrong the next day.
2. Days 6 to 10: aggregates. COUNT, SUM, AVG, MIN, MAX, then GROUP BY and HAVING. This is the heart of reporting work.
3. Days 11 to 15: JOINs. INNER JOIN first, then LEFT JOIN. Draw the two tables on paper and match rows by hand once. It clicks faster.
4. Days 16 to 20: download a public dataset (Kaggle, data.gov.ph, or the Philippine Statistics Authority site) and load it into DB Browser for SQLite or BigQuery. Ask it ten questions.
5. Days 21 to 25: timed practice. Give yourself 15 minutes per question for the six test types listed above.
6. Days 26 to 30: build your portfolio project and write it up.

Turn your SQL practice into a portfolio project

A finished, explained project beats ten certificates of completion. Keep it small:

1. Pick a dataset with at least a few thousand rows, ideally something Filipino recruiters will relate to (sales, weather, public transport, government open data).
2. Write five to eight business questions, like "Which month had the highest sales?" or "Which city has the most repeat customers?"
3. Answer each with a query. Save the SQL in a file or a GitHub repo.
4. Put the results in a simple Google Sheets or Looker Studio chart.
5. Write three insights in plain words, the way you'd explain them to a manager who doesn't read SQL.

Resume line, weak: "Knowledgeable in SQL."

Better: "Analyzed 12,000 rows of public sales data in SQLite: wrote 8 queries using JOIN, GROUP BY and HAVING to find top products and repeat customers, and presented 3 findings in a Looker Studio dashboard."

You can do all this alone. What a coach adds is the second pair of eyes: is the project scoped right, do the insights make sense, does the resume line hold up? In the Career Shifter Track, you build that project in week 4 and submit it, and a coach writes feedback before it goes on your resume and LinkedIn. Week 1 also has a role picker, so you know whether data is really the right fit before you invest months. You can try a few lessons in the free Career Shifter preview.

Mistakes beginners make with SQL

• Watching tutorials without typing. SQL is learned by writing queries and getting errors.
• Jumping between five courses. Finish SQLBolt first. Then move on.
• Skipping JOINs because they're confusing. They're on almost every test.
• *Using SELECT everywhere.** Name your columns. It shows you know what you're asking for.
• Not checking results. If a total looks too big, you probably joined wrong and duplicated rows. Count rows before and after a JOIN.

Want a role picker and a 60-day study plan in one place? Get the free IT Job Starter Kit.

Frequently asked questions

How long does it take to learn SQL for a job?

For the basics most entry-level tests cover, about a month of daily practice is realistic for many beginners. Getting comfortable with JOINs and messy real data usually takes longer, and that keeps improving on the job.

Can I learn SQL for free?

Yes. SQLBolt, Khan Academy, Kaggle Learn and freeCodeCamp all teach SQL for free, and tools like DB Browser for SQLite and the BigQuery sandbox let you practice on real data without paying.

Is SQL hard to learn for non-IT people?

SQL is one of the easier technical skills to start with because it reads close to English. If you're comfortable with Excel filters and pivot tables, you already understand most of the ideas behind SELECT, WHERE and GROUP BY.

Which SQL should I learn: MySQL, PostgreSQL or SQL Server?

Start with standard SQL on any of them; the basics are almost identical. Later, check job posts in your target companies and learn the small differences of whichever database they mention most.

Do I need SQL to become a data analyst in the Philippines?

Most data analyst posts list SQL alongside Excel or Google Sheets, so it's strongly recommended. Some reporting roles start with spreadsheets only, but SQL widens your options a lot.