Price: AED 2,500

Duration: 20 Hours

Timing: Flexible

Course Overview

If you have heard about My SQL but never get a chance to learn then it is the right time to join and get this powerful skill. Our course makes it easier for you to get hands-on training as well as build up your database concepts.

It will allow you to learn about SQL Administration and setup new database confidently based on any specific requirement. On top you will learn how to design, setup and manage the SQL databases using one of the best tools called PHP my Admin, being used in the market. 

It is an interesting course and skill which allow you to manipulate or store the large volume of data in or of any organization and generate on-demand queries based on specific search criteria. 

In short, you will learn Database Setup and SQL Administration via

  • PHP my Admin
  • Command Console 

 

Course Outline

  1. What is Database?
  2. What is My SQL?
  3. Use of My SQL
  4. My SQL Statements
  5. What is XAMP & WAMP?
  6. Setting up XAMP/ WAMP
  7. What is PHP my Admin?
  8. Why PHP my Admin?
  9. How to Access PHP my Admin?
  10. Getting used to with PHP my Admin
  11. Basic SQL Statements
  12. Setting up Databases
  13. Listing the Database 
  14. Renaming/ Deleting Databases
  15. What are Tables, Rows & Columns?
  16. Listing the Database 
  17. What is Record?
  18. Renaming / Deleting Tables
  19. What is Table Field?
  20. Setting up new Fields
  21. Renaming/ Deleting Fields
  22. Editing Table Field
  23. What is Data Structure?
  24. Data Structure Types
  25. Defining Table Structure
  26. Editing Table Structure
  27. What is Primary Key?
  28. What is Index Key?
  29. Setting up Primary & Index Key?
  30. Auto Increment & Default Values
  31. Inserting Data into Tables
  32. Retrieving Data from Tables
  33. Updating Data into Tables
  34. Setting up Multiple Databases 
  35. Setting up Multiple Tables
  36. Viewing Tables, Update & Drop options
  37. Command Line / Console 
  38. SQL Statements 
  39. SQL Queries 
  40. Console / Command Prompt Statements & Queries 
  41. Insert Query via Console / Command Prompt
  42. Drop Query via Console / Command Prompt
  43. Update Query via Console/ Command Prompt
  44. Select Query via Console/ Command Prompt
  45. Database Backup via PHP my Admin
  46. Database Import via PHP my Admin
  47. Database Backup via Console/ Command Prompt 
  48. Database Import via Console/ Command Prompt
  49. Database Optimization

Related Courses