Scribd
Upload
4 views25 pages

Python 1

The document outlines various SQL concepts and commands, including DDL (Data Definition Language) and DML (Data Manipulation Language) operations. It covers filtering, combining data through joins, and functions for manipulating data types such as strings, numbers, and dates. Additionally, it discusses aggregation and analytical functions, emphasizing the importance of handling NULL values in SQL queries.

Uploaded by

emrg2015escom
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views25 pages

Python 1

The document outlines various SQL concepts and commands, including DDL (Data Definition Language) and DML (Data Manipulation Language) operations. It covers filtering, combining data through joins, and functions for manipulating data types such as strings, numbers, and dates. Additionally, it discusses aggregation and analytical functions, emphasizing the importance of handling NULL values in SQL queries.

Uploaded by

emrg2015escom
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SELECT

DISTINCT

TOP

1
2
DDL
CREATE

ALTER

DROP

3
4
DML
UPDATE

UPDATE

5
6
FILTERING
WHERE

BETWEEN

IN - NOT IN

7
LIKE

8
9
COMBINIG DATA

10
JOIN ​ ​ “COLUMNS”

11
INNER

FULL

LEFT ANTI LEFT

12
FULL ANTI JOIN

CROSS JOIN

MULTIPLE ​ LEF​ ​ JOIN

13
SET ​ ​ “ROWS”

UNION
NO DUPLICATES​ ALL ROWS
SLOW

UNION ALL
DUPLICATES​​ ALL ROWS
FAST

EXCEPT
NO DUPLICATES
IDENTIFY NEW DATA IN TABLES
VERIFY THERE ARE NOT MISSING DATA IN BOTH TABLES

14
INTERSECT
COMMON ROWS IN TWO TABLES

15
16
ROW LEVEL FUNCTIONS
STRING FUNCTION

17
NUMBER FUNCTION

​​ ​

DATE & TIME FUNCTION


SQL Full Course for Beginners (30 Hours) – From Zero to Hero

18
NULL FUNCTION

NULL -> 0

CONCATENAR + NULL

MANIPULATE ID BEFORE JOIN TABLES

19
0 -> NULL NULLIF THIS IS TO DO DIVIDE

SCORE WITH OUT NULL

20
21
CASE STATEMENT

22
23
AGREGATION & ANALYTICAL FUNCTIONS
AGGREGATE FUNCTIONS

WINDOW

24

You might also like