SQL for beginners

Online courses

SQL for beginners

SQL on your computer screen

Learn SQL from the ground up and use it directly in databases. Get a hands-on and in-depth introduction – with perpetual access, so you can learn at your own pace and repeat whenever you want.

Translated by AI
SQL on your computer screen

Signup

SQL for beginners

Login Register

SQL (Structured Query Language) is the most commonly used language for extracting, analyzing, and working with data in relational databases. In this course, you will get a practical and beginner-friendly introduction to SQL, where you will learn how to formulate queries, filter and sort data, and combine information from multiple tables. The course requires no prior knowledge, and you work with concrete examples that give you skills you can use immediately.

Throughout the course, you gradually build an understanding of how SQL works and how you can use the language for data processing and analysis. This is a useful skill in a data-driven everyday life, both at work and in studies.

What you will learn in the course

  • Filter and sort data with conditions and correct order
  • Select specific columns from tables for targeted data insights
  • Use functions such as SUM, AVG, and COUNT to aggregate data
  • Combine data from multiple tables using JOIN
  • Conduct hands-on case studies and data management with SQL

About the course

Read about how the course is structured and what you can do after completing the course.
Kursoppbygning

Kurset består av 8 moduler:

  1. Introduksjon – Hva SQL er, oppsett og grensesnitt
  2. Grunnleggende spørringer – SELECT, WHERE, ORDER BY
  3. Funksjoner og aggregater – SUM, AVG, COUNT, GROUP BY
  4. Filtrering og sortering – Logiske operatorer og betingelser
  5. Flere tabeller – JOIN og relasjoner
  6. Endring av data – INSERT, UPDATE, DELETE
  7. Case og praktiske øvelser – Anvende kunnskapen i virkelige datasett
  8. Avslutning – Oppsummering og veien videre
Læringsutbytte

Etter kurset kan du:

  • Aggregere data med SUM, AVG, COUNT
  • Velge spesifikke kolonner fra tabeller
  • Forstå grunnleggende SQL-programmering
  • Filtrere data ved hjelp av betingelser
  • Sortere data for bedre oversikt
  • Kombinere tabeller med JOIN
  • Utføre praktiske case-studier
  • Bruke SQL til databehandling
  • Gruppere data for analyse

Practical information

  • The course is 100% online and can be taken at your own pace when it suits you. Estimated completion time is approx. 2 hours, but will depend on how much you work on tasks along the way
  • No prior knowledge required
  • You get access within two working days and have perpetual access to the course. This gives you the opportunity to repeat and update the knowledge when you need it, whether it's months or years later
  • You will receive a course certificate after completing the course
  • Registration is binding, and the full course fee must be paid upon cancellation.

Aina Øverås Skott

Course instructor Aina Øverås Skott is a skilled computer scientist at SpareBank 1 SMN with a background in nano-chemistry from the University of Oslo. With expertise in Power BI, SAS Visual Analytics, Machine Learning, Python and SQL, she delivers innovative solutions in data analytics. Aina's unique ability to combine technical knowledge with business insight makes her a valuable asset in the banking industry.

Do you have any questions?