Download "Уроки SQL для начинающих / #1 - Что такое SQL? Установка локального сервера"

Please wait. We're preparing links for easy ad-free video watching and downloading.

Previous video: Основы SQL - #3 – Редактирование таблиц, расширенные возможности SELECT, функции Next video: Уроки SQL для начинающих / #6 - Создание индексов и работы с ними

Уроки SQL для начинающих / #6 - Создание индексов и работы с ними

Уроки SQL для начинающих / #6 - Создание индексов и работы с ними

Channel: Гоша Дударь

Основы SQL - #3 – Редактирование таблиц, расширенные возможности SELECT, функции

Основы SQL - #3 – Редактирование таблиц, расширенные возможности SELECT, функции

Channel: loftblog

Начальный курс SQL.Фильтрация HAVING

Начальный курс SQL.Фильтрация HAVING

Channel: Igor Vovchenko

02 - Создаем таблицу - Уроки PostgreSQL

02 - Создаем таблицу - Уроки PostgreSQL

Channel: Аве Кодер

Основы SQL - #1 – Введение

Основы SQL - #1 – Введение

Channel: loftblog

Основы Базы данных и SQL #7. Выборка данных. Команда SELECT.

Основы Базы данных и SQL #7. Выборка данных. Команда SELECT.

Channel: Andrey Baranov

Основы SQL - #5 – Транзакции

Основы SQL - #5 – Транзакции

Channel: loftblog

Основы SQL - #4 – Триггеры

Основы SQL - #4 – Триггеры

Channel: loftblog

#19. Объединение таблиц SQL - RIGHT JOIN | Основы SQL

#19. Объединение таблиц SQL - RIGHT JOIN | Основы SQL

Channel: Maxim Kukhar [Learning Excel, VBA, SQL]

Уроки SQL для начинающих / #4 - Удаление данных из БД

Уроки SQL для начинающих / #4 - Удаление данных из БД

Channel: Гоша Дударь

sql

sql для начинающих

server

mysql

бд

база данных

субд

рсубд

sqlite

postgresql

программирование

sql уроки

sql server

00:00:00

hello, starting with this lesson we

00:00:02

are starting a course on learning the sql language

00:00:05

during the course we will not study and

00:00:07

glued together using the example of any other

00:00:08

programming language we will study itself and

00:00:11

scaling and learn how to sign the correct

00:00:13

commands for working with databases

00:00:15

a little information about the language language and the skill

00:00:18

appeared back in the 70s but still

00:00:21

remains a mega popular and

00:00:22

in demand language and sqweel

00:00:24

is used to write all kinds of

00:00:26

queries to databases, this is sampling,

00:00:28

updating, adding, deleting records and

00:00:31

much more

00:00:32

when creating a mobile

00:00:34

application program or a website that

00:00:36

uses databases my data, with a

00:00:37

probability of almost 100 percent, I

00:00:39

will have to work with the sql language, so what

00:00:42

is

00:00:43

sql sql is a query language for a relational

00:00:46

database, based on it you cannot

00:00:48

build a program or website,

00:00:49

the only function it

00:00:51

performs is to generate a query to the

00:00:53

database and based on the query it produces

00:00:55

various manipulations within a

00:00:58

company's database often require skills and

00:01:00

knowledge of the sql language when applying for a

00:01:02

job. During the video course you

00:01:04

will become familiar with writing commands for

00:01:06

working with databases and based on these

00:01:08

commands you will be able to work with databases

00:01:11

using any other language and

00:01:13

languages such as Python Sysharp C plus plus php

00:01:16

and so on, all languages use

00:01:18

different options for connecting to the

00:01:20

database,

00:01:21

but the principle of sending requests remains

00:01:23

the same since it is written in the sql language,

00:01:25

the language is used in many

00:01:27

relational databases, among which we

00:01:29

can highlight a bowl of hp. keylight

00:01:32

oracle post grayscale microsoft sql

00:01:35

server and many many others from Kirill

00:01:38

acts as an intermediary between

00:01:40

databases and projects the structure here is like this

00:01:42

you have a project let it be in a

00:01:44

program written in stove or python you

00:01:47

also have a date base for example May

00:01:49

Askel although this no matter what kind of database it will be,

00:01:52

in order to connect these two things with each

00:01:54

other, we need a language that understands

00:01:56

both the first and second part of

00:01:58

the logic described above, such a language

00:02:00

is hpl, in it you write

00:02:03

a command, and this command will be

00:02:04

the same for the stove, for Python,

00:02:07

and for other programming languages

00:02:08

after By executing the command you will be able to

00:02:10

get records from the database, write

00:02:14

data to the database or do

00:02:16

other manipulations in the lesson we will install a

00:02:18

local server and also launch picks

00:02:20

May admin is a special program

00:02:22

that has a graphical interface for working

00:02:25

with the database May searched inside the

00:02:27

program we will record all

00:02:29

the scales commands creating tables and databases

00:02:32

and also working with records of internal

00:02:34

similar programs, there are thousands, but I

00:02:37

chose stoves, we are the admin because I constantly

00:02:39

work with it, plus it has a beautiful

00:02:41

interface and ideally suits our

00:02:43

needs, you can choose any other

00:02:45

program if you want the

00:02:47

language syntax sql will not be any different, but

00:02:50

before we continue, I want to recommend

00:02:52

the site IT Prager dot com on this site

00:02:54

you will find the entire video course on the sql language

00:02:57

as well as homework, ready-made code and

00:02:59

a lot of other useful information, the link

00:03:01

to this course will be in the description of this

00:03:03

video

00:03:04

now let's install a local

00:03:06

server to install such a server,

00:03:08

there are a huge number of different

00:03:09

programs, I have identified three programs that

00:03:12

you can install, these are programs

00:03:15

such as sam open server

00:03:18

and also the mayor, this is the last

00:03:20

program I will install

00:03:22

all the links to these three programs and you

00:03:24

will find in the description of this video,

00:03:26

respectively, the

00:03:27

meme program will also have a link in the

00:03:29

description of this video, we just

00:03:31

go to the official website and then

00:03:34

download the free version, free

00:03:36

download, click here it will be

00:03:39

available this program on both mac and

00:03:41

windows

00:03:42

if For example, if you work on Linux, it

00:03:44

’s better to download s.m. since there is support for wimax, but for my purposes, mom is completely suitable for me and, in principle, all these programs are not very, very similar, so it doesn’t matter what program you download, for example, I download it for a Mac and now I will install it after you download it, install it There are no pitfalls here, so install this program as a regular program and then run the program itself. Here you will need to start the servers. To do this, you click on just start Charles and thereby start the servers. This does not happen instantly, so you have to wait a little, after which you will open a page in your browser where you have various settings, for example, going to the stove my admin, here are the stoves of my admin, but we can already go to it, here you can just open the website itself, click on my website and here it is here it opens on localhost four eights, well, we are not specifically interested in website development, we are interested in the sql language and, accordingly, we are interested in the stoves that run, so we go to the letter may may admin and here we get into the graphical interface for working with the database, here right away I propose to do this, change the fact that we will have Russian language, this is what we immediately change, and also the theme here is set as the original, I propose to change it to this second theme, it is much more beautiful, quite everything has become more so nice and it is in this format that we are now with we will work with you to talk about the graphical interface of the match may admin there is no point because it is just a graphical shell that allows us to work with the may sql database and, in principle, in this graphical shell in the stove we are the admin we can create various databases in them create various plates to fill out these signs are the topic or data, select this data, update the data, delete any data, and so on, that is, we can do all this simply in the graphical interface by clicking on any buttons, and thus various commands from Kyiv will be executed, and everything will be we are not particularly interested in processing this ourselves; we are interested in the sql tab, and it is in this fold that we will create various databases, various tablets, and we will write all this manually, simply by writing various commands in the sql language, in addition, if you want more to integrate into the graphical interface of php may alone then in the description of this video I will leave a link to the video where I did a detailed analysis of the entire graphical interface of baking my admin so if this is interesting then watch this video lesson in the same video course I will not go into depth on those points which are related specifically to the graphical component of the pick my admin starting the next lesson in this tab with whom we will register with you various searched commands that will allow us to manipulate our database in the same video lesson we will do nothing more with you so that’s it all of us, if you liked the lesson, then like, subscribe to the channel and join the VKontakte group, all links are in the description of this video, see you soon

Description:

Язык SQL используется в любой программе и на любом веб сайте, где идет работа с базами данных. В ходе курса вы изучите язык SQL, а также научитесь работать с базами данных на примере MySQL. 1) Курс по SQL на itProger: https://itproger.com/course/sql 2) Программма XAMPP: https://www.apachefriends.org/ru/index.html 3) Программа OpenServer: https://ospanel.io/ 4) Программма MAMP: https://www.mamp.info/en/windows/ 5) Видео по работе с графическим интерфейсом PhpMyAdmin: https://www.youtube.com/watch?v=IVel5tkB6mo ✔ Сообщество программистов: https://itproger.com/ ✔ ------------- Вступай в группу Вк - https://vk.com/prog_life 🚀 Группа FaceBook - https://www.facebook.com/unsupportedbrowser Инстаграм itProger: https://www.facebook.com/unsupportedbrowser Instagram: https://www.facebook.com/unsupportedbrowser Telegram: https://t.me/itProger_official Twitter - https://twitter.com/GoshaDudar - Уроки от #GoshaDudar 👨🏼‍💻 - Все уроки по хештегу #goshaSQL

Preparing download options

Popular

HD video

Only sound

All

* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."

** — Link intended for online playback in specialized players

Questions about downloading video

How can I download "Уроки SQL для начинающих / #1 - Что такое SQL? Установка локального сервера" video?

http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.
The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.
UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.
UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.

Which format of "Уроки SQL для начинающих / #1 - Что такое SQL? Установка локального сервера" video should I choose?

The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.

Why does my computer freeze when loading a "Уроки SQL для начинающих / #1 - Что такое SQL? Установка локального сервера" video?

The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.

How can I download "Уроки SQL для начинающих / #1 - Что такое SQL? Установка локального сервера" video to my phone?

You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.

How can I download an audio track (music) to MP3 "Уроки SQL для начинающих / #1 - Что такое SQL? Установка локального сервера"?

The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.

How can I save a frame from a video "Уроки SQL для начинающих / #1 - Что такое SQL? Установка локального сервера"?

This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.

What's the price of all this stuff?

It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.