Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Lære The very first meet with the database | Selecting
SQL Basics

Sveip for å vise menyen

book
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
copy

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

Oppgave

Swipe to start coding

Extract all the rows from the audi_cars table.

Løsning

Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 1. Kapittel 1

Spør AI

expand
ChatGPT

Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår

book
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
copy

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

Oppgave

Swipe to start coding

Extract all the rows from the audi_cars table.

Løsning

Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 1. Kapittel 1
Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Vi beklager at noe gikk galt. Hva skjedde?
some-alt