Structured Query Language presentation v2.pptx

SQL- This presentation is for beginners who wanted to dive deep into the world of data analysis.
It teaches you how to extract data from the database.

1. SQL Structured Query Language

2. WHAT IS DATA AND DATABASE Data is raw facts and figures. Has little meaning until sorted, classified or organized. It can be text, numbers, media etc. Database is organized collection of data so that it can be easily accessed. It is generally organized in rows and columns. Main purpose is to store large data. E.g.- My SQL, Oracle, MongoDB, SQL Server etc.

3. Advantages of a Database

4. SQL

5. SELECT STATEMENT - CONDITIONAL

6. INSERT IN SELECTIVE COLUMNS

7. Select statement

8. SELECT STATEMENT CONDITIONAL

9. SELECT STATEMENT – ‘AND’ OPERATOR

10. SELECT STATEMENT – VIEW PARTICULAR COLUMN(S)

11. SELECT STATEMENT WITH > THAN OPERATOR

12. SELECT STATEMENT - BETWEEN

13. SELECT STATEMENT – OR OPERATOR

14. SELECT STATEMENT - DISTINCT

15. SELECT STATEMENT – IN/NOT IN

16. SELECT STATEMENT - LIKE

17. SELECT STATEMENT USING ‘IN’

18. ALTER TABLE

19. UPDATE STATEMENT

20. JOINS

21. (INNER) JOIN Returns records that have matching values in both tables

22. LEFT(OUTER) JOIN Returns all records from the left table, and the matched records from the right table

23. RIGHT OUTER JOIN Returns all records from the right table, and the matched records from the left table

24. FULL(OUTER) JOIN Returns all records when there is a match in either left or right table

25. GROUP BY STATEMENT

26. GROUP BY STATEMENT continued

27. GROUP BY STATEMENT+HAVING CLAUSE