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

State management across requests is essential when an application must remember user-specific data on the server side. The section explains the session mechanism in PHP, including how sessions are started and ended, how variables are stored, and how implementation works in practice.

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

2. Interrupt instructions for flow control in loops in PHP

Controlling execution inside loops and packaging logic into reusable functions are two core coding practices in PHP. This module explains break and continue, then moves to function structure, parameters, returning results, and calling conventions to make procedural code easier to manage.

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

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

PHP object-oriented design is covered through the structures that define how code is organized and reused. Participants work with classes, objects, constructors, destructors, inheritance, access modifiers, and exceptions to understand how behavior and responsibility are modeled in applications.

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

4. Detailed discussion of working with strings in PHP

Text processing in PHP often involves several operations within the same workflow rather than isolated functions. This section brings together formatting, comparison, searching, and transformation of strings so participants can handle typical input and output tasks in application code.

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

5. Cookies – tracking information about the user between sessions

Cookies support persistence between visits by storing small pieces of user-related data on the client side. The training explains what cookies are, how they are written, read, and removed in PHP, and how they differ from server-side session-based state handling.

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

6. Introduction to basic concepts in MySQL

MySQL work starts with a clear understanding of how data is organized and connected. This section establishes the core concepts of schemas and relationships, giving participants the relational context needed for later work with querying, integrity rules, and database design decisions.

  • schemas,
  • relationships.

7. Examples of using the UPDATE command in MySQL

Updating existing rows is presented through practical SQL patterns used to change data accurately and consistently. The material focuses on constructing UPDATE statements, applying conditions to target the right records, and managing modifications without affecting unintended rows.

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

Deleting records safely demands more than knowing the DELETE syntax. This part explains how to remove data from tables with proper conditions, how to limit the scope of deletion, and how to avoid unintended loss when operating on production-like datasets.

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

Retrieving data with SELECT involves more than choosing columns from a table. The section connects filtering, pattern matching, ranges, logical conditions, existence checks, ordering, limiting, grouping, and post-aggregation filtering so participants can build precise and efficient result sets.

  • 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

Views provide an abstraction layer over stored queries and help present data in a reusable form. Participants learn how CREATE VIEW is used to encapsulate query logic, simplify access to selected fields, and expose consistent result sets without duplicating SQL in many places.

11. Triggers (triggers) in MySQL

Triggers let MySQL execute defined logic automatically in response to data modifications. This section covers the role of triggers in controlling database-side behavior, typical use cases tied to insert, update, or delete events, and the implications of placing business rules inside the database.

12. Foreign keys (FOREIGN KEY)

At the schema level, foreign keys enforce relationships between tables and protect referential integrity during data changes. The training explains how FOREIGN KEY constraints are defined, how they support consistent relational models, and what impact they have on insert, update, and delete operations.

13. Indexes for accelerating operations on large data sets

Indexes directly affect query speed when tables grow and filtering, sorting, or joining become expensive. This module explains how indexing supports access paths on large data sets, what trade-offs it introduces, and how to choose indexes that match real query patterns.

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

NULL in MySQL requires separate handling because it does not behave like a regular value in comparisons or conditions. The section focuses on checking for missing data, building reliable predicates, and avoiding logic errors caused by incorrect assumptions about empty fields.

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

Duplicate rows can distort reports, counts, and downstream processing, especially after joins or broad selections. Here the role of DISTINCT is clarified, including when it should be applied, what effect it has on returned data, and how it differs from grouping operations.

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

Combining result sets from multiple queries is useful when data comes from comparable sources or must be merged into one output. Participants work with UNION syntax, column compatibility rules, and practical cases where separate SELECT statements form a consistent result.

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

When a subquery depends on values from the current row, both correctness and performance require careful design. This part works through correlated subqueries, shows typical construction patterns, and explains optimization choices that reduce repeated evaluation costs.

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

Derived tables in the FROM clause are used to build intermediate result sets that can be filtered, grouped, and joined like regular tables. The section explains when this structure improves query clarity and how to organize nested logic without duplicating SQL fragments.

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.