1. الدورات التعليمية
  2. MySQL Essential Training

MySQL Essential Training

كل ما يخص دورة تعلم MySQL الموجودة على الرابط التالي هنا

Intro And What Is MySQL ?
01
الدرس يحتوي على ملاحظات الدرس يحتوي على مراجع

The Needed Tools
02
الدرس يحتوي على ملاحظات

Syntax And Some Info
03

Connect With PDO And Examples
04
الدرس يحتوي على ملاحظات الدرس يحتوي على مراجع

Data Types – Numeric
05
الدرس يحتوي على مراجع

Data Types – Date And Time
06
الدرس يحتوي على مراجع

Data Types – String
07
الدرس يحتوي على مراجع

Deal With Databases
08

Tables Part 1 – Create, Drop, Show Status
09

Tables Part 2 – Rename, Change Type
10

Tables Part 3 – Alter
11

Tables Part 4 – Advanced
12

Constraint – Intro
13

Constraint – Not Null, Unique
14

Constraint – Primary Key
15

Constraint – Foreign Key – Intro
16

Constraint – Foreign Key – Test Relation
17

Constraint – Foreign Key – Update, Delete
18

Constraint – Foreign Key – One To One
19

Constraint – Foreign Key – One To Many
20

Constraint – Foreign Key – Many To Many
21

String Functions – Left, Right, Mid
22

String Functions – Length, Char_Length
23

String Functions – Upper, Lower
24

String Functions – Repeat, Reverse, Replace
25

String Functions – Concat, Concat_Ws
26

String Functions – Insert
27

String Functions – Trim, Ltrim, Rtrim
28

String Functions – LPad, RPad
29

Numeric Functions – Ceil, Floor, Round
30

Numeric Functions – Mod, Truncate, Pow
31

Date Functions – CurTime, CurDate, Now
32

Date Functions – Day, DayName
33

Date Functions – Month, Hour, Minute
34

Date Functions – Date Diff + Examples
35

Date Functions – Date Add, Date Sub, Last Day
36

Comparison Functions – Between And Not Between
37

Comparison Functions – In And Not In
38

Comparison Functions – Like And Not Like
39

Comparison Operators
40

Logical Operators – And, Or, Xor, Not
41

Control Flow – If
42

Control Flow – Case
43

Arithmetic Operators
44

Information Functions
45
الدرس يحتوي على مراجع

Group, Order And Having
46
الدرس يحتوي على مراجع

Simulation Of Join
47

Aliases In Deep
48

Inner Join
49

Left And Right Join
50

The End And References
51

التعليم والتجارب

النقاشات والنصائح

الشكر والدعم

عن الأكاديمية

Made With By Osama Elzero © 2021