Member Avatar for superjj

hoi

I would like to learn how to work with databases.
does anyone know a good tutorials or sites?
because at this moment I know nothing about it.

thanks in advance

  • 2 Contributors
  • 2 Replies
  • 362 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by superjj

Dani AI

Generated

For , starting from zero is normal — a short, focused path plus hands-on practice (as suggested) is the fastest way to get useful skills. The checklist below compresses the topics, low-friction practice options, and common traps that beginners run into.

  • Environment: begin with a low-friction option (a single-file engine or an online SQL sandbox) for experiments; move to a server-based RDBMS when multiuser features are needed.
  • SQL fundamentals: CRUD (SELECT, INSERT, UPDATE, DELETE), WHERE filters, ORDER BY, JOINs (inner/left/right), GROUP BY/HAVING, and basic subqueries.
  • Schema design: primary and foreign keys, normalization (up to 3NF), sensible data types, constraints, and when to add indexes.
  • Operations: transactions (BEGIN/COMMIT/ROLLBACK), simple backup/restore, user permissions, and basic query performance awareness.
  • Apply: load a sample dataset and build a tiny project (address book, inventory, or blog) and drive it from a small script or app using parameterized queries.

A short, practical example of a common pattern (aggregate per customer):

SELECT c.name, SUM(o.total) AS total_spent
FROM customers c
JOIN orders o ON o.customer_id = c.id
GROUP BY c.name
ORDER BY total_spent DESC;

Working with sample databases and a GUI/browser tool makes learning faster. Common beginner pitfalls include missing primary keys, overusing SELECT *, storing numeric values as text, forgetting to commit transactions, and building SQL by string concatenation (risk of injection). Short projects that force schema design and reporting queries give the most durable learning gains.

Member Avatar for vadriaan

Best is to try for hands-on experience. Down load and install MySQL, then you have all the resources and tutorials online. Google 'MySQL tutorial' and take your pick

Member Avatar for superjj

Thanks vadriaan for your post

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.