Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

#10: SQL

Most enterprise applications today use databases to keep track of their content, and since SQL is supported by every modern relational database, you can apply your SQL knowledge to MS Access, SQL Server, Oracle, and DB2, to name just a few. This compilation of resources will get you on your way.


advertisement
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.



   
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date