MySQL Database

shuruudaha kooraska -Daawo waa muhiim

Casharka 1aad – Introduction to DBMS

Casharka 2aad – RDBMS

Casharka 3aad – RDBMS Terminology

Casharka 4aad – RDBMS Terminology part2

Casharka 5aad – What is SQL

Casharka 6aad – What SQL can do

Casharka 7aad – What is MySQl

Casharka 8aad – Installing XAMPP Server

Casharka 9aad – Creating Database

Casharka 10aad – Deleting or Removing Database

Casharka 11aad – Creating Tables using MySQL GUI

Casharka 12aad – Creating Tables using SQL Statements

Casharka 13aad – Add and Drop Columns from Tables

Casharka 14aad – Removing or Deleting Tables

Casharka 15aad – Insert Record into Table using GUI

Casharka 16aad – Insert Record into Table using MySQL Statements

Casharka 17aad – Insert Record into Table using MySQL Statements part 2

Casharka 18aad – Insert Multiple Records into Tables

Casharka 19aad – Update Records in the Tables

Casharka 20aad – Select Record From Databases

Casharka 21aad – Delete Record from Tables

Casharka 22aad – Editing, Copying, Deleting, Selecting, and showing data in a Tables using GUI

Casharka 23aad – MySQL Where Clause

Casharka 24aad – MySQL Distinct Clause

Casharka 25aad – MySQL Order By Clause

Casharka 26aad – MySQL GROUP BY Clause

Casharka 27 – MySQL Having Clause

Casharka 35 aad – MySQL INNER JOINS

Casharka 36aad – LEFT JOIN

Casharka 37aad – Right Join

Casharka 38aad – Count Function

Casharka 39aad – SUM Function

Casharka 40aad – Average Function

Casharka 41aad – MIN() Function

Casharka 42aad – MAX() Function

Casharka 43aad – First() and Last() Functions