Which SQL wildcard is used to match any number of characters (including zero characters)?
Anonymous Quiz
33%
*
11%
&
8%
$
48%
%
❤1
Which SQL function is used to convert text into uppercase?
Anonymous Quiz
13%
CAPITAL()
0%
LOWER()
87%
UPPER()
0%
TEXT()
WHICH OF THE FOLLOWING COMMAND IS A DDL COMMAND ?
Anonymous Quiz
34%
SELECT
25%
INSERT
33%
TRUNCATE
9%
DELETE
All concepts are explained in detail in the PDF.
To get the PDF:
📌 Comment “PDF”
or
📌 Join our Telegram channel. #SQL #SQLTutorial #LearnSQL #DatabaseManagement
https://www.instagram.com/p/DTDKw4SkiJp/?igsh=ajIyczYyZzY2Y3c5
To get the PDF:
📌 Comment “PDF”
or
📌 Join our Telegram channel. #SQL #SQLTutorial #LearnSQL #DatabaseManagement
https://www.instagram.com/p/DTDKw4SkiJp/?igsh=ajIyczYyZzY2Y3c5
❤1
DCL commands are mainly used for:
Anonymous Poll
15%
Data definition
31%
Data manipulation
31%
Transaction control
22%
Data security
DQL is mainly used for
Anonymous Poll
65%
Retrieving data
8%
Creating tables
9%
Deleting data
18%
Modifying data
Which clause is executed after GROUP BY in SQL logical query processing?
Anonymous Quiz
15%
WHERE
72%
HAVING
9%
FROM
4%
SELECT
❤2
15 Days SQL Roadmap
Master SQL in 15 Days | Beginner → Advanced
Day 1 – Introduction to Databases & SQL
• What is DBMS
• What is SQL
• Types of Databases
Day 2 – SQL Installation & Setup
• Install MySQL / PostgreSQL
• Database & Table basics
Day 3 – Basic SQL Queries
• SELECT
• WHERE
• DISTINCT
Day 4 – Filtering Data
• AND, OR, NOT
• BETWEEN
• IN Operator
Day 5 – Sorting & Limiting
• ORDER BY
• LIMIT
• OFFSET
Day 6 – Aggregate Functions
• COUNT()
• SUM()
• AVG()
• MIN() & MAX()
Day 7 – GROUP BY & HAVING
• GROUP BY
• HAVING Clause
• Aggregation with Groups
Day 8 – String Functions
• CONCAT()
• LENGTH()
• UPPER() / LOWER()
Day 9 – Date Functions
• CURRENT_DATE
• DATE_FORMAT
• Date Calculations
Day 10 – Joins (Most Important)
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
Day 11 – Advanced Joins
• FULL JOIN
• SELF JOIN
Day 12 – Subqueries
• Nested Queries
• Correlated Subqueries
Day 13 – Views & Indexes
• CREATE VIEW
• Index Basics
Day 14 – Stored Procedures & Functions
• Stored Procedures
• User Defined Functions
Day 15 – SQL Project & Practice
• Build Mini Database Project
• Practice Interview Questions
Master SQL in 15 Days | Beginner → Advanced
Day 1 – Introduction to Databases & SQL
• What is DBMS
• What is SQL
• Types of Databases
Day 2 – SQL Installation & Setup
• Install MySQL / PostgreSQL
• Database & Table basics
Day 3 – Basic SQL Queries
• SELECT
• WHERE
• DISTINCT
Day 4 – Filtering Data
• AND, OR, NOT
• BETWEEN
• IN Operator
Day 5 – Sorting & Limiting
• ORDER BY
• LIMIT
• OFFSET
Day 6 – Aggregate Functions
• COUNT()
• SUM()
• AVG()
• MIN() & MAX()
Day 7 – GROUP BY & HAVING
• GROUP BY
• HAVING Clause
• Aggregation with Groups
Day 8 – String Functions
• CONCAT()
• LENGTH()
• UPPER() / LOWER()
Day 9 – Date Functions
• CURRENT_DATE
• DATE_FORMAT
• Date Calculations
Day 10 – Joins (Most Important)
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
Day 11 – Advanced Joins
• FULL JOIN
• SELF JOIN
Day 12 – Subqueries
• Nested Queries
• Correlated Subqueries
Day 13 – Views & Indexes
• CREATE VIEW
• Index Basics
Day 14 – Stored Procedures & Functions
• Stored Procedures
• User Defined Functions
Day 15 – SQL Project & Practice
• Build Mini Database Project
• Practice Interview Questions
❤8