Lære The very first meet with the database

Welcome on board! SQL (Structured Query Language) is the programming language used for manipulating and extracting data from databases. Usually, the code used to extract some data is called a query. In this course, you will learn how to build different queries: from the simplest to more complex. Over this course, you will work with the audi_cars database which contains information on price, model, and different characteristics of used Audi cars.

The very first query

The simplest query in SQL looks like a sentence: select something from somewhere. To select all the rows from the database write


              12
            
SELECT *
FROM table_name

Please note, that SQL is case-insensitive, i.e. SELECT and select will be equally interpreted by SQL.

Opgave

Swipe to start coding

Extract all the rows from the audi_cars table.

Løsning

Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder

Var alt klart?

Tak for dine kommentarer!

Sektion 1. Kapitel 1

single

Spørg AI

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

The very first query

The simplest query in SQL looks like a sentence: select something from somewhere. To select all the rows from the database write


              12
            
SELECT *
FROM table_name

Please note, that SQL is case-insensitive, i.e. SELECT and select will be equally interpreted by SQL.

Opgave

Swipe to start coding

Extract all the rows from the audi_cars table.

Løsning

Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder

Var alt klart?

Tak for dine kommentarer!

Sektion 1. Kapitel 1

single

Stryg for at vise menuen

The very first query

The simplest query in SQL looks like a sentence: select something from somewhere. To select all the rows from the database write


              12
            
SELECT *
FROM table_name

Please note, that SQL is case-insensitive, i.e. SELECT and select will be equally interpreted by SQL.

Opgave

Swipe to start coding

Extract all the rows from the audi_cars table.

Løsning

Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder

Var alt klart?

Tak for dine kommentarer!

The very first meet with the database

The very first query

Løsning

Awesome!

The very first meet with the database

The very first query

Løsning

Awesome!

The very first meet with the database

The very first query

Løsning