Menu
SQL stands for Structured Query Language
SQL lets you access and manipulate databases
Structured Query Language is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS)
There are lot more things you can do with SQL:
You can create a database.
You can create tables in a database.
You can query or request information from a database.
You can insert records in a database.
You can update or modify records in a database.
You can delete records from the database.
You can set permissions or access control within the database for data security.
Introducing database concept
DAtabase Manegement System
Tables
Relational Databases
SQL-no SQL
Select
Insert, Update, Delete
Create, Alter, Drop
Truncate
Primary key, foreigng key, unique key, composite key, not null
One to One
One to Many
Many to Many
char, nchar, varchar1, nvarchar2, number, date
Where, In, Between, Like, Not Like, Distinct
Sub queries
Exist condition
Is Null condition
Order By clause
Aliases
Group by clause
Having clause
Union operator
Intersect operator, minus operator
Inner joins, left joins, right joins, full joins
Fetch next row only, offset
Techpro Education provides quality online IT courses and coding bootcamps with reasonable prices to prepare individuals for next-generation jobs.
From beginners to IT professionals, we offer cutting-edge programs used today by leading corporations.
