MySQL Essentials 5.0 | Osama Mohamed
Free
-
MySQL Essentials 5.0 | Osama Mohamed
- Intro & Whats MySQL ?
- The Needed Tools
- Syntax & Some Info
- Connect With PDO + Examples
- Data Type – Numeric
- Data Type – Date & Time
- Data Type – String
- Deal With Databases
- Tables – Create, Drop, Show Status
- Tables – Rename, Change Type
- Tables – Alter
- Tables – Advanced
- Constraint – Intro
- Constraint – Not Null, Unique
- Constraint – Primary Key
- Constraint – Foreign Key Intro
- Constraint – Foreign Key Test Relation
- Constraint – Foreign Key Update, Delete
- Constraint – Foreign Key One To One
- Constraint – Foreign Key One To Many
- Constraint – Foreign Key Many To Many
- String Functions – Left, Right, Mid
- String Functions – Length, Char_Length
- String Functions – Upper, Lower
- String Functions – Repeat, Reverse, Replace
- String Functions – Concat, Concat_Ws
- String Functions – Insert
- String Functions – Trim, Rtrim, Ltrim
- String Functions – LPad, RPad
- Numeric Functions – Ceil, Floor, Round
- Numeric Functions – Mod, Truncate, Pow
- Date Functions – Curtime, Curdate, Now
- Date Functions – Day, Dayname
- Date Functions – Month, Hour, Minute
- Date Functions – DateDiff + Examples
- Date Functions – Date_Add, Date_Sub, Last_Day
- Comparison Functions – Between And Not Between
- Comparison Functions – In, Not In
- Comparison Functions – Like, Not Like
- Comparison Operators
- Logical Operators – And, Or, Xor, Not
- Control Flow Functions – If
- Control Flow Functions – Case
- Arithmetic Operators
- Information Functions
- Group Order And Having
- Simulation Of Join
- Alias In Deep
- Inner Join
- Left And Right Join
- The End And References
