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 © 2023