MySQL Essential Training

Lessons 51

Total Time 8 Hours and 50 Minutes

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

Intro And What Is MySQL ?

11354

The Needed Tools

5962

Syntax And Some Info

4338

Connect With PDO And Examples

5133

Data Types – Numeric

3858

Data Types – Date And Time

3210

Data Types – String

2992

Deal With Databases

4788

Tables Part 1 – Create, Drop, Show Status

3354

Tables Part 2 – Rename, Change Type

2946

Tables Part 3 – Alter

3092

Tables Part 4 – Advanced

2770

Constraint – Intro

2704

Constraint – Not Null, Unique

2612

Constraint – Primary Key

2630

Constraint – Foreign Key – Intro

2978

Constraint – Foreign Key – Test Relation

2827

Constraint – Foreign Key – Update, Delete

2610

Constraint – Foreign Key – One To One

2529

Constraint – Foreign Key – One To Many

2526

Constraint – Foreign Key – Many To Many

2536

String Functions – Left, Right, Mid

2471

String Functions – Length, Char_Length

2284

String Functions – Upper, Lower

2298

String Functions – Repeat, Reverse, Replace

2357

String Functions – Concat, Concat_Ws

2377

String Functions – Insert

2496

String Functions – Trim, Ltrim, Rtrim

2317

String Functions – LPad, RPad

2267

Numeric Functions – Ceil, Floor, Round

2216

Numeric Functions – Mod, Truncate, Pow

2228

Date Functions – CurTime, CurDate, Now

2221

Date Functions – Day, DayName

2172

Date Functions – Month, Hour, Minute

2118

Date Functions – Date Diff + Examples

2169

Date Functions – Date Add, Date Sub, Last Day

2167

Comparison Functions – Between And Not Between

2162

Comparison Functions – In And Not In

2133

Comparison Functions – Like And Not Like

2087

Comparison Operators

2231

Logical Operators – And, Or, Xor, Not

2126

Control Flow – If

2163

Control Flow – Case

2221

Arithmetic Operators

2256

Information Functions

2179

Group, Order And Having

2462

Simulation Of Join

2379

Aliases In Deep

2239

Inner Join

2361

Left And Right Join

2368

The End And References

2517