ماذا سأتعلم?
منهج الكورس
51 Lessons
08:50:40 Hours
مقدمة
4 Lessons
00:56:14 Hours
- Intro And What Is MySQL ? 00:08:18
- The Needed Tools 00:12:40
- Syntax And Some Info 00:14:51
- Connect With PDO And Examples 00:20:25
Data Types
4 Lessons
00:57:46 Hours
- Numeric 00:20:01
- Date And Time 00:09:30
- String 00:18:02
- Deal With Databases 00:10:13
Tables
4 Lessons
00:38:48 Hours
- Create, Drop, Show Status 00:14:38
- Rename, Change Type 00:04:42
- Alter 00:12:54
- Advanced 00:06:34
Constraint
9 Lessons
01:44:46 Hours
- Intro 00:05:27
- Not Null, Unique 00:10:10
- Primary Key 00:12:17
- Foreign Key – Intro 00:13:11
- Foreign Key – Test Relation 00:14:19
- Foreign Key – Update, Delete 00:14:22
- Foreign Key – One To One 00:06:30
- Foreign Key – One To Many 00:06:07
- Foreign Key – Many To Many 00:22:23
String Functions
8 Lessons
01:18:59 Hours
- Left, Right, Mid 00:08:18
- Length, Char_Length 00:06:24
- Upper, Lower 00:04:36
- Repeat, Reverse, Replace 00:10:12
- Concat, Concat_Ws 00:14:44
- Insert 00:11:46
- Trim, Ltrim, Rtrim 00:16:45
- LPad, RPad 00:06:14
Numeric Functions
2 Lessons
00:26:10 Hours
- Ceil, Floor, Round 00:11:40
- Mod, Truncate, Pow 00:14:30
Date Functions
5 Lessons
00:40:56 Hours
- CurTime, CurDate, Now 00:06:49
- Day, DayName 00:07:42
- Month, Hour, Minute 00:07:09
- Date Diff + Examples 00:07:32
- Date Add, Date Sub, Last Day 00:11:44
Comparison Functions
4 Lessons
00:48:05 Hours
- Between And Not Between 00:15:35
- In And Not In 00:07:00
- Like And Not Like 00:19:35
- Comparison Operators 00:05:55
Comparison Operators
11 Lessons
01:18:56 Hours
- Logical Operators – And, Or, Xor, Not 00:07:06
- Control Flow – If 00:08:43
- Control Flow – Case 00:10:22
- Arithmetic Operators 00:12:37
- Information Functions 00:05:38
- Group, Order And Having 00:08:38
- Simulation Of Join 00:08:11
- Aliases In Deep 00:05:24
- Inner Join 00:04:04
- Left And Right Join 00:04:54
- The End And References 00:03:19
المتطلبات
+ مشاهدة المزيد
وصف
+ مشاهدة المزيد
الكورسات الأخرى ذات الصلة
معلومات عن المدرب
- 5 المراجعات
- 785 طالب
- 252 الكورسات
+ مشاهدة المزيد
ادارة موقع افضل الكورسات
نسعى الى توفير الكورسات فى كافة المجاﻻت وبشكل مجانى
ملاحظات الطلاب
المراجعات
Write a public review