MySQL Essential Training

Lessons 51

Total Time 8 Hours and 50 Minutes

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

Intro And What Is MySQL ?

11876

The Needed Tools

6182

Syntax And Some Info

4520

Connect With PDO And Examples

5310

Data Types – Numeric

3968

Data Types – Date And Time

3318

Data Types – String

3100

Deal With Databases

4925

Tables Part 1 – Create, Drop, Show Status

3456

Tables Part 2 – Rename, Change Type

3047

Tables Part 3 – Alter

3182

Tables Part 4 – Advanced

2867

Constraint – Intro

2779

Constraint – Not Null, Unique

2695

Constraint – Primary Key

2712

Constraint – Foreign Key – Intro

3081

Constraint – Foreign Key – Test Relation

2913

Constraint – Foreign Key – Update, Delete

2696

Constraint – Foreign Key – One To One

2615

Constraint – Foreign Key – One To Many

2619

Constraint – Foreign Key – Many To Many

2622

String Functions – Left, Right, Mid

2555

String Functions – Length, Char_Length

2353

String Functions – Upper, Lower

2368

String Functions – Repeat, Reverse, Replace

2426

String Functions – Concat, Concat_Ws

2465

String Functions – Insert

2575

String Functions – Trim, Ltrim, Rtrim

2398

String Functions – LPad, RPad

2342

Numeric Functions – Ceil, Floor, Round

2298

Numeric Functions – Mod, Truncate, Pow

2303

Date Functions – CurTime, CurDate, Now

2302

Date Functions – Day, DayName

2255

Date Functions – Month, Hour, Minute

2191

Date Functions – Date Diff + Examples

2250

Date Functions – Date Add, Date Sub, Last Day

2247

Comparison Functions – Between And Not Between

2236

Comparison Functions – In And Not In

2216

Comparison Functions – Like And Not Like

2160

Comparison Operators

2297

Logical Operators – And, Or, Xor, Not

2205

Control Flow – If

2234

Control Flow – Case

2290

Arithmetic Operators

2350

Information Functions

2250

Group, Order And Having

2539

Simulation Of Join

2460

Aliases In Deep

2320

Inner Join

2448

Left And Right Join

2464

The End And References

2609