Topics
Content Types
About 12 results
-
Inserting and updating records in SQL
After you've developed your skills in mining SQL table data, the next step is to learn how to add and update records. Follow this quick tutorial on using the INSERT and UPDATE comm...
-
SQL JOINs make it easy to find and fix missing data
Many people are confused by various JOIN operations supported by SQL. Learn to master the SQL command line with this crash course in JOIN syntax.
-
Data-mining tips for the SQL command line
Do you know how to thin-slice your SQL database from the command line? Use these syntax shortcuts to get the facts you need.
-
Fine-tune WHERE clauses in SQL
Don't waste your time and system resources by performing inefficient SQL searches. Use these tools to craft WHERE clauses that will narrow your search to exact matches, close match...
-
Another crash course in SQL
Does knowing how to query a table from an SQL command line come in handy in your IT shop? In this crash course in SQL, learn how to query two or more tables at once.
-
Support your company mailing list
Effectively managing the snail mail database in your shop can pay off in better records and more donations. Find out how a nonprofit agency?s updated Access database is a help to i...
-
A crash course in SQL
Frustrated because you don't know or understand SQL? Here's a crash course to help you get started.
-
The right way to manage data entry
When you're building a database, you can't afford to mismanage the data entry process. Heed this advice from Jeff Davis to make sure you don't wind up with "garbage in."
-
The golden rule of disaster prevention
Attention, system and database administrators everywhere: Here are five little words that might save your company a ton of money in disaster recovery.
-
From the forums: What's the best way to document database relationships?
In this thread from TechRepublic's Programming forum, an SQL developer needs a tool to help document the relationships between 800 tables.