Saturday 5 May 2012



  About 1000 Tutorials for learning  Wamp Server,  PHP,  MY SQL Server,  Apache Server,  Server 2008,Microsoft SQL Server 2008,  Oracle,  Database.



Wamp Server 

Introduction



WAMP is a Windows OS based program that installs and configures Apache web server, MySQL database server, PHP scripting language, phpMyAdmin (to manage MySQL database’s), and SQLiteManager (to manage SQLite database’s). WAMP is designed to offer an easy way to install Apache, PHP and MySQL package with an easy to use installation program instead of having to install and configure everything yourself. WAMP is so easy because once it is installed it is ready to go. You don’t have to do any additional configuring or tweaking of any configuration files to get it running. 

There are usually two reasons why someone chooses to install WAMP. They are looking to install WAMP for development purposes or to run their own server. 



Wamp Server Cointains

1-PHP Admin
Alows you to change or add users and for making new databasesphpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQLover the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.




















Features

  • Intuitive web interface
  • Support for most MySQL features:
    • browse and drop databases, tables, views, fields and indexes
    • create, copy, drop, rename and alter databases, tables, fields and indexes
    • maintenance server, databases and tables, with proposals on server configuration
    • execute, edit and bookmark any SQL-statement, even batch-queries
    • manage MySQL users and privileges
    • manage stored procedures and triggers
  • Import data from CSV and SQL
  • Export data to various formats: CSVSQLXMLPDFISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, LATEX and others
  • Administering multiple servers
  • Creating PDF graphics of your database layout
  • Creating complex queries using Query-by-example (QBE)
  • Searching globally in a database or a subset of it
  • Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
  • And much more...
2-Apache
Apache Server deals with Server Side Includes, usually called simply SSI. In this article, I'll talk about configuring your server to permit SSI, and introduce some basic SSI techniques for adding dynamic content to your existing HTML pages.
In the latter part of the article, we'll talk about some of the somewhat more advanced things that can be done with SSI, such as conditional statements in your SSI directives.






3-SQL Server and Database System







SQL Server is a relational database management system  from Microsoft that's designed for the enterprise environment. SQL Server runs on T-SQL (Transact -SQL), a set of programming extensions from Sybase and Microsoft that add several features to standard SQL, including transaction control, exception and error handaling, row processing, and declared variables.







Generically, any database management system (DBMS) that can respond toqueries from client machines formatted in the SQL language. When capitalized, the term generally refers to either of two database management products from Sybase and Microsoft. Both companies offer client-serverDBMS products called SQL Server.


Using WAMP as a Development Server 


You can use WAMP to develop and test websites locally on their own computer instead of having to get a web hosting account to develop with. Most people will be using WAMP for development purposes such as learning how to create websites with HTML, PHP, and MySQL. 


Using WAMP as a Production Server 



WARNING: WAMP was designed to be a testing and development server, not an actual production server. WAMP does not come with any real security in place so it offers no protection from any kind of attack. Any 10 year old with access to the internet can easily hack your WAMP server. If your website(s) have hi ghly sensitive data (such as credit card numbers, social security numbers, user ids, passwords, etc.), you need to take this in consideration before your put this information online. Unless you are an experienced system administrator and can configure WAMP to be more secure, you should never user WAMP for a production server.








MySQL Configuration




To begin MySQL installation, first download latest version of MySQL 5.0 Windows Essentialsas an MSI package.
During MySQL installation, select Typical installation and use default configuration values except for Sign-Up where you probably want to select Skip Sign-Up. When Setup Wizard is completed, make sure the option Configure the MySQL Server now is set.
For MySQL Server Instance Configuration, select Standard Configuration. Next, you mustset option Include Bin Directory in Windows PATH. This setting is crucial, otherwise a required library, libMySQL.dll, will not be found later during Apache startup. Finally, enter a proper root password. There is no need to neither enable remote root access or create an Anonymous Account.
Please inspect messages during MySQL startup and verify that MySQL has been started successfully. Then, you must reboot the system. Otherwise, the required librarylibMySQL.dll will not be found during Apache startup when Apache is trying to load Apache's PHP module and Apache will, perhaps a bit confusingly, complain that it is unable to load the PHP's MySQL library, php_mysql.dll. Therefore, it is necessary to reboot the system at this stage and then continue to PHP configuration.






PHP Configuration





PHP for Windows must be installed from the zip packagenot using the installer because the installer does not work correctly when setting up the configuration files. Download the latest Windows binary version from the 5.x release series.
Create folder C:\Program Files\PHP5 and unzip the downloaded package there. Then, in folder C:\Program Files\PHP5 you need to copy the file php.ini-recommended asphp.ini and make two changes into the php.ini file. Change extension_dir to:
extension_dir = "C:/Program Files/PHP5/ext/"
and also uncomment the following line:
extension=php_mysql.dll
That is all what is needed for PHP configuration. Additionally, however, if you wish to runPHP from the command line it would be useful to add its installation directory to WindowsPATH but for WAMP to operate it is not required. After Apache is installed and configured, also PHP configuration can be tested.


Apache Configuration


Official apache website provides also binaries for Windows. Download the latest availableMSI package from the 2.2.x release series.
During Apache installation, use default values for all configuration queries. Make sure, though, that you fill in a valid e-mail address to Administrator's Email Address field, otherwise Apache will fail to start due to a configuration error. After the installation has finished a tray icon should appear to indicate that Apache server is up and running.
To configure Apache server edit configuration via a Start Menu item or open the fileC:\Program Files\Apache Software Foundation\Apache2.2\conf\httpd.conf in a text editor and change the following line:


       DirectoryIndex index.html


to include index.php so that the result will look like:


       DirectoryIndex index.php index.html

This will cause Apache to serve page index.php by default, if present. Then, add into the same file after all the LoadModule directives the following lines 



# Enable PHP5
LoadModule php5_module "C:/Program Files/PHP5/php5apache2_2.dll"
AddType application/x-httpd-php .php
PHPIniDir "C:/Program Files/PHP5"






These lines cause Apache to load and use PHP module and its configuration. The last directive, PHPIniDir, is crucial, without it Apache will fail to read the PHP configuration file.
Apache is now configured. For changes to take effect, Apache must be restarted either from Start Menu or using the Apache Monitor that can be started from the tray icon. No error messages will appear if configuration has been done as instructed.
Before finally proceeding to MediaWiki configuration it is a good idea to check at this stage that WAMP really is working properly. This can be done simply by creating file C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\test.php that contains only the following line:
<?php phpinfo(); ?>
The result can then be seen by opening the page http://localhost/test.php in a browser. Make sure that PHP Loaded Configuration File is C:\Program Files\PHP5\php.ini and that MySQL has its own section in the configuration details noting that MySQL support is enabled. As could be noticed, the default content location, DocumentRoot, for Apache to serve content is C:\Program Files\Apache Software Foundation\Apache2.2\htdocs.


PHP tutorials

Database tutorials



Database systems in wamp server
DB2 Interview Questions
Most popular db2 interview questions and answers.



DB2 Interview Questions & Answers
This page contains useful interview questions with answers. You can add new interview questions and participate in discussions.



DB2 Quick Start
This tutorials covers DB2 SQL basics, DB2 cobol programming, unload and load utilities, triggers & stored procedures.



DB2 SQL Tutorial - Drona Series
An introduction to SQL (specially for db2 programmers). It is very easy to understand.



DB2 System Performance Metrics
This paper focuses on the data in the DB2 Statistics and Accounting records, and discusses how this data can be used together with other MVS system information sources, such as RMF, for performance analysis and tuning of the DB2 system and applications.