Зміст курсу
SQL Basics
SQL Basics
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
SELECT * FROM table_name
Please note, that SQL is case-insensitive, i.e. SELECT and select will be equally interpreted by SQL.
Завдання
Extract all the rows from the audi_cars table.
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівДякуємо за ваш відгук!
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
SELECT * FROM table_name
Please note, that SQL is case-insensitive, i.e. SELECT and select will be equally interpreted by SQL.
Завдання
Extract all the rows from the audi_cars table.
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівДякуємо за ваш відгук!
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
SELECT * FROM table_name
Please note, that SQL is case-insensitive, i.e. SELECT and select will be equally interpreted by SQL.
Завдання
Extract all the rows from the audi_cars table.
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівДякуємо за ваш відгук!
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
SELECT * FROM table_name
Please note, that SQL is case-insensitive, i.e. SELECT and select will be equally interpreted by SQL.
Завдання
Extract all the rows from the audi_cars table.
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівПерейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів