Database Tutorial

PHP MySQL Select
The SELECT statement is used to select data from a database. Select Data From a Database Table. The SELECT statement is used to select data from a database. Syntax. SELECT column_name(s) FROM table_name. (more…)

IBM developerWorks: Use an XML database in PHP and Java applications
The IBM developerWorks site has posted a tutorial (you'll need to log in) showing how to use native XML databases to speed up development time for your applications. Native XML databases have grown in popularity along with XML, ...

Using the Java Persistence API (JPA) - Tutorial
TThe Java Persistence API and let the developer easily map, store, update and retrieve data from relational database tables into Java Objects. The article describes the usage of the Apache OpenJPA implementation in a Java application.

Tutorial for MySQL An Introduction to Java Programming
The mysql database contains the tables that store the information about the server and its users. This database is intended for the server administrator to use. For example, the administrator can use it to create users and grant or ...

Using “Execute As” in a Stored Procedure To Access A Separate Database
This MSDN article gives some excellent information about extending database impersonation but I thought it also left a few things out, thus my tutorial here. The first thing you have to do is make sure the OWNER of your database, ...

Free Crochet Patterns For Advanced Beginner - Advanced Crochet ...
My destination shall be http://www.crochetpatterncentral.com for the simple reason that's its database of designs is the largest I have came across and the best I would say. It can surely keep you occupied for the next 3 years. ...

PHP/MySQL Tutorial
In the first installment of this three-lesson tutorial, our Kiwi guide covers everything you need to know to begin developing database hubs. He gives instructions for installation on both Unix and Windows, and then goes on to show some ...

15 helpful WordPress plugins for the savvy user
WP-DBManager gives you an administrative interface to manage, backup, and optimize your WordPress database. It has countless of options for making database management quite effortless. Installing this plugin gives you a new tab in the ...

Beginning Hibernate From Novice to Professional
It then looks at a slightly more complex example and introduces the notion of generating the database schema directly from the mapping files. Chapter 4 : covers the Hibernate life cycle in depth. It discusses the life cycle in the ...

Efficient SQL Databases and Insert keyword
The reason this makes a difference is when you have a database, for example, with over 500 000 entries, and are running a SELECT on that field, comparisons are processed a lot faster for numeric data types than character types. ...