AKELE CHAIN CHALE AAO | COVER SONG

001 MySQL : Introduction, Installation, Workbench, Command Shell.

002 MySQL : Creating Tables, Inserting Row, Selecting Rows, or Viewing Data of the Table

003 MySQL : Clause: Where, OrderBy Advance Insert, Create, Delete, Update, Rename, Drop, Truncate

004 MySQL : Group Function, Operators, Treating NULL values, Alter Command

005 MySQL: Alter Command: Drop, ModifyClause: GroupBy clause, Having clause

006 MySQL: Constraints: Column & Table Level, Primary Key, Foreign Key

007 MySQL: Foreign Key (with ON DELETE AND UPDATE OPTIONS), User-Defined Constraint

008 MySQL: Unique Key, NOT NULL, Check, Default Value Concept, Auto Increment Field, Enum Datatype.

009 MySQL: Dual Table, Distinct Keyword Scalar Functions: String, Numeric, Date, and Conversion.

010 MySQL: Distinct Keyword, Scalar Functions: Date, and Conversion Functions.

011 MySQL: Joins: Equi, Inner, Natural, Cross, Left, Right, Full Outer, Self. Set Operators

012 MySQL: Views: Creating Read-Only View, Updateable Views, Renaming Column, Destroying Views.