icon icon

PHP and MySQL for developers – functions and characters, operations and MySQL queries

icon

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

icon

Sharper PHP flow control - You will learn to use break, continue, and custom functions with purpose, so you can simplify complex loops, reduce duplicated code, and introduce changes to applications much faster.

icon

Better handling of user state - You will master sessions and cookies in real scenarios, which will help you implement login flows, preserve user state, remember preferences, and properly close work with stored data.

icon

Cleaner object-oriented code - You will see how to design classes, objects, and inheritance in PHP so your code becomes easier to extend, test, and maintain, especially when working on larger team-based projects.

icon

More reliable string processing - You will practice formatting, comparing, searching, and processing strings, so you can handle user input, search filters, and content generation in your applications with more confidence.

icon

Stronger SELECT queries - You will learn to build advanced queries with ORDER BY, GROUP BY, HAVING, LIKE, BETWEEN, IN, and EXISTS, so you can retrieve data precisely and respond better to business needs.

icon

Safer data modification - You will understand how to use UPDATE and DELETE safely and how to work with NULL, DISTINCT, and UNION, helping you avoid data operation mistakes and improve result quality.

icon

Consistent database design - You will work with schemas, relationships, and foreign keys, allowing you to design cleaner database structures, protect data integrity, and avoid issues caused by inconsistent table links.

icon

Better MySQL performance - You will master views, triggers, indexes, correlated subqueries, and subqueries in FROM, so you can speed up reporting, automate logic, and improve overall query performance.

Training programme

1. Session overview

  • mechanism,
  • starting,
  • ending,
  • variables,
  • implementation.

2. Interrupt instructions for flow control in loops in PHP

  • Break,
  • Continue,
  • functions:
    • structure,
    • parameters,
    • returning the result,
    • call.

3. Discussion of the principles of object-oriented programming (OOP) in PHP

  • classes,
  • objects,
  • constructor,
  • destructor,
  • inheritance,
  • access modifiers,
  • exceptions.

4. Detailed discussion of working with strings in PHP

  • formatting,
  • comparing,
  • searching,
  • processing.

5. Cookies – tracking information about the user between sessions

  • what are Cookies?
  • saving to Cookies,
  • reading Cookies,
  • deleting Cookies.

6. Introduction to basic concepts in MySQL

  • schemas,
  • relationships.

7. Examples of using the UPDATE command in MySQL

8. Detailed explanation of how to use the DELETE statement in MySQL to delete data from tables

9. Practical application of the SQL SELECT query in MySQL for retrieving records from tables

  • ORDER BY clause,
  • LIMIT clause,
  • GROUP BY clause,
  • HAVING clause,
  • LIKE clause,
  • BETWEEN clause,
  • AND, OR clause,
  • EXISTS, NOT EXISTS clause,
  • IN clause.

10. Discussion of creating views in MySQL using the CREATE VIEW command

11. Triggers (triggers) in MySQL

12. Foreign keys (FOREIGN KEY)

13. Indexes for accelerating operations on large data sets

14. Discussion of handling empty values (NULL) in MySQL

15. Explanation of the use of the DISTINCT keyword in MySQL

16. Examples of using the UNION operator in MySQL to combine the results of two or more queries

17. Correlated subqueries – detailed examples of how to create and optimize correlated subqueries

18. Discussion of the use of subqueries in the FROM clause in MySQL

What are the prerequisites for participating in the training?

icon

PHP syntax basics - You should be comfortable writing simple PHP scripts and using variables, conditionals, and loops, so during the training you can focus on more advanced development topics.

icon

Basic MySQL skills - You should understand basic database operations and know what tables, records, and simple SQL queries are, so you can move smoothly into more advanced query structures.

icon

Application building practice - You should have some hands-on experience building simple applications or web modules, so the examples related to PHP logic and database work feel natural and practical to you.

icon

Procedural PHP understanding - You should be able to read and modify procedural PHP code, because the training builds on that foundation and extends it into functions, data handling, sessions, and OOP.