WELCOME TO DITRP
CERTIFICATE IN MYSQL (DBA) ( C1180 )

BASIC INFORMATION

  • Course Duration : 3 MONTH

 SQL Language

 

Working with MYSQL Admin

 Working with PHP My

Admin

 Types Data Type

 Creating Database & Tables

 Dropping Database &

Tables

 Adding Fields

 Selecting Table

 Alerting Fields Properties

MySQL Function in PHP

 Database Connections

 Managing Database

Connections

 Performing Queries

 Closing Connection

SQL Queries

 Create Database & Table

 Drop Database & Table

 Insert Record

 Select Record

 Deleting Record

 ModifyingRecord

 WHERE Clause

 Using Operators

 Sorting Records

 Eliminating Duplicates

 Grouping Records, Having

Clause

 Joining Tables

 Sub queries

 Using Table And Column

Aliases

 

 

MYSQL