A collection of 10 tutorials for you to get started quickly with running Transact-SQL statements on SQL Server 2005. Clear examples are provided for running CREATE TABLE, INSERT, UPDATE, DELTE, SELECT, CREATE USER, GRANT EXECUTE statements.

A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs.

A collection of 12 FAQs on MySQL server mysqld administration. Clear answers are provided with tutorial exercises on starting and shuting down the server; turning on server log files; viewing binary log files; running server on different port numbers.

The costs and complexities of data integration have been greatly reduced by using XML as a common data-exchange format. However, without the right tool and the knowledge to use it, data mapping between relational and hierarchical structures can be intimidating and time-consuming. This intermediate, instructor-led, online class provides an in-depth look at how to use Altova MapForce to visually create and execute data mappings between relational databases and XML. It provides an overview of the database support features available within MapForce, and explores the issues that arise in mapping relational structures to hierarchical XSD. Register for this FREE class today!

This tutorial covers accessing Relational Data as XML. The following topics are covered: Overview of Database to XML Data Sources, Creating a Database to XML Data Source, Specifying Connection Settings, Using an ODBC Data Source in Stylus Studio, Working with Scenarios, Composing SQL/XML in Stylus Studio, Working with Relational Data as XML, Using the URL Builder.

This tutorial covers: An overview of DB-to-XML data sources, opening a New DB-to-XML data source document, specifying connection settings, working with scenarios, composing SQL/XML in Stylus Studio, and Working with relational data as XML as well.

This is a tutorial on hierarchical structures, their semantics, and operational principles. It explains how nonprocedural 4GLs like SQL can process multi-leg structures automatically by utilizing the semantics in the structure being processed. The process of being able to process multi-leg queries automatically means that any query posed against a multi-leg structure can be processed nonprocedurally and the user does not have to be knowledgeable of the hierarchical structure. XQuery being more procedural requires that hierarchical multi-leg query logic be specified to indicate how the multiple legs need to be related in order to properly hierarchically process the query. This means the coder of the query also has to be knowledgeable of the hierarchical structure being processed. Multi-leg queries are hierarchically complex to process and require Lowest Common Ancestor (LCA) logic. Procedural queries require this logic to be specified externally, while nonprocedural queries perform this logic automatically internally. This tutorial describes this hierarchical processing and much more.

In this tutorial, you'll learn about authentication and how to use hashes alone and with salt for better password protection.

This tutorial explains how to use to allow insertion of multiple rows into a database table based on the data entered into a form by a user.

In this tutorial we are going to talk about yet another powerful feature of database programming, Stored Procedures.

In this tutorial, for beginners to database design, Rob Stuttaford writes on how to design databases that are normalised - the process of breaking data down into its most basic components.

Learn Access programming tips such as displaying a range of dates in a Calendar control, creating a blinking label prompt for a text box, converting a number from one base to another, and more.

Connecting to a MySQL Database from within UltraDev can be a little daunting, especially if you're new to UltraDev. This tutorial explains how to connect to a MySQL database using MyODBC. Extremely usefull for PHAkt users!

Welcome to an introduction on database performance tuning and optimisation. My previous tutorial, SQL Made Simple, looked at a normalised database, and explored some of the queries we would use to make information from data in its normalised state. Today, we’re going to look at ways to shorten query processing time on this same database.

In this tutorial we will learn what are the two common ways of displaying data from an SQL Server database using ADO.NET in an ASP.NET page.

The tutorial series will look at the different methods of retrieving data, always aware that this is the Web and that speed is of the essence, how to monitor performance of your database and tune it for maximum speed.

This tutorial shows how to use a nested query on a parent/child table to count the records in that child table and display them togehter with the parent record.