MySQL Essential Training

Lessons 51

Total Time 8 Hours and 50 Minutes

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

Intro And What Is MySQL ?

11755

The Needed Tools

6119

Syntax And Some Info

4467

Connect With PDO And Examples

5252

Data Types – Numeric

3930

Data Types – Date And Time

3286

Data Types – String

3056

Deal With Databases

4887

Tables Part 1 – Create, Drop, Show Status

3422

Tables Part 2 – Rename, Change Type

3014

Tables Part 3 – Alter

3151

Tables Part 4 – Advanced

2838

Constraint – Intro

2753

Constraint – Not Null, Unique

2671

Constraint – Primary Key

2680

Constraint – Foreign Key – Intro

3043

Constraint – Foreign Key – Test Relation

2883

Constraint – Foreign Key – Update, Delete

2667

Constraint – Foreign Key – One To One

2578

Constraint – Foreign Key – One To Many

2588

Constraint – Foreign Key – Many To Many

2590

String Functions – Left, Right, Mid

2527

String Functions – Length, Char_Length

2328

String Functions – Upper, Lower

2348

String Functions – Repeat, Reverse, Replace

2404

String Functions – Concat, Concat_Ws

2439

String Functions – Insert

2541

String Functions – Trim, Ltrim, Rtrim

2368

String Functions – LPad, RPad

2314

Numeric Functions – Ceil, Floor, Round

2268

Numeric Functions – Mod, Truncate, Pow

2278

Date Functions – CurTime, CurDate, Now

2273

Date Functions – Day, DayName

2227

Date Functions – Month, Hour, Minute

2167

Date Functions – Date Diff + Examples

2222

Date Functions – Date Add, Date Sub, Last Day

2223

Comparison Functions – Between And Not Between

2206

Comparison Functions – In And Not In

2185

Comparison Functions – Like And Not Like

2135

Comparison Operators

2275

Logical Operators – And, Or, Xor, Not

2178

Control Flow – If

2200

Control Flow – Case

2268

Arithmetic Operators

2316

Information Functions

2229

Group, Order And Having

2511

Simulation Of Join

2434

Aliases In Deep

2292

Inner Join

2420

Left And Right Join

2427

The End And References

2579