Learning SQL might be the most significant step of your career in 2023.
Master SQL from here👇🏻
Master SQL from here👇🏻
What is SQL
- SQL or Structured Query Language, is a programming language used to manage and manipulate data stored in relational databases.
- SQL or Structured Query Language, is a programming language used to manage and manipulate data stored in relational databases.
Why use SQL
SQL allows you to store data, manage data relationships, and create, read, update, and delete data. Simply put, it is the power storage of your application.
SQL allows you to store data, manage data relationships, and create, read, update, and delete data. Simply put, it is the power storage of your application.
Data definition language (DDL)
Set of commands to define tables, views, etc.
CREATE - Create a Database
ALTER - Modify Database
DROP - Delete objects
Set of commands to define tables, views, etc.
CREATE - Create a Database
ALTER - Modify Database
DROP - Delete objects
Data Manipulation Language
Subset of SQL , refers to the process of modifying, adding, or deleting data in a database
SELECT - used to retrieve data from a database.
INSERT - add new rows to a table in a database
UPDATE - modify existing rows in a table in a database.
Subset of SQL , refers to the process of modifying, adding, or deleting data in a database
SELECT - used to retrieve data from a database.
INSERT - add new rows to a table in a database
UPDATE - modify existing rows in a table in a database.
Aggregate Functions
• AVG: Calculates the average of a set of values
•COUNT: Counts the number of rows in a table joins
•MAX: Finds the maximum value in a set of values
• MIN: Finds the minimum value in a set of values
• SUM: Calculates the sum of a set of values
• AVG: Calculates the average of a set of values
•COUNT: Counts the number of rows in a table joins
•MAX: Finds the maximum value in a set of values
• MIN: Finds the minimum value in a set of values
• SUM: Calculates the sum of a set of values
Data control language (DCL)
set of commands that can be used to grant and revoke privileges to users, and to manage transactions.
GRANT: used to give a user or role access to database objects.
REVOKE: used to remove access to database objects from a user or role.
set of commands that can be used to grant and revoke privileges to users, and to manage transactions.
GRANT: used to give a user or role access to database objects.
REVOKE: used to remove access to database objects from a user or role.
Advanced concepts
-Transactions
- Stored Programming
- Procedures
- Cursors
- Functions
Check out my detailed blog for more:
adarsh-gupta.medium.com
-Transactions
- Stored Programming
- Procedures
- Cursors
- Functions
Check out my detailed blog for more:
adarsh-gupta.medium.com
Thanks for checking this out
1) Like this post
2) Retweet this with your audience
Follow @Adarsh____gupta for more threads on Web development, Database, programming, and MORE.
1) Like this post
2) Retweet this with your audience
Follow @Adarsh____gupta for more threads on Web development, Database, programming, and MORE.
جاري تحميل الاقتراحات...