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)
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 −
-
Using SQL user can access data in the relational database management systems.
-
Using SQL user can describe the data.
-
Using SQL user can define the data in a database and manipulate that data.
-
Using SQL user can create and drop databases and tables.
-
Using SQL user can create view, stored procedure, functions in a database.
-
Using SQL user can set permissions on tables, procedures and views.
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
Learn
HTML with notes