Home > Articles > Data

Data

535 Items

Sort by Date | Title

Oracle Performance Tuning: A Methodical Approach
Nov 5, 2009
Guy Harrison shares a methodology that ensures that you focus on the root causes of Oracle performance problems.
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 (Video Training): Introduction to MySQL Interfaces
Oct 26, 2009
This video excerpt is from SQL Fundamentals LiveLessons Bundle (Video Training).
TOAD Setup and Configuration
Sep 18, 2009
Bert Scalzo and Dan Hotka review some of the more common and critical setup and configuration steps necessary to fully maximize your initial TOAD experience.
Deploying Merge Replication Subscribers in SQL Server
Sep 10, 2009
Hilary Cotter shows how to decouple your SQL Server snapshot generation from your snapshot application process for the best possible performance - all while letting you keep your sanity.
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.
Converting XML to Relational Data for Use in DB2
Aug 13, 2009
This chapter describes methods to convert XML documents to rows in relational tables.
Introduction to SQL Server Reporting Services (SSRS)
Aug 4, 2009
This chapter focuses on the features and capabilities of SSRS and how they fit into the Microsoft Business Intelligence platform.
Database Access via C# ADO.NET
Jul 2, 2009
Having trouble getting off the ground with ADO.NET, and C# in particular? You don't have to be a DBA to get great results with this interesting technology; when you come right down to it, this isn't a complex area. Enterprise development and networking specialist Stephen B. Morris shows the way.
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.
Appending an Access 2007 Form Using Email
Jun 22, 2009
Tom Bunzel explores the Access email form feature in detail, taking you through the process step by step and comparing it with other ways that also let you bring user data from external sources into an Access table.
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.
Defining and Working with Fields and Tables in FileMaker Pro 10
Jun 11, 2009
This chapter describes what kinds of fields exist in FileMaker Pro, how they store information, and how to ensure proper data integrity in your database solutions.
Designing Databases for Performance: What's Your Strategy?
Jun 2, 2009
John Goodson and Robert A. Steward discuss different strategies for designing your database application and configuring the middleware for optimal performance.
Installing or Upgrading to the SQL Server 2008 Database Engine
May 28, 2009
This chapter describes the step-by-step process for installing a clean version of SQL Server 2008 Database Engine and/or upgrading an existing SQL Server Database Engine implementation to SQL Server 2008.
Microsoft SQL Server Analysis Services: Introduction to OLAP and Its Role in Business Intelligence
May 28, 2009
This chapter explains how SQL Server Analysis Services uses the Multidimensional Data Model to define and process data as well as interact with other data storing systems.
What Is a CMDB?
Apr 23, 2009
In this chapter, learn about the enigma that is a CMDB (Configuration Management Database), including answers to frequently asked questions.
SQL Server Forensic Investigation Scenario
Apr 13, 2009
This chapter walks through an actual forensic investigation scenario, showing the logical progression of events during an investigation.
What Is Integration Services and Why Do I Need It?
Mar 9, 2009
Kirk Haselden provides a brief introduction to SQL Server 2008 Integration Services.
Sams Teach Yourself JavaScript and Ajax Video Learning: A JavaScript Library for Ajax
Mar 4, 2009
This video excerpt is lesson 23 from Sams Teach Yourself JavaScript and Ajax: Video Learning.

<< < Prev Page 4 5 6 7 8 Next >