Php-Mysql Course

PHP and MYSQL Course in Maadi, Cairo, Egypt For Beginners

شارك على

خصائص الكورس

  • عدد الساعات : 100 ساعة
  • مدة الكورس : 9 اسبوع
  • عدد المحاضرات : 3 لكل اسبوع
  • استثمر الأن

الهدف من الكورس

PHP& MySQL qualify you to be backend web developer, analyize Database and understand ERD, building it using MySQL and how to connect it.

Learn how to implement CRUD funstions foreach table using forms and AJAX&JSON

محتوى الكورس

  1. Introduction and fundamentals
    1. Client side VS Server side
    2. Installing PHP Environment tools
    3. PHP data types and variables.
    4. Printing functions.
    5. PHP Operators.
  2. PHP Control statements
    1. Conditional statements.
      1. If-else
      2. switch
    2. Repetition statements "Loops".
      1. While
      2. For
  3. PHP Arrays and foreach
    1. Indexed and associative arrays
    2. Multi-dimensional arrays
    3. Array's Functions.
    4. Foreach loop
  4. PHP Forms
    1. PHP Form handling.
    2. File uploading.
    3. XSS filtering
  5. MySQL
    1. Intro to the history of database
    2. Difference between DBMS, DB and SQL
    3. DDL "Data Definition Language"
      1. How to design Database and designing ERD "Entity Relationship Diagram"
      2. How to create, alter and drop the tables using phpmyadmin
    4. DML "Data Manipulation Language"
      1. Study insert, update and delete statements
      2. Study select statement
        1. Select types
        2. How to search in database
        3. Condition operators
        4. Sorting data
        5. Aggregation functions
        6. Joins
  6. How to connect PHP with MYSQL
    1. Understand the lifecycle of connection
    2. Difference between MYSQL, MYSQLI and PDO
    3. Implement CRUD functions for tables
  7. Using ready backend template and organizing code
    1. Backend VS frontend
    2. How to organize project folders
    3. How to download backend template and organizing it.
  8. Workshop 1 " full day of working"
    1. Creating database scheme
    2. Implementing CRUD functions for tables from scratch
    3. How to save file in database
  9. PHP Functions 
    1. User defined and built-in functions
    2. Creation of functions
    3. Variable scope
  10. PHP Strings Handling 
    1. Strings and Patterns.
    2. Matching, Extracting.
    3. Searching Replacing
  11. OOP [Object Oriented Concepts]
    1. Understanding the theory of OOP
    2. Understanding Encapsulation
    3. Inheritance
    4. Polymorphism
    5. Abstraction
  12. PHP Cookies & PHP Sessions
    1. PHP Cookie handling.
    2. PHP Session Handling.
  13. PHP AJAX and JSON
    1. Submit form using AJAX and JSON
  14. MVC and forms validation
    1. Building semi MVC structure
    2. How to validate form's inputs
  15. Workshop 2 "full day of working"
    1. Building full web application
    2. Linking between frontend and backend
  16. Frameworks
    1. Types of ready PHP scripts
      1. Most common CMS in PHP
      2. Most common frameworks in PHP
    2. Full study for framework " Laravel or Yii2 according to students' need"
      1. Understanding framework structure
      2. Understanding routing
      3. Building controllers
      4. Building models and validations
      5. Building views
      6. How to use composer
      7. Building full application
  17. Workshop 3 "building web app using framework"
    1. Dividing students to teams
    2. Each team accomplishes full web app
  18. Hosting
    1. Domain VS Hosting
    2. How to book a domain?
    3. How to purchase a hosting?
    4. how to publish your web site
استثمر الأن