Working with MySQL Admin

·        Working with PHP My Admin

·        Creating Databases

·        Types of Databases

·        Creating Tables in Database

·        Specifying Field Data Types

·        Selecting the Most Appropriate Data Type

·        Adding Field Modifiers and Keys

·        Selecting a Table Type Altering Tables

·        Altering Table and Field Names

·        Altering Field Properties

·        Adding and Removing Fields and Keys

·        Altering Table Types

·        Backing Up and Restoring Databases and Tables

·        Backing Up Databases and Tables

·        Restoring Databases and Tables from Backup

·        Dropping Databases and Tables

·        Viewing Database, Table, and Field Information

SQL Queries

·        Inserting Records

·        Editing and Deleting Records

·        Performing Queries

·        Retrieving Specific Columns

·        Filtering Records with a WHERE Clause

·        Using Operators

·        Sorting Records and Eliminating Duplicates

·        Limiting Results

·        Using Built-In Functions

·        Grouping Records

·        Joining Tables

·        Using Subqueries

·        Using Table and Column Aliases

Arrays and Array Functions

·        Why use Arrays

·        Types of Arrays

·        Creating Arrays

·        Accessing Arrays

·        Array Functions

·        Using Array Function