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