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

AhmedElmalla7 13 views 46 slides Jun 10, 2024
Slide 1
Slide 1 of 46
Slide 1
1
Slide 2
2
Slide 3
3
Slide 4
4
Slide 5
5
Slide 6
6
Slide 7
7
Slide 8
8
Slide 9
9
Slide 10
10
Slide 11
11
Slide 12
12
Slide 13
13
Slide 14
14
Slide 15
15
Slide 16
16
Slide 17
17
Slide 18
18
Slide 19
19
Slide 20
20
Slide 21
21
Slide 22
22
Slide 23
23
Slide 24
24
Slide 25
25
Slide 26
26
Slide 27
27
Slide 28
28
Slide 29
29
Slide 30
30
Slide 31
31
Slide 32
32
Slide 33
33
Slide 34
34
Slide 35
35
Slide 36
36
Slide 37
37
Slide 38
38
Slide 39
39
Slide 40
40
Slide 41
41
Slide 42
42
Slide 43
43
Slide 44
44
Slide 45
45
Slide 46
46

About This Presentation

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


Slide Content

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

Memory Chunking illustration

What is Memory Chunking ?

How to build Memory Chunks?

Book Index

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 ?

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

Memory consolidation

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

Activate Diffuse Mode

Benefits of the Diffuse Mode

Resources Access

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

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

Slides location on Google Drive

Class Recording

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

Focus of the Class

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

Different DBMS

Create DB in Oracle, SQL Server and MySQL

Parch & Posey Database

Table & Columns

Data Visualization

Database and SQl Glossary 1

Database and SQl Glossary 2

Database and SQl Glossary 3

Schema

Database System

Client vs Database

Table

Rows & Columns

SQL Select

SQL JOIN

SQL SUM & Having

Questions on Database and SQl

Database and SQl - Answers 1-3

Database and SQl - Answers

Database and SQl Glossary

Database and SQl - Answers 7-9

Database and SQl - Answers 10

Database and SQl - Answers 10

Database and SQl Glossary

Database and SQl - Answers

Database and SQl - Answers 15

ERD