MySQL Essential Training

Lessons 51

Total Time 8 Hours and 50 Minutes

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

Intro And What Is MySQL ?

11607

The Needed Tools

6058

Syntax And Some Info

4425

Connect With PDO And Examples

5210

Data Types – Numeric

3907

Data Types – Date And Time

3256

Data Types – String

3032

Deal With Databases

4854

Tables Part 1 – Create, Drop, Show Status

3397

Tables Part 2 – Rename, Change Type

2995

Tables Part 3 – Alter

3129

Tables Part 4 – Advanced

2818

Constraint – Intro

2738

Constraint – Not Null, Unique

2649

Constraint – Primary Key

2664

Constraint – Foreign Key – Intro

3023

Constraint – Foreign Key – Test Relation

2863

Constraint – Foreign Key – Update, Delete

2650

Constraint – Foreign Key – One To One

2559

Constraint – Foreign Key – One To Many

2569

Constraint – Foreign Key – Many To Many

2567

String Functions – Left, Right, Mid

2503

String Functions – Length, Char_Length

2310

String Functions – Upper, Lower

2323

String Functions – Repeat, Reverse, Replace

2384

String Functions – Concat, Concat_Ws

2420

String Functions – Insert

2522

String Functions – Trim, Ltrim, Rtrim

2350

String Functions – LPad, RPad

2299

Numeric Functions – Ceil, Floor, Round

2251

Numeric Functions – Mod, Truncate, Pow

2263

Date Functions – CurTime, CurDate, Now

2258

Date Functions – Day, DayName

2206

Date Functions – Month, Hour, Minute

2152

Date Functions – Date Diff + Examples

2206

Date Functions – Date Add, Date Sub, Last Day

2209

Comparison Functions – Between And Not Between

2186

Comparison Functions – In And Not In

2169

Comparison Functions – Like And Not Like

2119

Comparison Operators

2261

Logical Operators – And, Or, Xor, Not

2154

Control Flow – If

2185

Control Flow – Case

2252

Arithmetic Operators

2297

Information Functions

2210

Group, Order And Having

2493

Simulation Of Join

2413

Aliases In Deep

2274

Inner Join

2401

Left And Right Join

2407

The End And References

2552