Archive for the ‘Certification’ Category

Server SQL Modes

SQL mode set on server defines the way to handle some aspect of query processing: accepting input data and compatibility to standard SQL conformance.
(more…)

Read the rest of this entry »

Command-line Options

Few notes about command -line options in MySql.
(more…)

Read the rest of this entry »

XML for ZCE candidate

Many web services provide XML data through their API. So it is necessary to understanding of XML basics in order to develop web applications. Also knowledge of XML is one of the skills examined by the ZCE test.
(more…)

Read the rest of this entry »

PHP Basics for ZCE, Duh!

It doesn’t matter how much you know about PHP basics there is always something new to learn.
(more…)

Read the rest of this entry »

Few Words About Headers

PHP has few functions that could be very helpful when you work with headers. Even so it’s not a big news for developers who worked with headers before. This post could be a revelation for those who switched from PHP4 to PHP5.
(more…)

Read the rest of this entry »

How to improve SQLite write performance

Performance optimization is a crucial thing for any application. Today I provide you with the to-do list of what should be done in order to improve SQLite write performance. Even so it’s just a quick reference it will show you the way.
(more…)

Read the rest of this entry »