Learn SQL in 10 Minutes!! | SQL for beginners

preview_player
Показать описание
SQL, which is Structured Query Language, is a language used for managing relational databases. In this video, I've tried to cover the #sql basics for beginners. #sqlforbeginners

Timestamps:
00:00 SQL is Structured Query Language
00:36 Why USE SQL?
00:47 Create a database with SQL
01:03 SQL query to create a table
02:06 SQL query to insert data in table
02:43 Select query in SQL
03:24 Where conditions in SQL
03:37 Logical Operators in SQL
04:41 SQL query to delete data items from table
05:07 SQL query to update data items in table
05:35 Order by clause in SQL
05:59 Arithmetic operations in SQL
06:34 SQL functions
07:18 SQL query to add column in table
08:30 SQL query to rename tables
08:45 SQL query to change column names
09:07 dropping columns, tables and database in SQL

Support ME by joining this channel:

My Social Media Handles:

Don't forget to Subscribe!!!

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

A database is the collection of data, and a relational database is a database in which data items get stored in tables with some relation between those data items and tables.

MYSQL, PostgreSQL, MariaDB, and SQLlite are some examples of relational databases.

With the help of SQL, we can create, update, delete, and do other operations to control data items in the database.

To create a database, you can use the CREATE DATABASE command and then your database name, like school, and the semicolon.

To use the database that we've just created, type use and then the database name and semicolon.

The syntax for creating a table in SQL: CREATE TABLE [IF NOT EXISTS] TableName (column_name dataType [optional parameters]);

The syntax for inserting values in a table in SQL: INSERT INTO `table_name`(column_1,column_2,...) VALUES (value_1,value_2,...);

You can use select query to fetch data from the tables.
Example : select * from Books;

More about SQL in the video 🙃
Рекомендации по теме
Комментарии
Автор

You have my respect, you save my lots of time of revision.👍

SACHITKHADE
Автор

Great video! I was looking for a quick introduction on sql and how it’s used and this was exactly what i needed thank you

erazn
Автор

4:37 must be AND operator, since that way it can verify username and password match each other

keyagupta
Автор

Android main kali kaise install kar sakte hai

thrishu