MySQL Essential Training

Lessons 51

Total Time 8 Hours and 50 Minutes

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

Intro And What Is MySQL ?

11486

The Needed Tools

6021

Syntax And Some Info

4387

Connect With PDO And Examples

5167

Data Types – Numeric

3887

Data Types – Date And Time

3236

Data Types – String

3020

Deal With Databases

4825

Tables Part 1 – Create, Drop, Show Status

3375

Tables Part 2 – Rename, Change Type

2972

Tables Part 3 – Alter

3115

Tables Part 4 – Advanced

2795

Constraint – Intro

2725

Constraint – Not Null, Unique

2636

Constraint – Primary Key

2655

Constraint – Foreign Key – Intro

3009

Constraint – Foreign Key – Test Relation

2852

Constraint – Foreign Key – Update, Delete

2635

Constraint – Foreign Key – One To One

2547

Constraint – Foreign Key – One To Many

2551

Constraint – Foreign Key – Many To Many

2554

String Functions – Left, Right, Mid

2494

String Functions – Length, Char_Length

2302

String Functions – Upper, Lower

2312

String Functions – Repeat, Reverse, Replace

2372

String Functions – Concat, Concat_Ws

2406

String Functions – Insert

2513

String Functions – Trim, Ltrim, Rtrim

2337

String Functions – LPad, RPad

2287

Numeric Functions – Ceil, Floor, Round

2233

Numeric Functions – Mod, Truncate, Pow

2246

Date Functions – CurTime, CurDate, Now

2241

Date Functions – Day, DayName

2190

Date Functions – Month, Hour, Minute

2141

Date Functions – Date Diff + Examples

2193

Date Functions – Date Add, Date Sub, Last Day

2195

Comparison Functions – Between And Not Between

2182

Comparison Functions – In And Not In

2158

Comparison Functions – Like And Not Like

2105

Comparison Operators

2249

Logical Operators – And, Or, Xor, Not

2143

Control Flow – If

2179

Control Flow – Case

2239

Arithmetic Operators

2285

Information Functions

2197

Group, Order And Having

2485

Simulation Of Join

2405

Aliases In Deep

2258

Inner Join

2390

Left And Right Join

2396

The End And References

2537