Archives

Not many like the admin bar at the top provided by WordPress. Even though in WordPress 3.3, admin bar being called toolbar is much better, viewing my website as a user, the toolbar adds some [...]

A web service is a web application or component which communicates with other applications using open protocols like HTTP (Hyper Text Transport Protocol), SOAP (Simple Object Access Protocol). [...]

XML along with HTTP forms the basis of web services. XML provides a language which can be used between different platforms and programming languages and still express complex messages and [...]

Web services can be implemented in various ways. Web services can be classified as “Big” web services and “RESTful” web services. Big web services Big web services are based on SOAP standard and [...]

This tutorial provides a step-by-step installation guide for MySQL 5.5 on Windows. Download MySQL Depending on your operating system download the proper version of MySQL from the following link. [...]

1. Relational Database Management System (RDBMS) Software application that control the creation, maintenance, and use of a database. Based on the relational model. Data is stored in tables and [...]

MySQL supports various table types or storage engines to allow you to optimize your database. The table types are available in MySQL are: ISAM MyISAM InnoDB BerkeleyDB (BDB) MERGE HEAP The most [...]

The sample databases used in this tutorial are, Employees Sample Database BIRT Sample Database Please refer those links on how to download and import into your database.

Aggregate Functions SQL aggregate functions return a single value, calculated from values in a column. Useful aggregate functions: Function Description AVG() Returns the average value COUNT() [...]

Information Functions CONNECTION_ID() Returns the connection ID (thread ID) for the connection. Every connection has an ID that is unique among the set of currently connected clients. [...]