← Courses
πŸ—„οΈ

SQL for Beginners

The language of databases β€” needed by developers, testers and analysts.

πŸ“š 4 lessons ⏱ 8 h πŸ“Š Beginner πŸ§ͺ Quizzes πŸ§‘β€πŸ’» 13 practice tasks #SQL#SQLite#JOIN

About the course

Almost every website and app stores data in a database. SQL is the universal language to read and change it. You'll write queries, filter and sort, create tables, modify records, calculate statistics and join tables. All hands-on in the browser, no complex setup.

What you'll learn

  • Write SELECT queries with filters
  • Create and modify tables
  • Calculate statistics with GROUP BY
  • Join tables with JOIN

Syllabus

  1. 01 Databases and your first SELECT πŸ§‘β€πŸ’» 3 πŸ”’
  2. 02 Filtering and sorting: WHERE, ORDER BY, LIMIT πŸ§‘β€πŸ’» 4 πŸ”’
  3. 03 Creating tables and changing data πŸ§‘β€πŸ’» 3 πŸ”’
  4. 04 Aggregate functions, GROUP BY and JOIN πŸ§‘β€πŸ’» 3 πŸ”’

FAQ

Who needs SQL?

Backend developers, QA testers, data analysts and even marketers.

What do I need to install?

Nothing: you can run every query in an online editor in your browser.

Is SQL the same in every database?

The basics (SELECT, WHERE, JOIN, GROUP BY) are the same in SQLite, MySQL and PostgreSQL.

Questions?

Leave your contact β€” we'll reply on Telegram.

By clicking the button you agree to the privacy policy.