PDF SQL NOTES (STRUCTURE QUERY LANGUAGE)
w3schools

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

TABLE OF CONTENTS


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



OTHER COURSES

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