Technology | Support | Tutorials | Development | About Us | Users | Contact Us

Resources     Tutorials     Presentations Perl & CGI tutorials     Intro to Perl/CGI and HTML Forms     Intro to Windows Perl     Intro to Perl 5     Intro to Perl     Intro to Perl Taint mode     Sherlock Holmes and the Case of the Broken CGI Script     Writing COM Components in Perl Java tutorials     Intro to Java     Cross Browser Java Misc technical tutorials     Intro to The Web Application Development Environment     Introduction to XML     Intro to Web Design     Intro to Web Security     Databases for Web Developers     UNIX for Web Developers     Intro to Adobe Photoshop     Web Programming 101     Introduction to Microsoft DNA Misc non-technical tutorials     Misc Technopreneurship Docs     What is a Webmaster?     What is the open source business model?     Technical writing     Small and mid-sized businesses on the Web Offsite tutorials     ISAPI Perl Primer     Serving up web server basics     Introduction to Java (Parts 1 and 2) in Slovak   introduction to Databases for web developers Table of Contents Part One: Basics What is a Database Types of Databases Analytic Databases Operational Databases Databases Models Hierarchical Databases Network Databases Relational Databases Client Server Databases Good Database Design Talking to a Database The Basics of the SQL Database Tables The Data Dictionary Basics of an SQL Query Data Types Logging on to the Database A Sample Database Creating Databases Creating Tables Deleting Databases and Dropping Tables Altering a Table   Part Two: Retrieving and Manipulating Data Retrieving Data Wildcards Where And, Or, and Not Between In Like Null Order by Performing math Maximums and Minimums Counting Records Distinct Averages Joins Subquerries Adding Data Modifying Data Deleting Data   Part Three: CGI Interfaces to SQL Databases Server Side Database Communication With CGI Chains of Communication Using Perl 5 and the DBI Module to Communicate With Databases The DBI Module The DBI API Getting the Pieces Installing Perl Installing a Web Server : Sambar Running CGI Applications on a Single Station Local Area Network Setting up a Sample Database Putting it all together with a DBI-Aware CGI Script   Part Four: Java Database Connectivity Intro to JDBC JDBC Application Environment Setup Using JDBC to Connect to a Database Using JDBC to Query a Database Using JDBC to Modify a Database More on JDBC JDBC by Example