CERTIFICATE IN MYSQL     (Duration 3 / 6 Months)

MYSQL DATABASE

  • Understanding a Relational Database
  • Introduction to MySQL Database
  • Understanding Tables, Records and Fields
  • Understanding Primary and Foreign Keys
  • Understanding SQL and SQL Queries
  • Understanding Database Normalization
  • Dealing with Dates and Times
  • Executing External Programs

WORKING WITH MYSQL DATABASE & TABLES

  • Creating MySQL Databases
  • Creating Tables
  • Selecting the Most Appropriate Data Type
  • Adding Field Modifiers and Keys
  • Selecting a Table Type
  • Understanding Database Normalization
  • Altering Table and Field Names
  • Altering Field Properties
  • Backing Up and Restoring Databases and Tables
  • Dropping Databases and Table Viewing Database, Table, and Field Information

SQL & PERFORMING 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 Table and Column Aliases

WORKING WITH PHP & MYSQL

  • Managing Database Connections
  • Processing Result Sets
  • Queries Which Return Data
  • Queries That Alter Data
  • Handling Errors