TABLE OPERATIONS:-
SQL CREATE TABLE
SQL DROP TABLE
SQL DELETE TABLE
SQL RENAME TABLE
SQL TRUNCATE TABLE
SQL COPY TABLE
SQL TEMP TABLE
SQL ALTER TABLE
SELECT :
SELECT DISTINCT
SELECT COUNT
INSERT
UPDATE
CASE
CAST
COALESCE
SubQuery
Mathematical functions
Date functions
STRING OPERATIONS:-
SQL String Functions( substring ,concat etc)
LTRIM Function in SQL
UPPER Function in SQL
RTRIM Function in SQL
CONCAT
JOIN
SQL JOIN
SQL Outer Join
SQL Left Join
SQL Right Join
SQL Full Join
SQL Cross Join
CTE (common Table exp)
CLAUSES
SQL WHERE
SQL AND
SQL OR
SQL WITH
SQL AS
SQL ORDER BY
SQL HAVING Clause
LIKE
IS NULL, LIKE, BETWEEN, IN
&& or AND
Agg Functions:
SUM
AVG
MAX
MIN
WINDOW FUNCTIONS ( RANK, ROW_NUMBER OVER)
View this Course
Top Tutor
Certified
You have successfully registered
