SQL TOPICS FOR BEGINNERS | SQL COURSE 7 DAYS

https://www.youtube.com/@yadav.prakash?sub_confirmation=1

WHAT IS SQL

DIFFERENCE BETWEEN DBMS AND RDBMS

TYPES OF COMMAND IN SQL

DDL Data Definition Language
DQL Data Query Language
DML Data Manipulation Language
DCL Data Control Language
TCL Transaction Control Language


List of DDL commands
CREATE
DROP
ALTER
TRUNCATE
RENAME

List of DML commands
INSERT It
UPDATE.
DELETE

DQL
SELECT


DCL
GRANT
REVOKE

TCL Transaction Control Language
ROLLBACK
TRANS
COMMIT
SAVEPOINT

#youtubers
#subscribe
#youtubevideos
#sub
#youtubevideo
#like
#instagram
#youtubechannel
#youtube
#youtuber
#youtubechannel #youtube #youtuber #youtubers #subscribe #youtubevideos #sub #youtubevideo #like #instagram #follow #video #vlog #subscribetomychannel #gaming #music #explorepage #love #smallyoutuber #vlogger #youtubegaming #instagood #gamer #youtubecommunity #likes #explore #youtubelife #youtubecreator #ps #bhfyp
#viral #share #linkinbio #tiktok #youtubekids #newyoutuber #youtubesubscribers #subscribers #k #smallyoutubersupport #followforfollowback #subforsub #blogger #youtubemusic #comment #youtuberindonesia #newvideo #art #photography #instadaily #contentcreator #memes #twitch #trending #followback #youtubegamer #subs #youtubeindia #fortnite #followme



DATA TYPES IN SQL
NUMERIC DATA TYPE
BIT
TINY INT
SMALL INT
INT
BIG INT
UNIQUE IDENTIFIER

DECIMAL DATA TYPE
FLOAT
DECIMAL

STRING DATA TYPE
CHAR
VARCHAR
NCHAR
NVARCHAR
UNICODE
AND NON UNICODE


DATETIME DATA TYPES

DATE
DATIME
DATETIME2

CLAUSES IN SQL
WHERE
IN
NOT IN
AND
OR
BETWEEN
EXIST
LESS THAN
LESS THAN EQUAL TO
GREATER THAN
GREATER THAN EQUAL TO
IS NULL
IS NOT NULL
HAVING
ORDER BY
TOP
PERCENT


DIFFERNECE BETWEEN ISNULL AND NULLIF


COMPUTED COLUMN



WILD CARD OPERATIOR LIKE OPERATOR FOR ADVANCE SEARCH
LIKE

`STRING FUNCTION IN SQL

CONCAT
SUBSTRING
CHARINDEX
REPLACE
UPPER
LOWER
LEN
LTRIM
RTRIM
LEFT
RIGHT
REPLICATE
REVERSE
STUFF
ASCII
CHAR
QUOTENAME
PATI INDEX

DATETIME FUNCTION IN SQL
DATEADD
DATENAME
DATEPART
DATEDIFF
GETDATE
EOMONTH
YEAR
WEEK
DAY

IDENTITY

HOW TO INSERT VALUE IN IDENTITY COLUMN

HOW TO RESET IDENTITY
RESEED

DIFFERENCE BETWEEN ISNULL AND COALESE

DIFFERENCE BETWEEN COUNT COLUMN AND COUNT *


DIFFERENCE BETWEEN CAST AND CONVERT

AGGREGATE FUNCTION IN SQL
MIN
MAX
SUM
COUNT
AVG


DIFFERENCE BETWEEN WHERE AND HAVING

TYPES OF CONSTRAINT IN SQL
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT

UNION AND UNION ALL IN SQL

INTERSECT IN SQL

EXCEPT IN SQL

WHAT’S IS VIEW IN SQL AND
TYPES OF VIEW.
1 SIMPLE VIEW
COMPLEX VIEW


SCHEMABINDING
MATERLIZED VIEW
WHAT’S SCHEMA


TRIGGER IN SQL
INSTEAD OF TRIGGER
AFTER TRIGGER
MAGIC TABLE
INSERTED
DELETED


WINDOWS FUNCTION IN SQL
AGGREGATE FUNCTION
MIN
MAX
AVG
SUM
COUNT
RANKING FUNCTION
ROW_NUMBER
RANK
DENSE_RANK
NTILE

ANALYTIC FUNCTION
LAG
LEAD
FIRST_VALUE
LAST_VALUE


DATA INTEGRITY
1 SYSTEM DEFINED DATA INTEGRITY
1 Entity Integrity
PRIMARY KEY
UNIQUE KEY
NOT NULL
Referential Integrity
AFOREIGN KEY
Domain Integrity
A CHECK
B DEFAULT

2 USER DEFINED DATA INTEGRITY
BY TRIGGER


TYPES OF JOIN IN SQL

1 OUTER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
2 INNER JOIN
3 CROSS JOIN
4 SELF JOJN

CASE STATEMENT
MERGE STATEMENT
WHAT’S PHYSICAL AND LOGICAL JOIN IN SQL

NORMALIZATION IN SQL
1 1NF
2NF
3NF
BCNF

TEMP TABLE TEMPOARY TABLE
TABLE VARIABLE
CTE COMMON TABLE EXPRESSION

TYPES OF RELATION IN SQL
ONE TO ONE
ONE TO MANY
MANY TO ONE
MANY TO MANY


Types of SQL Subqueries
1. Single Row Subquery
2. Multiple Row Subquery
3. Multiple Column Subqueries
4. Correlated Subqueries
5. Nested Subqueries

DEFAULT DATABASE IN SQL

RECOVERY MODELS IN SQL

KNOWLEDGE SYS. TABLES

WHILE LOOP

UDF USE DEFINED FUNCTION

STORED PROCEDURE

ERROR HANDLING
TRY AND CATCH

TRANSACTION IN SQL
TRAN AND COMMIT AND ROLLBACK

ACID PROPERITY

ISOLATION LEVEL IN SQL
Read Uncommitted
Read Committed
Repeatable Read
Serializable
Snapshot


TYPES OF IDENTITY IN SQL
1 @@IDENTITY
IDENT_IDENTITY
SCOPE_IDENTITY

PIVOT TABLE

DYNAMIC QUERY

CURSER AND TYPES

TYPES OF INDEX IN SQL
CLUSTERED INDEX
NON CLUSTERED INDEX
COVERING INDEX
COLUMN STORED INDEX
FILTER INDEX



TABLE SCAN
INDEX SCAN
SEEK SCAN

INDEX REBULID AND REORGANIZE INDEX
FREGMENTATION
FILL FACTOR




USE FOR FUNCTION JOIN WITH TABLE
OUTER APPLY
CROSS APPLY

DEAD LOCK
BLOCKING

FLOOR AND CELLING

TABLE PARTITION AND TYPES
WHAT IS SQL AGENT AND WORK
SQL PROFILER