Home > Articles > Data > SQL

SQL

83 Items

Sort by Date | Title

art_gore_outsourcing
Jan 1, 2003
SQL Performance Tuning: Simple "Searches"
Dec 13, 2002
Master SQL syntax-based optimizing and simple search conditions. Learn which search conditions are best, and armed with this information, you can decide whether to change the order of expressions, or to substitute one expression for another that does the same work more efficiently.
Joining Tables in SQL Queries
Oct 25, 2002
This lesson teaches the reader how to join multiple tables in a single query in order to optimize the use of the data stored in the database.
PHP Database Integration—SQL
Oct 25, 2002
Sharing information with databases is a key requirement of most professional web pages. This lesson provides a brief introduction to SQL and explains how to connect to and access data from a SQL database.
Summarizing Data Results from a SQL Query
Oct 18, 2002
In this lesson, aggregate functions are explained by example, providing the reader with a solid foundation that can be applied to empower the database query.
SQL Fundamentals: Getting Information From a Table
Jul 5, 2002
Software developer John Patrick reviews the four basic clauses of the Structured Query Language (SQL) select statement along with their options. Learn how to obtain table information using the select statement of this relational database technology.
Practical SQL: Creating and Using Views
Jun 7, 2002
Use views to control how users see your data. Views allow you to provide focus, simplification, and customization of tables in your database.
Practical SQL: Tuning Queries
May 31, 2002
This excerpt teaches how to make your SQL as effective as possible from a performance point of view.
Practical SQL: Finding and Changing Words ("&" to "and")
May 24, 2002
Sometimes you need to find and change words in SQL. In this article, you learn how to get inside the expression, find the offending segment, and change it.
Practical SQL: Subqueries in FROM and SELECT Clauses
May 17, 2002
The ANSI standard allows a subquery in the FROM clause, and some relational database management systems (RDBMSs) permit a subquery in the SELECT clause. Learn how to use them here.
Practical SQL: Making the Best Use of Views
May 10, 2002
Do you want to simplify and customize the “view” of your data? This article gives you the basics of view construction.
An Introduction to SQL
Mar 15, 2002
Structured Query Language (SQL) enables you to pose complex questions to a database. It also provides a means of modifying databases. Many databases support SQL, so you can apply this knowledge to MS SQL Server, DB2, Oracle, PostgreSQL, and countless other databases.
PostgreSQL Compiling and Installation
Mar 8, 2002
New Riders author Barry Stinson gives those who are new to PostgreSQL, but familiar with database concepts in general, a quick-start guide to administrating a PostgreSQL database.
SQL Server Stored Procedure Basics
Feb 8, 2002
Learn the basics of writing stored procedures, monitor stored procedure activity using the Profiler utility, and learn from several real-world stored procedure programming issues.
Practical SQL: Selecting Data from the Database
Nov 2, 2001
This sample chapter from The Practical SQL Handbook: Using SQL Variants focuses on the SELECT statement and some of the many things it can do. This chapter covers the SELECT, FROM, and WHERE clauses, search conditions, and expressions.
SQL Server 2000 and the XDR Schema
Sep 21, 2001
Schemas, Microsoft's version of XML schemas, create XML views of relational data which can then be queried via XPath expressions. This article looks at XDR Schemas and how they work with SQL Server 2000.
Sorting Retrieved Data in SQL
Jul 13, 2001
In this sample chapter, you will learn how to use the SELECT statement's ORDER BY clause to sort retrieved data in SQL.
InformIT Visual Tutorial 3: Structured Query Language (SQL)
Jul 6, 2001
A database lets you safely store and retrieve data from your Web site's users. To get to that data, you use Structured Query Language (SQL).
Working with Columns
May 11, 2001
In this chapter from Sams Teach Yourself Transact-SQL in 21 Days, Second Edition, you will learn several techniques that will help you throughout your SQL programming career.
Adding a User to a Database
Nov 6, 2000
Everything you do in SQL Server is authenticated, including creation of the databases and files. Understanding SQL Server security is critical to the successful operation of your SQL Server.

<< < Prev Page 1 2 3 4 5 Next >