Curriculum
- 1 Section
- 51 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- MySQL Essentials 5.0 | Osama Mohamed51
- 2.1Intro & Whats MySQL ?9 Minutes
- 2.2The Needed Tools13 Minutes
- 2.3Syntax & Some Info15 Minutes
- 2.4Connect With PDO + Examples21 Minutes
- 2.5Data Type – Numeric20 Minutes
- 2.6Data Type – Date & Time10 Minutes
- 2.7Data Type – String18 Minutes
- 2.8Deal With Databases11 Minutes
- 2.9Tables – Create, Drop, Show Status15 Minutes
- 2.10Tables – Rename, Change Type5 Minutes
- 2.11Tables – Alter13 Minutes
- 2.12Tables – Advanced7 Minutes
- 2.13Constraint – Intro6 Minutes
- 2.14Constraint – Not Null, Unique11 Minutes
- 2.15Constraint – Primary Key13 Minutes
- 2.16Constraint – Foreign Key Intro14 Minutes
- 2.17Constraint – Foreign Key Test Relation15 Minutes
- 2.18Constraint – Foreign Key Update, Delete15 Minutes
- 2.19Constraint – Foreign Key One To One7 Minutes
- 2.20Constraint – Foreign Key One To Many7 Minutes
- 2.21Constraint – Foreign Key Many To Many23 Minutes
- 2.22String Functions – Left, Right, Mid9 Minutes
- 2.23String Functions – Length, Char_Length7 Minutes
- 2.24String Functions – Upper, Lower5 Minutes
- 2.25String Functions – Repeat, Reverse, Replace11 Minutes
- 2.26String Functions – Concat, Concat_Ws15 Minutes
- 2.27String Functions – Insert12 Minutes
- 2.28String Functions – Trim, Rtrim, Ltrim17 Minutes
- 2.29String Functions – LPad, RPad7 Minutes
- 2.30Numeric Functions – Ceil, Floor, Round12 Minutes
- 2.31Numeric Functions – Mod, Truncate, Pow15 Minutes
- 2.32Date Functions – Curtime, Curdate, Now7 Minutes
- 2.33Date Functions – Day, Dayname8 Minutes
- 2.34Date Functions – Month, Hour, Minute8 Minutes
- 2.35Date Functions – DateDiff + Examples8 Minutes
- 2.36Date Functions – Date_Add, Date_Sub, Last_Day12 Minutes
- 2.37Comparison Functions – Between And Not Between16 Minutes
- 2.38Comparison Functions – In, Not In7 Minutes
- 2.39Comparison Functions – Like, Not Like20 Minutes
- 2.40Comparison Operators6 Minutes
- 2.41Logical Operators – And, Or, Xor, Not8 Minutes
- 2.42Control Flow Functions – If9 Minutes
- 2.43Control Flow Functions – Case11 Minutes
- 2.44Arithmetic Operators13 Minutes
- 2.45Information Functions6 Minutes
- 2.46Group Order And Having9 Minutes
- 2.47Simulation Of Join9 Minutes
- 2.48Alias In Deep6 Minutes
- 2.49Inner Join5 Minutes
- 2.50Left And Right Join5 Minutes
- 2.51The End And References4 Minutes
Course Features
- Lectures 51
- Quiz 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 162
- Assessments Yes