Community-Credit.com | NonProfitWays.com | SOAPitstop.com
The Green Stuff
User: Not logged in
Latest XML Blogs
Add a Resource
World Trip Pics
Total Tutorials: 1,069
MySQL FAQs - Server Daemon mysqld Administration
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.
Type: Database #Views: 114 Category: Tutorial
Free Online Class - MapForce Database Essentials
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!
Type: Database #Views: 476 Category: Tutorial
Relational and XML Integration
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.
Type: Database #Views: 718 Category: Tutorial
Using XML and Databases
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.
Type: Database #Views: 1326 Category: Tutorial
Hierarchical Structures and 4GLs
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.
Type: Database #Views: 631 Category: Tutorial
Keeping Passwords in a Database Secure
In this tutorial, you'll learn about authentication and how to use hashes alone and with salt for better password protection.
Type: Database #Views: 1011 Category: Tutorial
Inserting Data into Multiple Rows of Database
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.
Type: Database #Views: 1286 Category: Tutorial
Stored Procedures in Access Database
In this tutorial we are going to talk about yet another powerful feature of database programming, Stored Procedures.
Type: Database #Views: 804 Category: Tutorial
Introduction to Database Design - Normalisation
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.
Type: Database #Views: 682 Category: Tutorial
Ten Tips for Microsoft Access Developers
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.
Type: Database #Views: 770 Category: Tutorial
Using PHAkT v1.0: Connecting to a MySQL Database using MyODBC
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!
Type: Database #Views: 436 Category: Tutorial
Database performance tuning and optimisation
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.
Type: Database #Views: 239 Category: Tutorial
2 Ways of Displaying Data from an SQL Server Database using ASP.NET
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.
Type: Database #Views: 400 Category: Tutorial
Database design and optimisation made easy
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.
Type: Database #Views: 249 Category: Tutorial
Nested Query on Parent/Child table
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.
Type: Database #Views: 318 Category: Tutorial
Fans of "The Office"
Dwight Bobbleheads are here!
“It's me! I'm the bobblehead! Yes!”
Advertise on XMLPitstop
Advertise on XMLPitstop
Web Servicee development
Buy links on this site!
Security Camera Systems
online business degree
remote file backup
Color Laser Printer
Buy links on this site!
Interested in Text ads?
2,251 Total Members
37 members(last 30 days)
5 members(last 7 days)
1,624 Total Discussions
15 Posts(last 30 days)
8 Posts(last 7 days)
18,742 Total Blog Posts
1,849 Blogs(last 30 days)
478 Blogs(last 7 days)
8,699 Newsgroup Posts
0 Posts(last 30 days)
0 Posts(last 7 days)
13,787 Total Resources
2 Resources(last 30 days)
0 Resources(last 7 days)
David Silverlight's XMLPitstop.com
| 2801 Florida Ave #225|Miami, FL 33133|Ph:305-447-1139