A thorough course in PHP and MySQL and PostgreSQL databases.
- 3-months long; groups of 5-12 people,
- professional programmers teach their craft,
- the students create their own projects,
- course programme conforms to job market demands,
- an opportunity for acquiring Zend Certified Engineer certificate, the most important PHP certificate in the world (for interested students),
- 1140 EUR
- instalment payment plans available for private persons
more information here
Our course is intended for those who:
- want to find a good job in web development,
- want to learn the ins and outs of WWW,
- already work as IT specialists, but want to raise their qualifications.
Requirements: we do not require enrolling students to know any programming language - good familiarity with Windows is sufficient (proficiency with the system itself, office suites and the Internet).
Valuable knowledge and skills
download detailed course programme >>
Programming is one skill that cannot be mastered only through theory or from books. We focus our training on practical exercises - the students write simple scripts already during the first class, and later progress towards more and more complicated programs. Everything happens under the supervision of experienced programmers, so that the students can form good programming habits from the very beginning.
- an easier course: creating web pages (HTML, CSS, graphics), minimal programming involved
» Webmaster - further studying: expanding programming knowledge
» Advanced Web Developer (object-oriented PHP, JS, AJAX, ActionScript)
The course teaches not only PHP and SQL programming, but also:
- teaches good software engineering practices,
- presents analyses of large, professional applications,
- discusses security and attacks on web pages,
- discusses web application optimization, profiling and testing.
During the classes students work on Windows; PHP and Apache configuration are shown in both Windows and Linux environment.
In case you have any questions about the course programme, e-mail or call us!
Certification
Students who finish our course have sufficient skills to create web stores, discussion forums and web pages. They receive a certificate that contains a detailed list of qualifications they gained.
Interested students can also obtain Zend Certified Engineer certificate. The ZCE exam can be taken at any authorized Pearson VUE testing centre; the cost of the Zend PHP 5 Certification exam is 125 USD.
Course programme
Basics
- Introduction to PHP, HTML, CSS, XML
- Designing websites from the point of view of the developer – HTML and CSS
- Form elements, POST and GET HTTP request methods
- Variables, conditions and loops (basic syntax of if … else, while)
- The most important features of PHP
- Working with databases
- Retrieving data from MySQL and Postgres
- Modifying data
- Protecting against SQL injection attacks and Cross Site Scripting
Data Management
- The use of relational databases
- Data types in SQL
- Aggregates, subqueries, different types of joints
- Differences between MySQL and Postgres
- Database Design
- Diagrams, ERD (Entity Relationship Diagram)
- Creating a project database based on a simple specification of the problem
- Database normal forms
- Fundamental issues of efficiency and optimization
- DDL for MySQL and Postgres
- Processing and retrieving data in XML format
- Building an XML document, processing instructions, terminology, coding
- XPath and XPath queries in practice
- Integration with network services made available on the Internet (eg, GeoIP)
- SimpleXML
PHP in practice
- Variables, functions, arrays, strings
- Pass variables by value and by reference
- Operations on arrays (searching, sorting, advanced sorting)
- Operations on strings, regular expressions (regexp)
- Projection and the problem of implicit casting
- Supporting e-mail
- E-mail message headers
- Character encoding, content types, attachments
- PHP and Graphics
- Creating graphics using the GD functions
- Dynamic graphs
- Creating thumbnails , gallery
- Object-Oriented Programming
- Object syntax and use of existing libraries
- Designing object-oriented programs: definition of classes syntax, visibility, type of assertion parameters in the methods and functions, the use of interfaces
- Sample interfaces from SPL library (Standard PHP Library: Iterator, ArrayAccess, DirectoryIterator)
- Basics of UML class diagrams
- Basic design patterns
- Creating a simple application in MVC model (on variant of the Front Controller)
- Base installation and use of a typical MVC framework on a specific example (Zend Framework)
Presentation layer techniques
- Javascript
- Javascript: functions, variables, methods of use in the context of a HTML document
- DOM model, effects and animation
- Examples of popular scripts available on the network (effects)
- Dynamic form validation
- Introduction to Ajax
- Smarty System
- Basic characteristics, Smarty language
- Smarty templates organization into a hierarchy
- Introduction to content caching mechanisms built into Smarty
- Transformations using XSLT templates
Environment b>
- Using WinSCP and a simple programming editor to edit and deploy websites on the hosting servers
- Configuring LAMP environment of the virtual server and using it as a development environment
- Install Apache + PHP on Windows