MySQL تعلم

و كيفية التعامل معها و مع الجداول و البيانات MySQL تعلم قاعدة بيانات

مبتدئ 0(0 التقييمات) 3 Students enrolled
Created by افضل الكورسات Last updated Fri, 11-Sep-2020 Arabic
ماذا سأتعلم?

منهج الكورس
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
  • Numeric 00:20:01
  • Date And Time 00:09:30
  • String 00:18:02
  • Deal With Databases 00:10:13
  • Create, Drop, Show Status 00:14:38
  • Rename, Change Type 00:04:42
  • Alter 00:12:54
  • Advanced 00:06:34
  • 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
  • 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
  • Ceil, Floor, Round 00:11:40
  • Mod, Truncate, Pow 00:14:30
  • 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
  • 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
  • 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
المتطلبات
+ مشاهدة المزيد
وصف


+ مشاهدة المزيد
الكورسات الأخرى ذات الصلة
03:03:21 Hours
Updated Thu, 05-Sep-2019
0 1 مجانا
01:22:53 Hours
0 1 مجانا
01:48:57 Hours
Updated Wed, 22-Apr-2020
0 2 مجانا
07:11:20 Hours
0 2 مجانا
04:09:55 Hours
0 1 مجانا
معلومات عن المدرب
  • 5 المراجعات
  • 785 طالب
  • 252 الكورسات
+ مشاهدة المزيد
ادارة موقع افضل الكورسات
نسعى الى توفير الكورسات فى كافة المجاﻻت وبشكل مجانى
ملاحظات الطلاب
0
متوسط تقييم
  • 0%
  • 0%
  • 0%
  • 0%
  • 0%
المراجعات
مجانا
Includes:
  • 08:50:40 Hours On demand videos
  • 51 Lessons
  • Access on mobile and tv
  • Full lifetime access