Subscribe: About.com Databases: Most Popular Articles
http://z.about.com/6/o/m/databases_p2.xml
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
access database  access  data  database  databases  learn  microsoft access  microsoft  query  server  sql server  sql  tables 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: About.com Databases: Most Popular Articles

About.com Databases: Most Popular Articles



These articles are the most popular over the last month.



Published: Sun, 19 Feb 2017 11:20:02 +0000

 



The Basics of Normalizing a Database

2017-02-19T11:20:02Z

Database normalization can save storage space and ensure the consistency of your data. Learn the basics in this introductory article.



Basic Keys That Make Database Management Easy

2017-02-19T11:20:02Z

As you may already know, databases use tables to organize information. Each table consists of a number of rows, each of which corresponds to a single database record. So, how do databases keep all of these records straight? It’s through the use of keys.



If you Think You're a Dummy, Learn the Basics...

2017-02-19T11:20:02Z

Think you're a database dummy? This article discusses basic database concepts, including the structure of a database and typical database programs.



Learn About Referential Integrity in a Database

2017-02-19T11:20:02Z

Referential integrity is a database concept that maintains a consistent relationship between tables in the database and reduces errors.



Foreign Keys in Microsoft SQL Server

2017-02-19T11:20:02Z

One of the most important concepts in databases is creating relationships between database tables. These relationships provide a mechanism for linking data stored in multiple tables and retrieving it in an efficient fashion. In order to create a link between two tables, you must specify a foreign key in one table that references a column in another table.



Understanding 'Facts' and 'Dimensions' Tables...

2017-02-19T11:20:02Z

Facts and dimensions form the core of any business intelligence effort. In this article, we look at the development and use of facts and dimensions.



SQL Server Constraints

2017-02-19T11:20:02Z

SQL Server constraints allow you to enforce rules in your database. These rules may affect business logic, database integrity and/or table structures. Each one plays an important role in your database architecture.



Database 101: What is a Primary Key?

2017-02-19T11:20:02Z

What is a primary key? What is it for and how is it used? This article provides a definition of the term as well as examples.



How to Put a Database in Second Normal Form (2NF)

2017-02-19T11:20:02Z

Second Normal Form allows you to enhance the normalization of your database. In this article, we explore the requirements of 2NF and the process of normalizing your database.



How SQL Helps You Talk to Your Database

2017-02-19T11:20:02Z

The Structured Query Language (SQL) is the language used to interact with modern relational databases.



A Quick Guide to Understanding Database...

2017-02-19T11:20:02Z

Database dependencies are a topic that often confuses both students and database professionals alike. Fortunately, they are not that complicated.



Answers to Common Structured Query Language...

2017-02-19T11:20:02Z

Looking for advice on using the Structured Query Language? The About Databases SQL FAQ provides answers to the most frequently asked questions about SQL and databases.



Almost Every Web Page you Visit Has SQL Behind It

2017-02-19T11:20:02Z

The Structured Query Language (SQL) is the set of instructions used to interact with a relational database.



How To Back Up a Microsoft Access Database

2017-02-19T11:20:02Z

Backing up your Microsoft Access databases is an important part of protecting your critical data. In this tutorial, we walk through the process of backing up an Access database, step-by-ste.



Database Terms You Need to Know

2017-02-19T11:20:02Z

Glossary of database terms used commonly in many database management systems.



How to Choose a Primary Key for Your Database,...

2017-02-19T11:20:02Z

Choose your database's primary keys carefully, ensuring they are unique and will never need to be changed. A bad choice is a ZIP code or Social Security number.



Microsoft Access 2013 Fundamentals

2017-02-19T11:20:02Z

Are you overwhelmed by the large quantities of data that need to be tracked in your organization? Perhaps you're currently using a paper filing system, text documents or a spreadsheet to keep track of your critical information. If you're searching for a more flexible data management system, a database might be just the salvation you're looking for and Microsoft Access 2013 provides an excellent option.






4 Types of Database Relationships

2017-02-19T11:20:02Z

Relationships allow you to describe the connections between different database tables in a relational database in powerful ways.



A Quick Guide to Database Normalizing with...

2017-02-19T11:20:02Z

In this article, we begin our look at the first of three major normal forms -- first normal form (otherwise known as 1NF).



5 Things Beginners Need to Know About Databases

2017-02-19T11:20:02Z

Just getting started with databases? Here's a rundown of the top things that I wish I knew before I got started in the field. These facts are guaranteed to make your life easier!



How to Retrieve Data with SQL Queries: SELECT...

2017-02-19T11:20:02Z

Learn to retrieve information from your database with the SQL SELECT statement.



How to Select Data Within Ranges in SQL

2017-02-19T11:20:02Z

Using SQL SELECT queries, you can retrieve data in a range using the WHERE clause.



Use the Northwind Sample Database to Learn...

2017-02-19T11:20:02Z

Install the Northwind sample database for Microsoft Access 2013. This database contains some great sample tables, queries, reports and other database features useful for learning Access.



Compatibility between Access formats ACCDB and...

2017-02-19T11:20:02Z

The ACCDB Access file format has been the default Access file format since its 2007 release. Learn its benefits and how to convert between it and the older format, MDB.






How to Choose a User Friendly Database for Your...

2017-02-19T11:20:02Z

Do a careful needs analysis before you dive in and commit to a database solution. Learn the difference between desktop and server databases.



Databases for Retail Shops

2017-02-19T11:20:02Z




The Top 6 Books Every SQL Enthusiast Should Read

2017-02-19T11:20:02Z

Looking for a book to help you get started with Structured​ Query Language? Need a new reference book for your shelf? Check out my favorite SQL books.



How To Install the Northwind Sample Database

2017-02-19T11:20:02Z

The Northwind database contains some great sample tables, queries, reports and other database features. Here's how to install it.



How the ACID Model Ensures Your Data is Safe

2017-02-19T11:20:02Z

Database management systems ensure data integrity through the ACID protocol: Atomicity, Consistency, Isolation and Durability.



Metadata is following you, everywhere you go.

2017-02-19T11:20:02Z

With this metadata definition, find out how metadata describes data itself and is used in almost every industry.



How To Create a Genealogy Database in Microsoft...

2017-02-19T11:20:02Z

Are you interested in tracing your family roots but don’t have a good place to store all of your genealogical information? While there are several full-featured family tree software packages on the market, you can also use a free Microsoft Access template to create your own genealogy database on your computer. Microsoft’s already done most of the work for you, so there is no programming knowledge needed to get started.



How To Print Mailing Labels in Microsoft Access...

2017-02-19T11:20:02Z

One of the most common uses of a database is generating mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft Access 2013 using the built-in Label Wizard.



How to Build a New Access Database in SQL

2017-02-19T11:20:02Z

In this series of Microsoft Access tutorials, we follow the database admins for Patrick's Widgets as they build a Microsoft Access database.



The Fundamental Guide to SQL (Structured Query...

2017-02-19T11:20:02Z

Would you like to learn SQL? This tutorial will introduce you to the basics.



Learn the Fundamentals of Microsoft Access

2017-02-19T11:20:02Z

Want to learn how to use Microsoft Access? Find out about the fundamentals with this introduction.



Control Access Permission to Your Database...

2017-02-19T11:20:02Z

The Data Control Language (DCL) is a subset of the Structured Query Lanaguge (SQL) that allows database administrators to configure security access to relational databases.



Learn how to use criteria in Microsoft Access...

2017-02-19T11:20:02Z

Are you familiar with the use of criteria in queries? They can help you limit results in interesting ways!






Designing a database? Give your tables some...

2017-02-19T11:20:02Z

A database attribute is a column, or field, in a database table. For example, given a Customers table, a Name column is an attribute of that table.



Read about These Top 5 Databases, Both Free and...

2017-02-19T11:20:02Z

Desktop databases offer simple, flexible solutions for data storage and retrieval. Here's a rundown on the five top desktop databases for individuals and businesses.



How to Encrypt Your Access 2013 Database

2017-02-19T11:20:02Z

Password protecting an Access database allows you to protect your sensitive data from prying eyes. Encrypted databases require a password to open. Users attempting to open the database without the correct password will be denied access. Additionally, users attempting to directly access the database’s ACCDB file will not be able to view any of the data contained within it, as the encryption obscures the data from view by those without the proper password.



How To Create a Trace with SQL Server Profiler

2017-02-19T11:20:02Z

Traces allow you to track the specific actions performed against a SQL Server databases. They provide valuable information for troubleshooting database issues and tuning database engine performance. In this tutorial, we walk through the process of creating a SQL Server Trace with SQL Server Profiler, step-by-step.



Abandoning ACID in Favor of BASE

2017-02-19T11:20:02Z

The BASE model offers a completely different alternative to our traditional notions of database engineering. It abandons the relational database guiding principles of atomicity, consistency, isolation and durability in favor of a relaxed approach that allows the flexible, efficient storage of data.



Protect your Data by Normalizing it to at Least...

2017-02-19T11:20:02Z

What is a full functional dependency? Find out here!






The Quick Way to Import and Export SQL Server...

2017-02-19T11:20:02Z

The bulk copy (bcp) command of Microsoft SQL Server provides you with the ability to insert large numbers of records directly from the command line.



Query Your Database to Get the Best of It

2017-02-19T11:20:02Z

Find out how a database query can get the data you need out of your database by writing the query in the language the database requires, usually SQL.



How Third Normal Form Helps Ensure Data Accuracy

2017-02-19T11:20:02Z

In our first article, we looked at the basic requirements of 3NF. Here they are again to refresh your memory: meet the requirements of 1NF and 2NF and remove columns that are not fully dependent upon the primary key.






Ditch Your Spreadsheet for a Database to Access...

2017-02-19T11:20:02Z

Databases offer an organized mechanism for storing, managing and retrieving information. Far more powerful than spreadsheets, a database and a Database Management System can help manage and protect large amounts of data.



Choose the Best Database Software to Meet Your...

2017-02-19T11:20:02Z

Database software comes in all flavors. Here's a brief rundown on some of the primary desktop or server-based database software solutions.



Saving Queries in Access 2013

2017-02-19T11:20:02Z




How a Database Domain Protects your Data's...

2017-02-19T11:20:02Z

Find out how defining a database domain ensures your data's integrity, which ensures that all data in a field contains valid values.



How to Convert an Access Database to SQL Server...

2017-02-19T11:20:02Z

Is your Access database growing too large or unwieldy? Perhaps you need to allow more robust multiuser access to the database? Converting your Access database to Microsoft SQL Server might be the solution you’re trying to find. Fortunately, Microsoft provides an Upsizing Wizard in Access that makes it easy to convert your database. In this tutorial, we walk through the process of converting your database.



Avoid Multivalued Dependencies in your Database...

2017-02-19T11:20:02Z

A multivalued dependency occurs when the presence of one or more rows in a table implies the presence of one or more other rows in that same table.



Microsoft Access can help your small business...

2017-02-19T11:20:02Z

Learn five ways that Microsoft Access databases can help your small business succeed!



How to Create Database Relationships in Access

2017-02-19T11:20:02Z

Join us as we walk through the process of creating database relationships in Microsoft Access.



Spreadsheets vs. Databases: What's the...

2017-02-19T11:20:02Z

Should you use a spreadsheet or a database? Learn more in this article!



Your SQL Server Authentication Mode Impacts the...

2017-02-19T11:20:02Z

SQL Server authentication supports two modes: Windows authentication mode or mixed authentication mode. The mode you choose affects both the level of security and the ease of maintenance of your organization’s databases.



Database Relationships in Access 2013

2017-02-19T11:20:02Z

So you've made the move from a spreadsheet to a database. You've set up your tables and painstakingly transferred all of your precious data. You take a well-deserved break, sit back and look at the tables you've created. Wait a second -- they look strangely familiar to the spreadsheets you've just disowned. Did you just reinvent the wheel? What's the difference between a spreadsheet and a database anyway?



How to Create a Simple Query in Microsoft Access

2017-02-19T11:20:02Z

Learn how to create a simple query in Microsoft Access.



A Foreign Key Opens the Door to a Whole World...

2017-02-19T11:20:02Z

Here, we define a database foriegn key and provide examples for understanding its relationship to a table's primary key.



Relationships are the Basis for Relational...

2017-02-19T11:20:02Z

Understand the definition of a database relationship, which is behind all relational databases.



How a Database Management System Works

2017-02-19T11:20:02Z

A database management system allows a computer to perform database functions of storing, retrieving, adding, deleting and modifying data.



A Quick Guide to Recovering Data in a Disaster

2017-02-19T11:20:02Z

SQL Server provides three recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster: Simple, Full and Bulk logged.



Printing Query Results in Access 2013

2017-02-19T11:20:02Z

Access offers users a way to print queries and their results. This provides users with a way to later review the results if they cannot remember which query was used.



How to Understand an Entity-Relationship Diagram

2017-02-19T11:20:02Z

An entity-relationship diagram is a specialized graphic that illustrates the relationships between entities or concepts in a database.



How to Retrieve Data from Multiple Tables with...

2017-02-19T11:20:02Z

Learn to retrieve information from your database with the SQL SELECT statement.



Table tweaking: Three basic techniques every...

2017-02-19T11:20:02Z

Although copying, renaming or deleting tables remains a straightforward process in Microsoft Access, you'd be wise to copy your database before you adjust its internal structure.



Free Downloadable Geography Database for...

2017-02-19T11:20:02Z

This Microsoft Access sample database provides tables containing information on the world's countries, cities and provinces. It is used to illustrate examples for a number of the articles on the About Databases site and also provides a good sample for students, professionals and others who are learning Microsoft Access.



Use Regression to Predict Where You Might Live

2017-02-19T11:20:02Z

What is regression? Learn more about this data mining term here.



What is a Candidate Key?

2017-02-19T11:20:02Z

What is a Candidate Key? Find out here!



Everything You Need to Know to Start a Career...

2017-02-19T11:20:02Z

Looking for a job in the database field? This article provides the advice you need to get started.



Keep your data harmonious with Access 2013...

2017-02-19T11:20:02Z

Input masks in Microsoft Access 2013 restrict user input, preventing users from entering data in a form that doesn't meet your quality requirements.



Printing Forms in Microsoft Access

2017-02-19T11:20:02Z

While forms are most useful when accessed directly in the database, there will be times when you will want to print them, for example when you want details about a single record or if you want to create instructions and include screenshots for entering data into a form.



What Data Mining Classification Has to do with...

2017-02-19T11:20:02Z

Classification is a data mining technique that helps analyze data and predict outcomes. It is one of several such methods used to analyze big data.



k-means Clustering

2017-02-19T11:20:02Z

k-means clustering is a data mining/machine learning algorithm used to cluster observations into groups of related observations without any prior knowledge of those relationships. The k-means algorithm is one of the simplest clustering techniques and it is commonly used in medical imaging, biometrics and related fields.



How to Modify a Query in Microsoft Access

2017-02-19T11:20:02Z

Want to learn how to modify a query in Microsoft Access? This is the help you need.



Understand the Difference Between a Database...

2017-02-19T11:20:02Z

A database instance is the entire database environment, but vendors may use the term in a specific way.



What is the Definition of a Determinant in a...

2017-02-19T11:20:02Z

What is a determinant? Find out here!



How to Create Data Input Forms for Your Database

2017-02-19T11:20:02Z

Part 7 of our tutorial introduces you to the concept of Access forms to input and modify data.



Ensure Accurate Data Using Functional...

2017-02-19T11:20:02Z

What is a functional dependency in a database? Find out why FC is important in ensuring the accuracy of your data.



Free Downloadable ZIP Codes Database for...

2017-02-19T11:20:02Z

This free Access database of ZIP codes provides database designers with a valuable tool to assist in mapping ZIP codes to a city/state pair and also provides the latitude and longitude of that location.



How To Compact and Repair an Access 2013 Database

2017-02-19T11:20:02Z

Over time, Microsoft Access databases grow in size and unnecessarily use disk space. Additionally, repeated modifications to the database file may result in data corruption. Therefore, it's a good idea to periodically run the compact and repair database tool to ensure the consistency of your data.



Break a Rule: Sometimes It's OK To Denormalize...

2017-02-19T11:20:02Z

Database normalization is a basic tenet of database application development, but it's not always absolutely necessary. Here's a look at when you might not need to normalize.



How to Convert Excel Spreadsheets into Access...

2017-02-19T11:20:02Z

Let us walk you through the process of converting your Excel spreadsheet to a flexible Access 2013 database.



Data Classification: A Simple Approach

2017-02-19T11:20:02Z

Many organizations avoid the challenge of data classification because they consider it a burdensome, difficult effort. In fact, it’s likely that organizations without actively used data classification policies have tried implementing such a policy in the past and failed, never to try again. In this article, I offer you some practical advice for getting a data classification effort off the ground and applying it to your sensitive information.



A Database Relation Might not be What You Think

2017-02-19T11:20:02Z

A database relation is the same as a database table, and is governed by a series of constraints that ensure data integrity.



Transitive Dependencies Can Creep Into Your...

2017-02-19T11:20:02Z

A transitive dependency in a database is an indirect relationship between values in the same table that causes a functional dependency and thus results in de-normalization.



How to Create Entity-Relationship Diagrams

2017-02-19T11:20:02Z

Entity Relationship diagrams provide database designers with a valuable tool for modeling the relationships between database entities in a clear, precise format. Learn how to create basic diagrams for your databases with this guide.



Save Time Creating an Excel Address File with...

2017-02-19T11:20:02Z

Sample Excel Document. Databases.



Getting Started in Microsoft Access Reports

2017-02-19T11:20:02Z

Would you like to create professional-looking reports from your Microsoft Access database with the click of a mouse? Follow along as we walk through the simple process of designing a reusable report.



How To View and Edit SQL in Microsoft Access

2017-02-19T11:20:02Z

Editing the raw SQL powering a Microsoft Office query is straightforward -- and Access conforms well to ANSI-standard SQL syntax.






A Quick Guide to Using Inner Joins in SQL to...

2017-02-19T11:20:02Z

You can use SQL JOIN statements to combine data from three or more tables. Here you'll see how to accomplish this goal for an inner join.



Grab This Free Area Code Database for Your MS...

2017-02-19T11:20:02Z

This free Access database of area codes provides database designers with a valuable tool to assist in mapping area codes to a state, province or region.



Database Certifications to Kick Start your Career

2017-02-19T11:20:02Z

Database certifications from major database vendors including Microsoft, Oracle, MySQL and IBM.



How to Create Dynamic Webpages with Microsoft...

2017-02-19T11:20:02Z

Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.