Home > Articles > Data > SQL

SQL

83 Items

Sort by Date | Title

Serve SQL Data in XML Format
Sep 28, 2007
Learn how to extract data from SQL databases and serve it to an AJAX application running in a web browser.
Setting Up Transactional Replication with SQL Server
Mar 26, 2004
Setup isn't the only piece of the replication puzzle; yet getting it wrong can cause many headaches. In this second episode of his replication series, Baya Pavliashvili teaches you how to set up replication through wizards and through scripts.
Sorting Retrieved Data from SQL Databases
Jun 18, 2004
In this lesson, taken from Sams Teach Yourself SQL in 10 Minutes, you will learn how to use the SELECT statement's ORDER BY clause to sort retrieved data as needed.
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.
SQL 2005 Web Synchronization for Merge Replication
Oct 13, 2006
Hilary Cotter provides a tutorial on how to set up Web synchronization in SQL 2005.
SQL and Data
Apr 11, 2003
Working through an interactive workbook, get to know SQL by exploring the basics of data storage, schema diagrams, data normalization rules, and table relationships.
SQL Building Blocks and Server Settings
Aug 6, 2004
This chapter covers the building blocks available to the database designer and database user to create and modify database objects and data. The SQL Data Types will be covered along with data representation as literals (constants) and expressions.
SQL Essentials
May 30, 2003
This sample chapter will get your feet wet in the basic functions of SQL. David Gallardo goes through the primary features of the database language, including comprehensive working examples.
SQL Expressions, Conditions, and Operators
Jun 18, 2009
This lesson introduces SELECT and FROM and expands the basic query with some new terms, a new clause, and a group of handy items called operators.
SQL Fundamentals (Video Training): Introduction to MySQL Interfaces
Oct 26, 2009
This video excerpt is from SQL Fundamentals LiveLessons Bundle (Video Training).
SQL Fundamentals LiveLessons (Video Training): ANSI SQL Select Statement
Nov 3, 2009
This video excerpt is from SQL Fundamentals LiveLessons Bundle (Video Training).
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.
SQL Fundamentals: Storing Information in Tables
Oct 8, 2008
This chapter examines SQL tables in detail.
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.
SQL Queries for Mere Mortals: Thinking in Sets
By Michael J. Hernandez
Jul 1, 2014
This chapter introduces the concept of an SQL set. It discusses each of the major set operations implemented in SQL in detail (intersection, difference, and union), and shows how to use set diagrams to visualize the problem you’re trying to solve. Finally, it introduces the basic SQL syntax and keywords (INTERSECT, EXCEPT, and UNION) for all three operations.
SQL Queries for Mere Mortals: Thinking in Sets
By Michael J. Hernandez
Nov 30, 2007
This sample chapter discusses the concept of a set along with each of the other major set operations in SQL.
SQL Queries: Summarizing Data Results from a Query in SQL
Jan 28, 2016
Aggregate functions can be useful and are quite simple to use. In this chapter from SQL in 24 Hours, Sams Teach Yourself, 6th Edition, you learn how to count values in columns, count rows of data in a table, get the maximum and minimum values for a column, figure the sum of the values in a column, and figure the average value for values in a column.
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.
SQL Server Log Shipping
Aug 20, 2004
Baya Pavliashvili gets you started with log shipping (ensuring failover capability, not moving lumber) by discussing its advantages and drawbacks, and then shows you how to set up log shipping and how to fail your database over to the standby server.
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.

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