MySQL Essential Training

Lessons 51

Total Time 8 Hours and 50 Minutes

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

Intro And What Is MySQL ?

11998

The Needed Tools

6231

Syntax And Some Info

4563

Connect With PDO And Examples

5354

Data Types – Numeric

4001

Data Types – Date And Time

3351

Data Types – String

3133

Deal With Databases

4970

Tables Part 1 – Create, Drop, Show Status

3491

Tables Part 2 – Rename, Change Type

3083

Tables Part 3 – Alter

3229

Tables Part 4 – Advanced

2902

Constraint – Intro

2805

Constraint – Not Null, Unique

2731

Constraint – Primary Key

2742

Constraint – Foreign Key – Intro

3116

Constraint – Foreign Key – Test Relation

2942

Constraint – Foreign Key – Update, Delete

2722

Constraint – Foreign Key – One To One

2645

Constraint – Foreign Key – One To Many

2648

Constraint – Foreign Key – Many To Many

2657

String Functions – Left, Right, Mid

2580

String Functions – Length, Char_Length

2376

String Functions – Upper, Lower

2394

String Functions – Repeat, Reverse, Replace

2455

String Functions – Concat, Concat_Ws

2487

String Functions – Insert

2600

String Functions – Trim, Ltrim, Rtrim

2422

String Functions – LPad, RPad

2371

Numeric Functions – Ceil, Floor, Round

2319

Numeric Functions – Mod, Truncate, Pow

2326

Date Functions – CurTime, CurDate, Now

2322

Date Functions – Day, DayName

2282

Date Functions – Month, Hour, Minute

2209

Date Functions – Date Diff + Examples

2272

Date Functions – Date Add, Date Sub, Last Day

2273

Comparison Functions – Between And Not Between

2256

Comparison Functions – In And Not In

2235

Comparison Functions – Like And Not Like

2180

Comparison Operators

2319

Logical Operators – And, Or, Xor, Not

2228

Control Flow – If

2260

Control Flow – Case

2315

Arithmetic Operators

2370

Information Functions

2272

Group, Order And Having

2558

Simulation Of Join

2483

Aliases In Deep

2348

Inner Join

2478

Left And Right Join

2493

The End And References

2636