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  information  microsoft access  microsoft  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, 25 Sep 2016 11:20:40 +0000

 



The Basics of Normalizing a Database

2016-09-25T11:20:40Z

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



Foreign Keys in Microsoft SQL Server

2016-09-25T11:20:40Z

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.



Basic Keys That Make Database Management Easy

2016-09-25T11:20:40Z

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.



Here's What 'Referential Integrity' Is in a...

2016-09-25T11:20:40Z

Referential integrity is a database concept that ensures that relationships between tables remain consistent. Find more information here.



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

2016-09-25T11:20:40Z

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.



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

2016-09-25T11:20:40Z

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.



SQL Server Constraints

2016-09-25T11:20:40Z

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?

2016-09-25T11:20:40Z

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.



A Quick Guide to Exporting Access Tables to Excel

2016-09-25T11:20:40Z

Microsoft Access allows you to export data to a variety of formats for sharing and analysis. In this tutorial, we walk through the process of exporting an Access table to an Excel workbook.



Introduction to SQL

2016-09-25T11:20:40Z

The Structured Query Language (SQL) is the language of databases. All modern relational databases, including Access, FileMaker Pro, Microsoft SQL Server and Oracle use SQL as their basic building block. In fact, it’s often the only way that you can truly interact with the database itself.



A Quick Guide to Understanding Database...

2016-09-25T11:20:40Z

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



The Beginner's Guide to Databases, SQL, and...

2016-09-25T11:20:40Z

Are you new to the world of databases? Wondering where to get started? In this series of articles, we introduce you to the basics of database technology and help you get started in this exciting field.



How To Back Up a Microsoft Access Database

2016-09-25T11:20:40Z

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.



Answers to Common Structured Query Language...

2016-09-25T11:20:40Z

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.



What is SQL?

2016-09-25T11:20:40Z

The Structured Query Language (SQL) is the set of instructions used to interact with a relational database. In fact, SQL is the only language that most databases actually understand. Whenever you interact with such a database, the software translates your commands (whether they are mouse clicks or form entries) into SQL statement that the database knows how to interpret.



4 Types of Database Relationships

2016-09-25T11:20:40Z

Relationships allow you to describe the connections between different database tables in powerful ways. Once you’ve described the relationships between your tables, you can later leverage that information to perform powerful cross-table queries, known as joins.



The Top 6 Books Every SQL Enthusiast Should Read

2016-09-25T11:20:40Z

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.



A Quick Guide to Database Normalizing with...

2016-09-25T11:20:40Z

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



Microsoft Access 2013 Fundamentals

2016-09-25T11:20:40Z

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.



Reports in Microsoft Access 2013

2016-09-25T11:20:40Z

Microsoft Access 2013 allows you to easily create professionally formatted reports automatically from information stored in a database. In tis tutorial, we're going to design a nicely-formatted listing of employee home telephone numbers for the use of management using the Northwind sample database and Access 2013.



How to Select Data Within Ranges in SQL...

2016-09-25T11:20:40Z

The Structured Query Language (SQL)provides database users with the ability to create customized queries to extract information from databases. In an earlier article, we explored extracting information from a database using SQL SELECT queries. Let's expand upon that discussion and explore how you can perform advanced queries to retrieve data that matches specific conditions.



Importing and Exporting Data With SQL Server 2014

2016-09-25T11:20:40Z

The SQL Server Import and Export Wizard is a component of SQL Server Integration Services (SSIS) that facilitates the transfer of information between your SQL Server databases and other data sources, including Microsoft Excel, Microsoft Access and flat files.



5 Things Beginners Need to Know About Databases

2016-09-25T11:20:40Z

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 Use Updated Access File Formats

2016-09-25T11:20:40Z

The release of Access 2007 brings a new file format. The MDB database files we’ve known for over a decade are now slated to become historical relics. While Access 2007 continues to support MDB databases for backwards compatibility purposes, Microsoft has now introduced the new ACCDB file format as the future standard. Wondering if you should begin using the ACCDB format?



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

2016-09-25T11:20:40Z

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.



Building an Access Database in Office 365

2016-09-25T11:20:40Z

Looking for an easy way to move your Microsoft Access database to the cloud? Microsoft's Office 365 service provides a central location.



All the Database Terms You Need to Know and How...

2016-09-25T11:20:40Z

Glossary of database related terms, including definitions, explanations, examples, suggested reading, and other resources.



What's a Query?

2016-09-25T11:20:40Z

What is a query? Find out here! Databases.



How To Install the Northwind Sample Database

2016-09-25T11:20:40Z

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



What is a Database?

2016-09-25T11:20:40Z

Databases are designed to offer an organized mechanism for storing, managing and retrieving information. They do so through the use of tables. If you’re familiar with spreadsheets like Microsoft Excel, you’re probably already accustomed to storing data in tabular form. It’s not much of a stretch to make the leap from spreadsheets to databases.



How to Build a New Access Database in SQL

2016-09-25T11:20:40Z

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



How to Choose a 'Primary Key' for Your Database

2016-09-25T11:20:40Z

Databases depend upon keys to store, sort and compare records. If you’ve been around databases for a while, you’ve probably heard about many different types of keys – primary keys, candidate keys, and foreign keys. When you create a new database table, you’re asked to select one primary key that will uniquely identify records stored in that table.



How to Choose the Right Database for Your...

2016-09-25T11:20:40Z

It's important to do a careful needs analysis before you dive in and commit to a database solution. Learn the difference between desktop and server databases.



Retrieving Data with SQL Queries: Introducing...

2016-09-25T11:20:40Z

Learn to retrieve information from your database with the SQL SELECT statement. Your About.com Guide to Databases provides a thorough introduction.



How to Create User Accounts in SQL Server 2014

2016-09-25T11:20:40Z

SQL Server 2014 provides a wide range of security features designed to help you protect the confidentiality, integrity and availability of data stored in your enterprise databases. One of the most important tasks that database administrators perform is the implementation of role-based access control that limits the ability of users to retrieve and modify data in the database unless they have an explicit business need to do so.



Understanding Structured Query Language (SQL)...

2016-09-25T11:20:40Z

Most large-scale databases use the Structured Query Language (SQL) to define all user and administrator interactions. This language offers a flexible interface for databases of all shapes and sizes.



How To Create a Genealogy Database in Microsoft...

2016-09-25T11:20:40Z

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.



Guide to Data Control Language (DCL): Database...

2016-09-25T11:20:40Z

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. It complements the Data Definition Language (DDL), which is used to add and delete database objects, and the Data Manipulation Language (DML), which is used to retrieve, insert and modify the contents of a database.



Learn the Fundamentals of Microsoft Access

2016-09-25T11:20:40Z

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



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

2016-09-25T11:20:40Z

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.



Multivalued Dependency

2016-09-25T11:20:40Z

What is a multivalued dependency? Find out here!



The Fundamental Guide to SQL (Structured Query...

2016-09-25T11:20:40Z

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



Attribute

2016-09-25T11:20:40Z

An attribute, when in regards to databases, deals with single data in an object. It is one of the basic terms used in SQL.



How to Choose an SQL Server Authentication Mode

2016-09-25T11:20:40Z

Microsoft SQL Server 2008 offers administrators two choices of performing user authentication: Windows authentication mode and mixed authentication mode. Making the proper choice affects both the security and maintenance of your organization’s databases.



Domain

2016-09-25T11:20:40Z

What is the domain of a database? Find out here!



Top 5 Desktop Databases

2016-09-25T11:20:40Z

Desktop databases offer simple, flexible solutions for data storage and retrieval. They're often quite sufficient to meet uncomplicated database requirements for both small and large organizations. If you're not sure if a desktop database is right for you, try reading the Choosing a Database series of articles which cover both desktop and server databases in depth



Metadata

2016-09-25T11:20:40Z

What is metadata? Find out here!



Microsoft Access Databases in Office 365

2016-09-25T11:20:40Z

With the release of Microsoft Office 365 in 2013, there were a number of questions about how it changed the different Microsoft programs, including Microsoft Access.



How to Encrypt Your Access 2013 Database

2016-09-25T11:20:40Z

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.



Migrating to SQL Server with the Access...

2016-09-25T11:20:40Z

Many database users begin their adventure in the world of databases by creating a Microsoft Access database that meets the basic requirements of their organizations. Often, this is a dramatic improvement from an unwieldy collection of spreadsheets, text files or other documents that the organization previously used to manage information. However, eventually the business may outgrow that Access database and need to make the move to a more advanced database product.



Everything You Need to Know about the ACID...

2016-09-25T11:20:40Z

All database management systems should share four characteristics: Atomicity, Consistency, Isolation and Durability.



How To Create a Trace with SQL Server Profiler

2016-09-25T11:20:40Z

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.



Learn how to use criteria in Microsoft Access...

2016-09-25T11:20:40Z

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



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

2016-09-25T11:20:40Z

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.



Wondering what a "Foreign Key" Is? Here's the...

2016-09-25T11:20:40Z

What is a foreign key? Find out here!



How to Put a Database in Third Normal Form

2016-09-25T11:20:40Z

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.



A Beginner's Guide to 'Data Mining'

2016-09-25T11:20:40Z

Data mining allows you to find the needles hidden in your haystacks of data. Learn how to use these advanced techniques to meet your business objectives.



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

2016-09-25T11:20:40Z

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



Database Relationships in Access 2013

2016-09-25T11:20:40Z

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?



Retrieving Data from Multiple Tables with SQL...

2016-09-25T11:20:40Z

SQL joins allow you to retrieve data from multiple database tables. Your About.com Guide to Databases provides a comprehensive introduction.



Retreiving Data with the SELECT Statement

2016-09-25T11:20:40Z

The SELECT command is the most commonly used command in SQL. It allows database users to retrieve the specific information they desire from an operational database.



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

2016-09-25T11:20:40Z

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



Wondering What a Database Management System Is?...

2016-09-25T11:20:40Z

The software that allows a computer to perform database functions of storing, retrieving, adding, deleting and modifying data.



Should I Normalize My Database?

2016-09-25T11:20:40Z

Database normalization is one of the sacred cows of application development. Every undergraduate programming course you’ve taken or book you’ve read likely preaches about the importance of normalizing databases in an almost religious fashion. You’re made to feel like failure to normalize a database is tantamount to violating one of the laws of the universe. It’s time to challenge that truism. Sometimes it’s OK to denormalize your database



Full Functional Dependency

2016-09-25T11:20:40Z

What is a full functional dependency? Find out here!



Abandoning ACID in Favor of BASE

2016-09-25T11:20:40Z

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.



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

2016-09-25T11:20:40Z

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.



Copying, Renaming and Deleting Tables in...

2016-09-25T11:20:40Z

Copying, renaming and deleting tables in Microsoft Access often causes confusion for database administrators. In this article, we clarify the differences between the three operations and explain how to perform each.



Database Design from the Ground Up

2016-09-25T11:20:40Z

In this course, we explore the basics of database design. Ten weekly lessons each explore a different issue in database design, culminating in a final case study.



Which Edition of Microsoft's SQL Server 2014 is...

2016-09-25T11:20:40Z

Microsoft’s release of the SQL Server 2014 enterprise database management platform marks a major evolution in this popular product. Organizations seeking to license Microsoft's SQL Server database platform should have a clear understanding of the various editions available before making a purchase.



Database Relationships

2016-09-25T11:20:40Z

Looking for a definition of a database relationship? Check out the About Databases glossary definition!



Microsoft Access can help your small business...

2016-09-25T11:20:40Z

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



Entity-Relationship Diagrams

2016-09-25T11:20:40Z

Entity Relationship diagrams (also known as E-R or ER diagrams) provide database designers with a valuable tool for modeling the relationships between database entities in a clear, precise format. This industry standard approach uses a series of block shapes and lines to describe the structure of a database in a manner understandable to all database professionals. Many database software packages, including Microsoft Access, SQL Server, and Oracle, provide automated methods to quickly create E-R diagrams from existing databases.



What is a Candidate Key?

2016-09-25T11:20:40Z

What is a Candidate Key? Find out here!



Wondering What "Functional Dependency" Is in...

2016-09-25T11:20:40Z

What is a functional dependency? Find out here!



How to Understand an Entity-Relationship Diagram

2016-09-25T11:20:40Z

An entity-relationship (ER) diagram is a specialized graphic that illustrates the relationships between entities in a database.



A Quick Guide to Using Recovery Models in SQL...

2016-09-25T11:20:40Z

SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster. Each of these models represents a different approach to balancing the tradeoff between conserving disk space and providing for granular disaster recovery options.



Printing Query Results in Access 2013

2016-09-25T11:20:40Z

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.



Free Downloadable Geography Database for...

2016-09-25T11:20:40Z

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.



How To View and Edit SQL in Microsoft Access

2016-09-25T11:20:40Z

Did you know that you can view and edit the SQL statements that drive every Microsoft Access database query? In this article, we take a look at the process of accessing the underlying SQL code and tweaking it to perfect Access queries.



Databases for Marketing Professionals

2016-09-25T11:20:40Z

As a marketing professional you already deal with so many apps and software packages you are probably wondering why you should have to deal with something that is designed specifically for databases. After all, you probably already have a number of Excel spreadsheets to handle calculations, contacts and email templates in your preferred email software, and marketing campaigns recorded in a third program. This is exactly why you can benefit from an app or program that offers the organization of a database; it provides a centralized program to keep all of your information current from a single location instead of needing all of the different apps and programs.



k-means Clustering

2016-09-25T11:20:40Z

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.



Creating an Access Database from Scratch

2016-09-25T11:20:40Z

In an earlier article, we reviewed the process for creating an Access database from a template. While this is certainly an agreeable, easy approach to building a database, there isn’t always a template available that meets your needs. In this article, we review the process for creating an Access database from scratch.



Copying Tables in Microsoft Access 2013

2016-09-25T11:20:40Z

Copying tables in Microsoft Access can be tricky, not because it is particularly difficult, but because there are a number of things you need to consider before you begin. Naturally, there are a lot of things you need to avoid as well, because having two copies of the same table will significantly skew your data.



SQL Server Administration (70-228) Practice Exam

2016-09-25T11:20:40Z

Looking to prove your SQL Server Administration mettle? This quiz will help you prepare for Microsoft's 70-228 exam: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition. This is a critical step toward earning your Microsoft Certified Database Administrator credential.



Free Downloadable ZIP Codes Database for...

2016-09-25T11:20:40Z

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 even provides the latitude and longitude of that location.



How to Create Data Input Forms (Database)

2016-09-25T11:20:40Z

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



Installing MySQL on Windows 8

2016-09-25T11:20:40Z

The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.



3 Database Software Options

2016-09-25T11:20:40Z

You've finally buckled down and decided that it's time to purchase a database solution for your home or business. What type of database do you need? It's actually a simple matter of deciding what features you need and choosing a product that meets your requirements and doesn't cause too much pain in your pocketbook.



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

2016-09-25T11:20:40Z

What is a determinant? Find out here!



Input Masks in Microsoft Access 2013

2016-09-25T11:20:40Z

Do your databases contain fields where users have entered a mess of information in a variety of different formats? Microsoft Access input masks may help you alleiviate this inconsistency in your desktop databases. Input masks allow you to specify the format of allowable user input, preventing users from entering information in a form that does not meet your data quality requirements.



Create a Microsoft Access Database Using a...

2016-09-25T11:20:40Z

Microsoft provides quite a few prebuilt database templates to assist you in jumpstarting your database development process. In this tutorial, we'll walk through the process of creating an Access database using these templates.



Classification

2016-09-25T11:20:40Z

What is classification? Learn about this data mining term here.



Database Certifications

2016-09-25T11:20:40Z

Popular database certifications are always in demand, whether it's Microsoft's MCTS or MCITP, Oracle's OCA, OCP and OCM or MySql's CMA, CMDEV and CMDBA. Are you a database professional seeking to polish your resume in the hopes of landing a better gig? Database vendors offer a variety of professional certification programs that can help you advance your career while gaining valuable technical skills.



Wondering What Boyce-Codd Normal Form (BCNF)...

2016-09-25T11:20:40Z

What is Boyce-Codd Normal Form (BCNF)? Find out here!



What 'Relation' Means (Databases)

2016-09-25T11:20:40Z

What is a relation? Find out here!



How To Print Mailing Labels in Microsoft Access...

2016-09-25T11:20:40Z

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.



Transitive Dependency

2016-09-25T11:20:40Z

What is a transitive dependency? Find out here!



Database Instance

2016-09-25T11:20:40Z

Looking for a definition of a database instance? Look no further!



Data Classification: A Simple Approach

2016-09-25T11:20:40Z

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.