Learn SQL in 10 Minutes!! | SQL for beginners
AmanBytes AmanBytes
31.3K subscribers
7,407 views
262

 Published On Premiered Dec 11, 2022

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

Learn C language in 10 Minutes:    • Learn C Language In 10 Minutes!! C La...  

Support ME by joining this channel:
   / @amanbytes  

Learn Python in 30 Minutes:    • Python Tutorial For Beginners | Learn...  
Full Kali Linux Tutorial:    • Video  

Full termux playlist :    • Full Termux Tutorial  
Amazing Information in 100 Seconds:    • Amazing Info In 100 Seconds  
Kali Linux Playlist:    • Kali Linux Tutorials  

My Social Media Handles:
Instagram:   / amanbytes  
Twitter:   / amanbytes  

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 🙃

show more

Share/Embed