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.
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.