SQL Demo Class by a Computer Tutor from Malaysia - Ahmed Elmalla

An Introduction Class into SQL usage in Data Analysis.

Slides prepared by Tutor Ahmed Elmalla

WhatsApp: https://wa.me/message/SGE2FIFHJBCUC1

https://www.facebook.com/igcseCStutor

https://www.youtube.com/@tutorAL9618

https://www.teacheron.com/tutor-profile/6ZTs?r=6ZTs

1. SQL Demo 1.1
Ahmed Elmalla
https://elmallla.info

2. Memory Chunking illustration

3. What is Memory Chunking ?

4. How to build Memory Chunks?

5. Book Index

6. Memory Index
Do you know what is the
Hippocampus ?

Why is it essential for teachers to
take 1 or 2 min of silence every
10 to 15 min ?

7. Information consolidation in the brain
What is memory consolidation ? And when does it happen ?

8. Memory consolidation

9. How to find a solution to a problem ?
Can you control the mode of your
brain ?

10. Activate Diffuse Mode

11. Benefits of the Diffuse Mode

12. Resources Access

13. Class Recording
https://elmalla.info/blog/84-comp
uter-class-resources

14. Class slides
https://elmalla.info/blog/78-comp
uter-class-resources

15. Slides location on Google Drive

16. Class Recording

17. Register An account on Replit
https://replit.com/

18. Focus of the Class

19. 1)ERD diagrams
2)SQL Basic Commands (where, not, in , between, and / or)
3)SQL joins (Foreign keys, Alias, left join, right join)
4)Descriptive statistics
5)SQL Aggregations (sum, avg,count,case, having)
6)SQL subqueries and temp tables
7)SQL data cleaning
8)Data Visualization

20. Different DBMS

21. Create DB in Oracle, SQL Server and MySQL

22. Parch & Posey Database

23. Table & Columns

24. Data Visualization

25. Database and SQl Glossary 1

26. Database and SQl Glossary 2

27. Database and SQl Glossary 3

28. Schema

29. Database System

30. Client vs Database

31. Table

32. Rows & Columns

33. SQL Select

34. SQL JOIN

35. SQL SUM & Having

36. Questions on Database and SQl

37. Database and SQl - Answers 1-3

38. Database and SQl - Answers

39. Database and SQl Glossary

40. Database and SQl - Answers 7-9

41. Database and SQl - Answers 10

42. Database and SQl - Answers 10

43. Database and SQl Glossary

44. Database and SQl - Answers

45. Database and SQl - Answers 15

46. ERD