- Managing Transaction Processing for SQL Database Integrity
- Jul 9, 2004
- In this lesson, Ben Forta explains SQL transactions, how the COMMIT and ROLLBACK statements can be used to manage data, and the use of savepoints.
|
- Microsoft Yukon: Worth the Wait?
- Mar 19, 2004
- Despite the well-known shipping delays, some beta testers are actually quite avid about Microsoft's upcoming SQL Server 2003, code-named Yukon. Tech journalist Jacqueline Emigh interviewed PhotoWorks' Don Watters, one DBA who thinks that Yukon will be worth the wait. Watters is a strong believer in Yukon's native XML integration and redesigned DTS. However, Microsoft still has work ahead in terms of database security, usability, and a variety of other areas, the beta tester admits.
|
- Monitoring and Troubleshooting Transactional Replication
- Apr 23, 2004
- So you set up replication and it works for a week. Then one fine day your pager goes off. Now what? Where do you look for clues? How do you troubleshoot? How can you tell if your replicated system performs well? Read on to find out the answers from Baya Pavliashvili.
|
- MySQL Overview and New Performance-Related Features
- Jun 24, 2005
- This chapter provides an overview of the various MySQL iterations, and how they are covered within the rest of the book, along with the environments in which they were used for the book. Finally, there is a list of performance enhancements and the version of MySQL in which they were introduced.
|
- Object Relational Mapping and Java Persistence: Data Modeling and Legacy Schemas
- Jun 23, 2009
- Stephen Morris tackles object relational mapping (ORM) techniques. This includes entity and value type component mapping and database design workflow.
|
- Oracle SQL: The Basics
- Aug 25, 2009
- In this chapter you will learn the basics of the SQL language and use SQL Developer and SQL*Plus.
|
- Overcoming High-Latency Database Access with Java Stored Procedures
- May 13, 2004
- Java Stored Procedures: a way to put slow Java code in your otherwise fast database or a quick solution for certain database performance problems? They can be both, as it turns out. Tim Stevens takes a look at a situation in which the adoption of Java Stored Procedures quickly and effectively solved some serious performance issues in a database-driven system, all without a complete rewrite of existing database code.
|
- 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.
|
- 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.
|
- PostgreSQL SQL Syntax and Use
- Sep 9, 2005
- This chapter covers the basic operation of PostgreSQL, including naming conventions, creating a database, and indexing. When you finish with it, you should be able to use PostgreSQL for most basic functions.
|
- 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: 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: 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.
|
- 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.
|
- 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: Tuning Queries
- May 31, 2002
- This excerpt teaches how to make your SQL as effective as possible from a performance point of view.
|
- Querying SQL with LINQ
- Jul 28, 2008
- With LINQ and LINQ to SQL, never again should you have to write a data access layer.
|
- Relationships Should NOT Be Natural!
- Apr 30, 2004
- Using naturally occurring data can have negative impact on database performance. We should restrict ourselves to using cold, hard, sequential numbers, and forget about those warm, comfortable relationships with data that are so familiar.
|
- Retrieving Data Using the SQL SELECT Statement
- Dec 10, 2012
- In this lesson, learn how to use the SELECT statement to retrieve one or more columns of data from a table.
|
- SELECT Statement: The GROUP BY Clause in SQL
- Nov 17, 2006
- Rick F. van der Lans explains how SQL's GROUP BY clause groups rows on the basis of similarities between them. He goes on to explain the use of adding aggregation functions to display summations, averages, frequencies, and subtotals.
|