Member Avatar for CaliGirl06

Hi guys,

I'm brand new to SQL and was looking for any help I can get my hands on! What resources does everyone find useful?? Books, magazines, links, forums, etc.??? My friend shared this one with me so I thought I'd pass it along, I've found it pretty informative and best of all, free! :mrgreen:

Thanks in advance for any help!!
- Lizzy

  • 3 Contributors
  • 3 Replies
  • 122 Views
  • 11 Months Discussion Span
  • Latest Post Latest Post by amper

Dani AI

Generated

This thread correctly points to community sites and example archives (credit to for starting the request and to and for sharing sites). To make the suggestions actionable today, separate learning into two tracks: core SQL (ANSI/standard SQL) and one DBMS-specific dialect and toolset (for example, T‑SQL for SQL Server or PL/pgSQL for PostgreSQL). Core concepts that transfer across systems include SELECT/WHERE, JOINs, GROUP BY/HAVING, subqueries, window functions, transactions, ACID, basic indexing and normalization.

A practical, bite-sized study plan produces faster results than reading alone: load a sample database (Northwind, Sakila, AdventureWorks or Chinook) and progress from simple selects to joins, aggregations, window functions and small schema changes. Regularly inspect execution plans (EXPLAIN / EXPLAIN ANALYZE) and use that feedback to learn indexing and query-shaping techniques. Small, testable example:

SELECT c.country,
       COUNT(o.order_id) AS orders_count,
       SUM(o.total_amount) AS total_sales
FROM customers c
JOIN orders o ON o.customer_id = c.customer_id
WHERE o.order_date >= '2020-01-01'
GROUP BY c.country
ORDER BY total_sales DESC;

Useful complements: authoritative documentation for the chosen DBMS, practice sites with interactive problems, and a short book that focuses on readable examples (titles widely recommended include "Learning SQL", "SQL Queries for Mere Mortals", "SQL Cookbook", and Ben Forta’s quick guides). Use local labs (SQLite or Dockerized instances) and GUI tools (SSMS, pgAdmin, MySQL Workbench, DBeaver) to run experiments. Caution: many older tutorials are tied to specific versions or dialect quirks—verify SQL dialect and version before applying advice from archived posts. The community links mentioned earlier remain valuable as discussion and example sources; pair them with hands‑on practice and official docs for best results.

Recommended Answers

All 3 Replies

Member Avatar for amper

This url changed to:

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.