#10: SQL

Most enterprise applications today use databases to keep track of their content. SQL is supported by every modern relational database, so learning how to use it means you can apply your knowledge to MS Access, SQL Server, Oracle, and DB2, to name just a few. While each database vendor has its own proprietary flavor of SQL, all support most of the basic SQL standard features.

Articles:
Make SQL Server Respond to an ORDER BY Clause
Using SQL’s EXISTS Predicate to Identify Missing Data
Understanding and Calculating Dates
Going Off the Beaten DB Path
MySQL: A Lot More Going for It Than No Price Tag
Leveraging SQL Server’s XML Features
Customize XML Data with SQL Server
Access SQLXML Technology from .NET Apps
Use New SQL Server Datatypes
Use SQL Server Triggers to Track Unauthorized Database Changes
Get Your SQL Server Questions Answered
Tune Up SQL Server Performance
Use New SQL Server Datatypes
Search Databases the .NET Way
DB2 Explains Itself: A Roadmap to Faster Query Runtime
Mastering Top-N and OLAP Queries in DB2
DB2: Tame Beastly Data with Summary Tables
Concurrency Handling in Oracle: Preventing Locked Data
Oracle Basics: Querying an Oracle Database
Oracle Concepts: The Instance and the Database
Performing Top-N Queries in Oracle
Finding and Eliminating Duplicate Data

Classes:
DevX eLearning: Technical Microsoft Package
Basic SQL Tutorial
Free Online SQL Course and Tutorials

Good Links:
Microsoft SQL Server Home
SQL Server Magazine
SQLServerCentral.com
A Gentle Introduction to SQL

Discussion Groups:
DevX enterprise.sql Discussion Group

Book:
A Visual Introduction to SQL, by David Chappell and J. Harvey Trimble.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS

homes in the real estate industry

Exploring the Latest Tech Trends Impacting the Real Estate Industry

The real estate industry is changing thanks to the newest technological advancements. These new developments — from blockchain and AI to virtual reality and 3D printing — are poised to change how we buy and sell homes. Real estate brokers, buyers, sellers, wholesale real estate professionals, fix and flippers, and beyond may