Database applications aren't just for large corporations any more--find out how you can use a database on your site in this Primer Series!

  • Database/SQL Primer

  • Fetching CSV File Data using Microsoft Data Access Components

    Microsoft Data Access Components (MDAC) is a framework of technologies that provides programmers with a uniform and consistent way to develop applications that can access almost any data store. In this tutorial we're going to write an SQL query to extract data from a CSV file.

  • Work with Text File Data using the Microsoft Text Driver: Creating a CSV Data File

    Microsoft has an ODBC text driver that allows you to interface with a flat file database just as you would any ODBC database. This provides the advantage that it scales quite well. In today's article, we will learn more about flat file formatting and how to create a CSV Data File from an MS Access table.

  • Connect to CSV Data Files using Microsoft Data Access Components

    In a recent article, we used the Access Export Wizard as a means of generating a Comma-separated-Values (CSV) file. In today's follow-up, we're going to construct some connection strings that will allow us to perform queries against the contents of the CSV file using the various Microsoft data providers.

  • Top 5 Databases for Web Developers

    When listening to developers talk about databases you will usually hear buzz words like robust, scalable, efficient, etc. In this article, we are going to be looking at the cost of getting started, tools, the user interface and the availability of help, especially help for the beginner.

  • ColdFusion for the Web Developer, Part 2

    Last week we discussed some of the things you can do with ColdFusion. This week we'll continue, taking a look at ColdFusion Components and PDF manipulation!

  • Adobe ColdFusion for the Web Developer

    If you're a web developer, chances are you've heard of Adobe's ColdFusion. This article takes a close look at the features of this popular database scripting language.

  • Database Basics: Part 1

    So, you've decided that you're interested in using a database in your web development, huh? Well, the next step would be to learn about how the database works. Read on for the full story!

  • Database Basics: Part 2

    Now that you have a feel for how to organize the contents of your database, I'll bet you'd like to create some real tables! Read part 2 in our series to get you started!

  • Database Basics: Part 3

    Alright, we're making some progress now. You have a database and you've created some tables. What about putting some data into the tables?

  • Database Basics: Part 4

    Now we have tables with stuff in them. The next logical step is getting stuff back out. In this lesson you will learn about the most used statement in SQL, the SELECT.

  • Database Basics: Part 5

    In Part 4 you learned about using WHERE to filter your data. What if you have a much more complex set of criteria that you would like to apply to filter? Read on to find the details!

  • Database Basics: Part 6

    Now for some more functions that will help you get the data you want out of the database. And finally, we will live dangerously and start deleting stuff!

  • Database Basics: Part 7

    Congratulations! You've finished the Database Basics tutorial. This tutorial should give you a good understanding of the fundamental concepts of adding, updating, retrieveing and deleting data using SQL.

  • To Use or Not to Use a Database? That is the Question

     

  • Web Development Newsletter Signup

    Invalid email
    You have successfuly registered to our newsletter.
  •  
  •