In this pdf sql notes w3schools we cover all the important topic of sql which help you to learn basic to advance tutorial of sql (pdf)

sql pdf

What is SQL?

Full form of SQL is Structured Query Language, that could be a language to storing, retrieving and manipulating information stored in a relational database.

SQL is a standard language for Relational Database System (RDS).

All the Relational Database Management Systems (RDMS) like MySQL, Oracle, Sybase, Postgres , SQL Server etc. use SQL language.

Why SQL?

SQL is most popular because SQL offers the following advantages −

Video by thapa technical Via Thapa Technical


Introduction to MySQL

Creating database

Delete a database

Use a database

Check current database

Create database

Show table

Describe table name

Delete a table

Insert data into table

Show data of table

Show warnings

Null vs not null

Default value

Add column in a table

Delete a table

Primary key

Auto increment

CRUD operation

Select distinct statement

Order by keyword

Limit keyword

Like operator

Aggregate function

Logical operation

Concat function

Reverse function

Character length function

Uppercase function

Lowercase function

Date time data type

Foreign key

Inner join

Left join

Right join

Outer join


new_gif Learn HTML with notes click herenew_gif

new_gif Learn CSS with notes click herenew_gif

new_gif Learn JS with notes click herenew_gif