2017-03-13T11:02:18ZWhile many professions benefit from a well-designed and constructed database, the real estate industry is one area where databases are an absolute necessity. For Realtors, their database can make or break them
2017-03-13T11:02:18ZFacts and dimensions form the core of any business intelligence effort. In this article, we look at the development and use of facts and dimensions.
2017-03-13T11:02:18ZUnderstand the definition of a database relationship, which is behind all relational databases.
2017-03-13T11:02:18ZSQL 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.
2017-03-13T11:02:18ZThe Structured Query Language (SQL) is the set of instructions used to interact with a relational database.
2017-03-13T11:02:18ZThink you're a database dummy? This article discusses basic database concepts, including the structure of a database and typical database programs.
2017-03-13T11:02:18ZReferential integrity is a database concept that maintains a consistent relationship between tables in the database and reduces errors.
2017-03-13T11:02:18ZDatabases 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.
2017-03-13T11:02:18ZGlossary of database terms used commonly in many database management systems.
2017-03-13T11:02:18ZWhat 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.
2017-03-13T11:02:18ZDatabase normalization can save storage space and ensure the consistency of your data. Learn the basics in this introductory article.
2017-03-13T11:02:18ZSecond 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.
2017-03-13T11:02:18ZRelationships allow you to describe the connections between different database tables in a relational database in powerful ways.