Data Analysis Using SQL

Introduction to the Topic:

What is PostgreSQL?

PostgreSQL is an advanced relational database system. PostgreSQL supports both relational (SQL) and non-relational (JSON) queries.It is a free and open-source relational database management system.

How I use PostgreSQL?

I used PostgreSQL to run SQL queries on a sample dataset

What is SQL?

SQL stands for Structured Query Language.
It is a special tool data professionals use to handle structured data (data stored in tables). It is also designed for stream processing in RDSMS

Which Queries were used to make the project?

Some of the Queries and their result are mentioned below:

List of all queries I learned to be able to do this project :

Here’s a list of the SQL queries mentioned:

1. CREATE

2. INSERT

3. UPDATE

4. ALTER

5. DELETE

6. DROP

7. TRUNCATE

8. DATATYPES in SQL

9. SELECT

10. DISTINCT

11. WHERE

12. LIKE

13. ORDER BY

14. LIMIT

15. TOP

16. AND

17. OR

18. NOT

19. IN

20. BETWEEN

21. SUM

22. MAX

23. MIN

24. COUNT

25. AVG

26. GROUP BY

27. HAVING

28. INNER JOIN

29. RIGHT JOIN

30. LEFT JOIN

31. OUTER JOIN

32. SELF JOIN

33. EXISTS

34. UNION

35. UNION ALL

36. DATE TIME FUNCTIONS

37. CTE (Common Table Expressions)

38. SUBQUERIES

39. CASE WHEN

40. WINDOW FUNCTIONS

    • ROW_NUMBER

    • RANK

    • DENSE_RANK

    • LEAD

    • LAG

    • NTILE

    • FIRST_VALUE

    • LAST_VALUE

41. AGGREGATE FUNCTIONS AS WINDOW FUNCTIONS