Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

  Tutorial: SQL for Web Nerds

After writing a preface lampooning academic eggheads who waste a lot of ink placing the relational database management system

Tutorial Details:

This tutorial covers the following topics:

Introduction
Data modeling
simple queries: one table, one table with subquery, JOIN, JOIN with subquery, OUTER JOIN
more complex queries: GROUP BY, aggregates, HAVING
Transactions (inserts and updates)
triggers
views
style
escaping to the procedural world: PL/SQL and Java executing inside the Oracle server
trees
handling dates in Oracle
limits in Oracle; how they will bite you and how to work around them
tuning, what to do when your query runs too slowly
data warehousing, what to do when your query doesn't answer your questions
foreign and legacy data, making foreign Web sites look like local SQL tables
normalization


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
SQL for Web Nerds

View Tutorial:
SQL for Web Nerds

Related Tutorials:

XML for the absolute beginner - JavaWorld - April 1999
XML for the absolute beginner - JavaWorld - April 1999
 
Access the world's biggest database with Web DataBase Connectivity - JavaWorld March 2001
Access the world's biggest database with Web DataBase Connectivity - JavaWorld March 2001
 
Create your own type 3 JDBC driver, Part 2
Create your own type 3 JDBC driver, Part 2
 
Create your own type 3 JDBC driver, Part 3
Create your own type 3 JDBC driver, Part 3
 
JSP Standard Tag Library eases Webpage development
JSP Standard Tag Library eases Webpage development
 
eva/3 Application Builder supports eclipse 3
What is eva/3 Application Builder? eva/3 Application Builder assumes responsibility for the design of forms and reports via an integrated GUI Builder, the execution of procedures and the handling of diverse relational SQL databases through JDBC int
 
JForumFusion
About jForumFusion JForumFusion is a platform independent discussion board program.
 
IberAgents
Introduction IberAgents is a web application framework that enables the creation of SOAP-interoperable components in Java, with life cycle management and remote configuration. Development started in 2001; we now have a mature, solid open-source platform
 
SQL Uniform
SQL Uniform is a general interface (GUI), a helper application to relational databases of various types regarding query, maintenance, data comparison, export (convert).
 
StelsCSV - JDBC driver for text files
StelsCSV is a CSV JDBC type 4 driver that allows to perform SQL queries and other JDBC operations on text files (comma separated, tab separated, fixed length etc). Using this driver, you can easily create a simple database consisting of plain text files.
 
Primrose - Free J2EE Database Connection Pooling Software
Primrose Primrose is a database connection pool, written in Java. Current containers support are Tomcat 4 & 5, and JBoss 3. There is also now a standalone version of primrose that can be used for applications not running inside a container.
 
JAVASERVER PAGESTM JAVASERVER PAGESTM
JSPTM tag libraries define declarative, modular functionality that can be reused by any JSP page. Tag libraries reduce the necessity to embed large amounts of Java code in JSP pages by moving the functionality provided by the tags into tag implementation
 
Pool resources using Apache's Commons Pool Framework
Resource pooling is not new and is being widely used to conserve and optimize the usage of resources like threads, sockets, and database connections. Web server implementations routinely use thread pool implementations for performance and scalability reas
 
What is Persistence Framework?
What is Persistence Framework? What is Persistence Framework? A persistence framework moves the program data in its most natural form (in memory objects) to and from a permanent data store the database. The persistence framework manages the
 
Free JSP, Free EJB and Free Servlets Hosting Servers
Free JSP, Free EJB and Free Servlets Hosting Servers Free JSP, Free EJB and Free Servlets Hosting Servers Web roseindia.net Other Free Hosting Services MyCGIserver - Free Hosting server provides the following support with the free account: JSP
 
Free JSP, Free EJB and Free Servlets Hosting Servers
Free JSP, Free EJB and Free Servlets Hosting Servers Web roseindia.net Free JSP, Free EJB and Free Servlets Hosting Servers MyCGIserver - Free Hosting server provides the following support with the free account: JSP 1.1, Servlets, Apache Cocoon,
 
First Step towards JDBC!
First Step towards JDBC! Welcome to our JDBC Section First Step towards JDBC This article introduce you with JDBC and shows you how to create a database application to access the databases. Accessing the Database from Servlet This article shows
 
What is Web Hosting
What is Web Hosting What is Web Hosting? What is Web Hosting? If you have a company and want web presence than you need a website. With the website any one from the world must be able to view your pages, images etc. Website is actually a
 
StelsCSV v2.2 - JDBC driver for CSV files
*StelsCSV* is a JDBC driver that allows to perform SQL queries and other JDBC operations on text files (CSV, tab-separated, fixed length etc). Using this driver, you can easily create a simple database consisting of plain text files.
 
Urchin RSS Aggregator
Urchin is a Web based, customisable, RSS aggregator and filter. It\'s primary purpose is to allow the generation of new RSS feeds by running queries against the collection of items in the Urchin database.
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.