In this article, I am going to describe the Complete Roadmap to Learn SQL for beginners. This SQL roadmap will help you to figure out what you must know in SQL. So without wasting any time let's start this article:-
What is DBMS?
DBMS stands for Database Management System(DBMS), it is like a file manager that manages data in a database rather than saving it in a files system. DBMS is a program that controls the creation, maintenance, and use of a database.
What is RDBMS?
RDBMS stands for Relational Database management System which stores the data in the collection of tables.
What is SQL?
SQL stands for Structured Query Language, it is a database that is used to create and access databases to support software applications like MySQL. This database language is primarily designed for maintaining data in relational database management systems. It is a special tool used by data scientists to process structured data (data stored in tabular form). It is also designed to process streams in RDSMS. You can easily create and edit databases, access and modify table rows and columns, etc. This query language became an ANSI standard in 1986 and an ISO standard in 1987.
SQL for Data Science or Data Analytics:
SQL is an important part of Data Science or Data Analytics, if you want to become a data scientist then you must know SQL with advanced concepts. Currently, I am working in Data Analytics and we use SQL every time. So SQL is important for ML or Data scientists.
Types of SQL Statements:
1. DDL(Data Definition Language)
CREATE Statement
ALTER Statement
DROP Statement
TRUNCATE Statement
RENAME Statement
2. DML(Data Manipulation Language)
SELECT Statement
INSERT Statement
UPDATE Statement
DELETE Statement
3. DCL(Data Control Language)
CRANT Statement
REVOKE Statement
4. TCL(Transaction Control Language)
COMMIT Statement
ROLLBACK Statement
SAVEPRINT Statement
Now Here is Roadmap to Learning SQL:
Step1. Basics of SQL
What is SQL
What is the use of SQL in data science
Advantages and Disadvantages of using SQL
Applications of SQL
What is Table
What is Database
SQL Data Types
SQL Operators
Step2. SQL Database Query
SQL CREATE DatabaseS
QL DROP Database
SQL RENAME Database
SQL SELECT Database
Step3. SQL Table Query
CREATE TABLE
DROP TABLE
DELETE TABLE
RENAME TABLE
TRUNCATE TABLE
COPY TABLE
TEMP TABLE
ALTER TABLE
Step4. SQL Top Query
Select Statement:
- SELECT
- SELECT UNIQUE
- SELECT DISTINCT
- SELECT COUNT
- ELECT LAST
- SELECT RANDOM
- SELECT IN
- SELECT SUM
- SELECT Multiple
- SELECT DATE
- SELECT TOP
- SELECT FIRST
- SELECT NULL
SQL Condition Statements:
- WHERE
- AND
- OR
- AS
- WITH
- HAVING Clause
SQL Order By Query:
- ORDER BY Clause
- ORDER BY ASC
- ORDER BY DESC
- ORDER BY RANDOM
- ORDER BY LIMIT
- ORDER BY Multiple Cols
SQL Insert Queries:
- INSERT
- INSERT INTO Values
- INSERT INTO SELECT
- INSERT Multiple Rows
SQL Update Queries:
- Update
- UPDATE JOIN
- UPDATE DATE
SQL Delete Queries:
- DELETE TABLE
- DELETE ROW
- DELETE All Rows
- DELETE Duplicate Rows
- DELETE DATABASE
- DELETE VIEW
- DELETE JOIN
SQL Join Queries:
- JOIN
- Outer Join
- Left Join
- Right Join
- Full Join
- Cross Join
SQL Deys Query:
- Primary Key
- Foreign Key
- Composite Key
- Unique Key
- Alternate Key
Step.5 Aggregate Functions in SQL
AVG()
COUNT()
MAX()
MIN()
SUM()
FIRST()
LAST()
Step6. More Concepts of SQL
SQL vs NoSQL
IN vs EXISTS
Group By vs Order By
Normalization:
- First Normal Form(1NF)
- Second Normal Form(1NF)
- Third Normal Form(3NF)
- Fourth Normal Form(4NF)
WHERE vs HAVING
What is Index
Different Types of Index:
Clustered index
Non-Clustered index
SQL Injection
SQL Injection
Step7. Advance Concepts of SQL
Intersect Operator
Union and Union All Operator
OLTP vs OLAP
stuff()
what is the stored procedure
What is ACID property
What is Datawarehouse
Collation
What is Denormalization
What is Alias in SQL
What is lock escalation
One-to-One Relation
One-to-Many Relation
Many-to-One Relation
Many-to-Many Relation
Conclusion:
We have covered all topics of SQL for beginners or Advance levels. In this article, we have mentioned only all the topics that every programmer should learn. Soon we will
create a full tutorial for this roadmap but in the meantime, you can learn these topics from Google and Youtube. These topics are available free of cost on the internet.
You should also check out, Django Developer Roadmap, Python Developer Roadmap, C++ Complete Roadmap, Machine Learning Complete Roadmap, and Laravel Developer Roadmap.
Thank you for reading this blog. I wish you the best in your journey to learning and mastering SQL.
Follow me to receive more useful content:
Instagram | Twitter | Linkedin | Youtube
Thank you