Login
Copyright

Ch 5: Database Management Systems & Architecture

About This Chapter

Within these informative lessons, you will go over essential information for understanding database management systems and architecture. Our instructors will teach you about how these systems can benefit the way your organization manages data.

Database Management Systems & Architecture: Chapter Summary

With the amount of data that organizations review, the amount of databases is often too much for a regular person to handle, which is why professionals today need a better understanding of database management systems and the architecture involved in creating these systems. This chapter has been designed to show you the basics of database management, including its purpose, command codes, related architecture programs, and more. As you go from lesson to lesson, your knowledge about this topic will grow, and you will learn the skills necessary to help you implement better database management practices in your own place of business.

Since all of our resources are available online and around the clock, you can study this information before, after, or even during business hours. In addition, all you need is an Internet connection to study these concepts at home or on-the-go. You can even take this chapter to a training seminar to train your fellow employees.

After you go through this chapter, you will have sharpened your skills and you will be ready to do the following:

  • Evaluate various models of database management systems (DBMS)
  • Figure out the function and purpose of DBMS
  • Identify DBMS advantages
  • Apply common SQL commands in DBMS
  • Name ACID properties in DBMS
  • Describe the best practices in data management
  • Identify the normal form of various types of DBMS
  • Analyze examples of the first and third normal form
  • Check out the types and design of big data databases
  • Define architecture patterns in big data
  • Examine Lambda architecture

12 Lessons in Chapter 5: Database Management Systems & Architecture
Models of Database Management Systems (DBMS)

1. Models of Database Management Systems (DBMS)

Get to know the different models of database management systems and learn how each one is used to systematically organize large amounts of data in a logical manner.

What is a Database Management System? - Purpose and Function

2. What is a Database Management System? - Purpose and Function

In this lesson, we will describe the purpose and functions of a database management system, as well as the advantages and disadvantages of using a database management system in an organization.

Advantages of Database Management Systems (DBMS)

3. Advantages of Database Management Systems (DBMS)

In this lesson, we will learn what a Database Management System is and the advantages of its use. We appreciate the short falls of the old flat file systems and see how data integrity consistencies and securities are ensured.

Basic SQL Commands in Database Management Systems (DBMS)

4. Basic SQL Commands in Database Management Systems (DBMS)

Basic SQL commands allow the user to achieve significant manipulation of data in the database. The database management system is the software that allows access to the database and to apply SQL commands to manage data.

ACID Properties in Data Base Management Systems (DBMS)

5. ACID Properties in Data Base Management Systems (DBMS)

In this lesson we are going to examine the ACID properties of a database management system. We will examine the properties of atomicity, consistency, isolation, and durability, which when adhered to constitute an accurate, robust, and stable database.

Data Management Best Practices

6. Data Management Best Practices

In this lesson, we will learn what data management is all about, data life-cycle and the best practices to ensure during and after data design and implementation.

What is Normal Form in DBMS? - Types & Examples

7. What is Normal Form in DBMS? - Types & Examples

This lesson explains the concept of correcting table structures in order to minimize database anomalies through a process called normalization. The normal process consists of multiple steps, called normal forms, each ensuring the elimination of the various types of anomalies.

First Normal Form in DBMS with Examples

8. First Normal Form in DBMS with Examples

First Normal Form might sound like the place to be if you're a database. But being first has its drawbacks. This lesson will define first normal form and provide real-world examples.

Third Normal Form in DBMS with Examples

9. Third Normal Form in DBMS with Examples

Normalization in databases help organize tables and keeps records clean. This lesson will cover the third normal form of database normalization which, through the extension of the second normal form (2NF), further reduces dependencies within the data.

Big Data Database Design & Types

10. Big Data Database Design & Types

Big Data is becoming the standard in business today. In this lesson, we'll take a look at databases, Big Data, what is unique about Big Data database design, and some types of Big Data databases.

Big Data Architecture Patterns

11. Big Data Architecture Patterns

More and more, businesses are relying on big data to find answers to their questions. In this lesson, we'll take a look at big data, the architectures it uses, and some patterns associated with those architectures.

Lambda Architecture in Big Data

12. Lambda Architecture in Big Data

Big Data is becoming a focus point for many companies these days. In this lesson, we'll take a look at Big Data, and an architecture proposed that could simplify working with it. At the end of the lesson, you should have a good understanding of these relevant topics.

Earning College Credit

Did you know… We have over 95 college courses that prepare you to earn credit by exam that is accepted by over 2,000 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Other Chapters

Other chapters within the Big Data Tutorial & Training course

Support